1. Data insertion
INSERT intoTABLE_NAME (column 1, column 2,...)
VALUES(value 1, value 2,....), (second), (article III) ... Note: 1) If there is data insertion for each column in the table, you do not have to specify any table name: INSERT into table name values (value 1, value 2,....) 2)to insert multiple rows of data, you can combine the UNION ALL statement. 2. Data modification
Update< table name >
Set< column name >= new value
where< conditional expressions > 3, Data deletion
Delete from < table name >
where < conditional expression >Note: deleting refers to deleting a record in a database instead of deleting a column
4.Lock data Tablewhen you are checking or patching a data table, you can lock the data table to ensure that the data table is secure:
Mysql>lock TABLE tbl_name READ; Mysql>flush TABLES; (refresh, clear cache)
Where: Lock table Tbl_name read indicates to be locked into a read-only state, in which case the user can only read the data table and cannot write. Lock TABLE Tbl_name Write is a more restrictive lock that the user cannot read or write to
Work to lock the data table before checking or patching. After completion, then unlock: Mysql>unlock TABLES;
From for notes (Wiz)
"MySQL Notes" data manipulation language DML
