mysql第三次作业

 1.创建表

create table employee( id INT, name VARCHAR(20), gender VARCHAR(2), salary INT ); 

2.插入数据 

INSERT INTO employee VALUES(1,'张三','男',2000),

(2,'李四','男',1000),

(3,'王五','女',4000); 

3.修改表数据 

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

 

 4.检验

select *  from employee;