mysql插入、更新与删除数据

1、插入
插入数据INSERT INTO tb_name (name,age) VALUES ('name',10);
指定列插入INSERT INTO tb_name (name) VALUES ('name');
多值插入INSERT INTO tb_name (name,age) VALUES ('name',10),(('name1',20),('name2',30));
将查询结果插入到指定表INSERT INTO tb_name (id,name,age,info) SELECT id,name,age,info FROM tb_name2;

2、更新
UPDATE tb_name SET info='student' WHERE age BETWEN 19 AND 22;

3、删除数据
DELETE FROM tb_name;
DELETE FROM tb_name WHERE age BETWEN 19 ADN 22;