MySQL-数据操作（DML）

插入，更新，删除

• –向表中插入记录

INSERT tbl_name VALUE|VALUES(值,·,·,)

INSERT cms_news VALUES(1,"This is Title","内容",'time'···)
INSERT user(usename) VALUES('queen');

• –更新用户名为4位的用户，让其已有年龄 减3

UPDATE cms_user SET age=age-3 WHERE username LIKE '____';	#4个下划线

• –更新前3条记录，让已有年龄+10

UPDATE cms_user SET age=age+10 LIMIT 3;

• –按照id降序排列，更新前3条

UPDATE cms_user SET age=age+10 ORDER BY id DESC LIMIT 3;

• –删除用户性别为男的用户，按照年龄降序排列，删除前一条记录

DELETE FROM cms_user WHERE sex='男' ORDER BY age DESC LIMIT 1;