Basic statement for mysql addition, deletion, modification, and query, and mysql addition, deletion, and modification
Add:
Insert
Insert into Table Name (Field 1, Field 2, Field 3 ...... Field N) values (value 1, value 2, value 3 );
If you do not declare the fields to be inserted, all fields are inserted by default.
During insertion, note the table to which you want to add, the field to which you want to add, and the value of each field.
Delete:
Delete
Delete from table name where expression;
When deleting a table, pay attention to which table data is deleted and which rows are deleted.
Change:
Update
Update table name set field 1 = value 1, Field 2 = value 2 ...... field N = value N where expression;
Pay attention to which table to modify, which fields to modify, and which values to take effect in those rows.
Query:
Select
Select * from table name where expression.