MySQL base DML statement

Increase

1  Insert data to all fields of a table  Insert into table name values (value 1, value 2, value 3, ..., value n),2  Insert data to the specified field of the table inserts into  table name (property 1, Property 2, ..., attribute N) Values (value 1, value 2, value 3, ..., value n),3  inserting multiple records at the same time insert into  table name [(attribute list)] VALUES (Value list 1), (Value List 2) ... (List of values n);

By deleting

DELETE from table name WHERE conditional expression

Change

UPDATE Table Name set property name 1= value 1, property name 2= value 2, ..., attribute name n= value nwhere conditional expression;

Check

Cond

Single-Table Query

Exists http://www.nowamagic.net/librarys/veda/detail/639

MySQL base DML statement