MySQL系列——DML语句

#一、增加数据
#1、不写字段
-- insert into student values(1,"小明");
#2、写字段
insert into student (id,studentname) values(99,'赛文');
#3、添加多个
insert into student values(4,"迪迦"),(7,"西门庆");





#二、删除字段
#1、添加条件
delete from student where id=1;
#2、不添加条件，会删除表的全部数据
delete from student



#三、更新字段
update student set studentname="黑医杰克" where studentname="jack";