MySQL数据操作

1.创建表：

mysql> create table employee (
-> id int(11) primary key auto_increment comment'员工编号',
-> name varchar(50) not null comment'员工名字', 
-> gender varchar(10) not null comment'员工性别',
-> salary float(7) comment'员工薪资');
Query OK, 0 rows affected (0.00 sec)

mysql> desc employee;
+--------+-------------+------+-----+---------+----------------+
| Field  | Type        | Null | Key | Default | Extra          |
+--------+-------------+------+-----+---------+----------------+
| id     | int(11)     | NO   | PRI | NULL    | auto_increment |
| name   | varchar(50) | NO   |     | NULL    |                |
| gender | varchar(10) | NO   |     | NULL    |                |
| salary | float       | YES  |     | NULL    |                |
+--------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

2.插入数据

insert into employee values(1,'张三','男',2000), (2,'李四','男',1000), (3,'王五','女',4000);

查表

mysql> select * from employee;
+----+--------+--------+--------+
| id | name   | gender | salary |
+----+--------+--------+--------+
|  1 | 张三   | 男     |   2000 |
|  2 | 李四   | 男     |   1000 |
|  3 | 王五   | 女     |   4000 |
+----+--------+--------+--------+
3 rows in set (0.01 sec)

3.修改数据表

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

mysql> update employee set salary = 5000;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

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

mysql> update employee set salary = 3000 where name = '张三';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

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

mysql> update employee set salary = 4000,gender = "女" where name = '李四';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

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

mysql> update employee set salary = salary + 1000 where name = '王五';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

最后

mysql> select * from employee;
+----+--------+--------+--------+
| id | name   | gender | salary |
+----+--------+--------+--------+
|  1 | 张三   | 男     |   3000 |
|  2 | 李四   | 女     |   4000 |
|  3 | 王五   | 女     |   6000 |
+----+--------+--------+--------+
3 rows in set (0.00 sec)