MySQL data manipulation (DML) command

Inserting data

Do not specify a specific field name

INSERT [into] tbl_name values| Value (values ...);

List specified fields

INSERT [into] tbl_name (field name 1, ...) values| Value (1, ...);

Insert multiple records at one time

INSERT [into] tbl_name [(Field name,...)] Values (value,...), (value,...);

Inserting records with Set form

INSERT [into] tbl_name SET field name = value, ...;

Inserting query records into a table

INSERT [into] tbl_name [(field name, ...)] SELECT field name from Tbl_name [WHERE condition];

Update data

UPDATE tbl_name SET Field name = value, ... [WHERE condition] [ORDER by field name] [Limits limit number of bars];

Delete data

DELETE from Tbl_name [WHERE condition] [ORDER by field name] [Limit number of bars];

Clear the data sheet completely

TRUNCATE [TABLE] tbl_name;

This article is from the "zgw285763054" blog, make sure to keep this source http://zgw285763054.blog.51cto.com/11591804/1879331

MySQL data manipulation (DML) command