数据库最基础的改之小白改

哈哈哈哈哈哈我又来了 带个特别简单的题过来了。.

数据库最基础的改改改改改改改

以后请别做改大王 很痛苦的

创建表

CREATE TABLE employee(
id INT,
NAME VARCHAR(20),
sex VARCHAR(10),
birthday DATE,
salary FLOAT,   
RESUME TEXT
);      

插入数据

INSERT INTO employee VALUES(1,"zhangsan","male","1980-11-25",2000,"good body");
INSERT INTO employee VALUES(2,"lisi","male","1980-04-25",1000,"good body");
INSERT INTO employee VALUES(3,"xiaohong","female","1978-11-25",4000,"good girl");

完成下面的功能

1.将所有员工薪水修改为5000元。

2.将姓名为’zhangsan’的员工薪水修改为3000元。

3.将姓名为’lisi’的员工薪水修改为4000元,sex改为female。

4.将xiaohong的薪水在原有基础上增加1000元。

|

|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

这是我做的,哈哈哈哈我也是刚学的，新鲜出炉。

1>

UPDATE employee SET salary=5000;

2>

UPDATE employee SET salary = 3000 WHERE id =1;

3

UPDATE employee SET salay = 4000 WHERE NAME = lisi;
ALTER TABLE employee CHANGE sex female VARCHAR(10);

4

UPDATE employee SET salary=salary+1000 WHERE NAME = 'xiaohong';