-- 练习
/*创建员工表employee,字段如下:
id(员工编号) ,name(员工名字),gender(员工性别),salary(员工薪资)
*/
use mydb1;
create table if not exists employee(
id int,
name varchar(20),
gender varchar(10),
salary double
);
-- 2.插入数据
/*
1,'张三','男',2000
2,'李四','男',1000
3,'王五','女',4000
*/
insert into employee(id,name,gender,salary) values(1,'张三','男',2000)
insert into employee values(2,'李四','男',1000),
(3,'王五','女',4000);
-- 3.修改数据
-- 将所有员工的薪水修改为5000
update employee set salary = 5000 ;
-- 将姓名为张三的员工薪水修改为3000元
update employee set salary = 3000 where name = '张三';
-- 将姓名为李四的员工薪水修改为4000,性别改为女
update employee set salary = 4000 ,gender = '女' where name = '李四';
-- 将王五的薪水在原有的基础上加1000元
update employee set salary = salary+1000 where name = '王五';