《DML语句》——————增删改

一、插入记录 

-- 插入记录
-- 插入全部字段
	-- 写出全部字段名(values=value,字符串和日期都需要加上双引号)
insert into student (id,name,age,birthday) values (1,'张三',20,'1999-10-10');
	-- 不写字段
insert into student values(2,'李四',22,'1997-6-6');
-- 插入多个记录
insert into student values(3,'王五',18,'2001-8-8'),(4,'赵六',30,'1989-12-12');
-- 插入部分数据(可以不按
insert into student (name,id,age) values ('钱七',5,26);
-- 蠕虫复制
create table copy_student like student;
insert into copy_student select * from student; 

二、更新表记录 

-- 更新表记录
	-- 不带条件,修改整列
update student set age = 20;
	-- 带条件
update student set age = 18 where name = '李四';
	-- 一次修改多列
update student set age = 22,birthday = '1997-12-12',name = '余余' where id = 1;

三、删除表记录

-- 删除表记录

-- 不带条件删除所有记录
delete from copy_student;
-- 带条件删除一行或多行记录
-- =,>=,<=,!=,<>
delete from student where id = 4;
-- id in(x,y,z) = or id=x or id=y or id=z
delete from student where id in(2,3);
delete from student where id=4 or id=3;
-- is null/is not NULL
delete from student where birthday is null;