MySQL data insert, UPDATE, delete

(1), Data insertion Insert syntax: INSERT into table name (field name 1, field name 2,n,) VALUES (' Value 1 ', ' Value 2 ', ' Value 3 ') Example: Create TABLE Gonda (user_id int,user_name varchar (), old int,address varchar (50)); Standard data insertion: INSERT INTO Gonda (user_id,user_name,old,address) VALUES (' 111 ', ' Alvin ', ' A ', ' Gongdahanshuiliyuan '); Non-standard data insertion insert into Gonda values (' + ', ' Zhangsan ', ' $ ', ' asdfdfsdf ');  Insert multiple data inserts into Gonda values (' A ', ' Zhangsan ', ' ' max ', ' Asdfdfsdf '), (' 113, ' Lisi ', ' ' "', ' aaaaa '), (' All ', ' Lisi ', ' (' AAAAA '), (' Lisi ', ' aaaaa '), (' 118, ' Lisi ', ' + ', ' aaaaa ');(2), update the data updated Syntax: Update table name set field name 1= value 1, Field name 2= value 2.....where conditional expression (required) Example: Change single value update Gonda set old=500 where user_id=110; change multiple values update Gonda set User_name= ' Glvin ', old= ' where user_id=111; (3), delete data delete syntax: Delete from table name where Condition expression example: Delete from Gonda where user_id=110;