First, insert data record
1. Insert the full data record
INSERT into table_name
VALUES (Value1,value2......valuen);
2. Inserting part of a data record
INSERT into table_name (field1,field2,... FIELDN)
VALUES (Value1,value2......valuen);
3. Inserting more than one data record
INSERT into table_name
VALUES (VALUE11,VALUE21......VALUEN1),
(VALUE12,VALUE22......VALUEN2),
。。。
(Value1n,value2n......valuenn);
INSERT into table_name (field1,field2,... FIELDN)
VALUES (VALUE11,VALUE21......VALUEN1),
(VALUE12,VALUE22......VALUEN2),
。。。
(Value1n,value2n......valuenn);
4. Insert Query Results
INSERT into table_name1 (field11,field21,... fieldn1)
SELECT field21,field22,... fieldn2
From Table_name2 WHERE ...
Second, update the data record
1. Updating specific data records
UPDATE table_name
SET Field1=value1,
Field2=value2,
...
Fieldn=valuen
WHERE CONDITION;
2. Update so the data record
UPDATE table_name
SET Field1=value1,
Field2=value2,
...
Fieldn=valuen
Third, delete data records
1. Delete specific data records
DELETE from table_name
WHERE CONDITION;
2. Delete all data records
DELETE from TABLE_NAME;
Operation of MySQL Data