目录
1.创建表: 创建员工表employee,字段如下: id(员工编号),name(员工名字),gender(员工性别),salary(员工薪资)
2.插入数据 1,‘张三’,‘男’,2000 2,‘李四’,‘男’,1000 3,‘王五’,‘女’,4000
1:
mysql> create table employee (id int PRIMARY KEY AUTO_INCREMENT,
-> name varchar(50) not null,
-> gender varchar(50) check(gender in('女','男')),
-> salary int not null);
Query OK, 0 rows affected (0.01 sec)
2:
mysql> insert into employee(name,gender,salary) values('张三','男',2000),('李四','男',1000),('王五','女',4000);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
3:
(1):
mysql> update employee set salary=5000;
Query OK, 3 rows affected (0.00 sec)
(2):
mysql> update employee set salary=3000 where name='张三';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
(3):
mysql> update employee set salary=4000,gender='女' where name='李四' ;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
(4):
mysql> update employee set salary=salary+1000 where name='王五' ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0