mysql基础练习

题目：

代码：`CREATE TABLE IF NOT EXISTS employee(

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

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=‘王五’;
`