MySQL (CAPI) VC instance and Code Download (1) _ PHP Tutorial

MySQL (CAPI) VC instance and Code Download (1 ). 1. note: copy a table (copy only structure, source table name: a new table name: B) SQL: select * intobfromawhere112. description: copy a table (copy data, source table name: a target table name: B) SQL: inser 1. description: copy a table (only copy structure, source table name: a new table name: B)

SQL: select * into B from a where 1 <> 1

2. description: copy a table (copy data, source table name: a target table name: B)

SQL: insert into B (a, B, c) select d, e, f from B;

3. description: displays the article, submitter, and last reply time.

SQL: select a. title, a. username, B. adddate from table a, (select max (adddate) adddate from table where table. title = a. title) B

4. description: external join query (table name 1: table a name 2: B)

SQL: select a. a, a. B, a. c, B. c, B. d, B. f from a left outer join B ON a. a = B. c

5. note: five minutes ahead of schedule reminder

SQL: select * from schedule where datediff ('Minute ', f start time, getdate ()> 5

6. note: two associated tables are used to delete information that is not in the secondary table.

SQL:

Delete from info where not exists (select * from infobz where info. infid = infobz. infid)

Note :--

SQL:

Select a. NUM, A. NAME, B. UPD_DATE, B. PREV_UPD_DATE

FROM TABLE1,

(Select x. NUM, X. UPD_DATE, Y. UPD_DATE PREV_UPD_DATE

FROM (select num, UPD_DATE, INBOUND_QTY, STOCK_ONHAND

FROM TABLE2

WHERE TO_CHAR (UPD_DATE, 'yyyy/MM') = TO_CHAR (SYSDATE, 'yyyy/MM') X,

(Select num, UPD_DATE, STOCK_ONHAND

FROM TABLE2

WHERE TO_CHAR (UPD_DATE, 'yyyy/MM') =

TO_CHAR (TO_DATE (TO_CHAR (SYSDATE, 'yyyy/MM') | '/01', 'yyyy/MM/DD')-1, 'yyyy/MM ')) y,

Replicate (only copy structure, source table name: a new table name: B) SQL: select * into B from a where 1 1 2. description: copy a table (copy data, source table name: a target table name: B) SQL: inser...