MySQL data Delete, delete, update operation

1. Inserting data

Reference: Insert

Does not specify a specific field name, the inserted data corresponds to the order in which the fields in the table are defined

INSERT [into] VALUES | VALUE (value_list);

List specified fields

INSERT [into] VALUES | Value 1, value 2,.. Value n);

Insert multiple records at one time

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

Inserting data records with set form

INSERT [into] SET Field 1=value1[, field 2=value2,... Field N=vlauen];

Inserting the results of a query into a table

INSERT [into] tbl_name[(field name,...) ]SELECTfrom[WHERE condition ];

2. Updating data

UPDATE SET Field 1= value 1[, field 2= value 2,.. field n= value n][WHERE where_condition][ORDER by ... ][LIMIT row_count]

3. Delete data

DELETE  from [WHERE where_condition] [ORDER by ... ][LIMIT row_count];

Empty the tabular data

TRUNCATE [TABLE] tbl_name;

MySQL data Delete, delete, update operation