是?
DML是对于数据库当中具体的表结构的增删改
主要操作包括以下几个方面
DML实验操作
use mysql2;
create table if not exists employee(
id int,
name varchar(20),
gender varchar(20),
salary int
);
-- 2插入数据
insert into employee values (1,'张三','男',2000),(2,'李四','男',1000),(3,'王五','女',4000);
update employee set salary=5000;
update employee set salary=3000 where name='张三';
update employee set salary=4000,gender='女' where name='李四';
update employee set salary=salary+1000 where name='王五';