关于Linux中MySQL的系列操作

1.创建表： 创建员工表employee，字段如下： id（员工编号），name（员工名字），gender（员工性别），salary（员工薪资）

2.插入数据 1，‘张三’，‘男’，2000 2，‘李四’，‘男’，1000 3，‘王五’，‘女’，4000

3.修改表数据

3.1 将所有员工薪水修改为5000元

3.2将姓名为张三的员工薪水修改为3000元

3.3将姓名为李四的员工薪水修改为4000元，gener改为女

3.4 将王五的薪水在原有基础上增加5000元

create table employee( id int(5) primary key auto_increment,nt, gender enum('m','f') not null, salary varchar(5) not null);

desc employee;
+--------+---------------+------+-----+---------+----------------+
| Field  | Type          | Null | Key | Default | Extra          |
+--------+---------------+------+-----+---------+----------------+
| id     | int(5)        | NO   | PRI | NULL    | auto_increment |
| gender | enum('m','f') | NO   |     | NULL    |                |
| salary | varchar(5)    | NO   |     | NULL    |                |
+--------+---------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

alter table employee add name varchar(7) after id;

desc employee;                                           
+--------+---------------+------+-----+---------+----------------+
| Field  | Type          | Null | Key | Default | Extra          |
+--------+---------------+------+-----+---------+----------------+
| id     | int(5)        | NO   | PRI | NULL    | auto_increment |
| name   | varchar(7)    | YES  |     | NULL    |                |
| gender | enum('m','f') | NO   |     | NULL    |                |
| salary | varchar(5)    | NO   |     | NULL    |                |
+--------+---------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

insert into employee values(1,'zhang','m','2000'),(2,'lisi','m','1000'),(3,'wangwu','f','4000');

update employee set salary=5000;

update employee set salary=3000 where name='zhang';

update employee set salary=3000,gender='f' where name='lissi';

update employee set salary=salary + 5000 where name='wangwu';