#一、增加数据
#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";
MySQL系列——DML语句
于 2022-04-09 20:03:55 首次发布