DML
添加数据
insert into (id,name) values (1,'张三')
批量添加
insert INTO stu(id,name,gender,birthday,score,email,tel)VALUES(1,'张三','男','2000-9-9',100,'12345@123.com','12345'),(1,'张三','男','2000-9-9',100,'12345@123.com','12345'),(1,'张三','男','2000-9-9',100,'12345@123.com','12345'),(1,'张三','男','2000-9-9',100,'12345@123.com','12345');
修改数据
update 表名 set 列名1=值1,列名2=值2...(where...);
不加where条件则修改所有数据
UPDATE stu SET gender='女',score=6.5 WHERE name = '张三';
UPDATE stu SET gender='男' WHERE id = 1;
删除数据
delete from 表名 where...
不加条件会全删除