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='王五';