数据库第二次作业

 

 建库建表

create database mydb8_worker;
use mydb8_worker;
create table t_worker (
department_id int(11) not null comment '部门号',
worker_id int(11) primary key not null comment '职工号',
worker_date date not null comment '工作时间',
wages float(8,2) not null comment '工资',
politics varchar(10) not null default '群众' comment '政治面貌',
name varchar(20) not null comment '姓名', borth_date date not null comment '出生日期' );

插入数据

insert into t_worker values (101, 1001, '2015-05-04', 7500.00, '群众', '张春燕', '1990-07-01'); insert into t_worker values (101, 1002, '2019-02-06', 5200.00, '团员', '李名博', '1997-02-08'); insert into t_worker values (102, 1003, '2008-01-04', 10500.00, '党员', '王博涵', '1983-06-08'); insert into t_worker values (102, 1004, '2016-10-10', 5500.00, '群众', '赵小军', '1994-09-05'); insert into t_worker values (102, 1005, '2014-04-01', 8800.00, '党员', '钱有财', '1992-12-30'); insert into t_worker values (103, 1006, '2019-05-05', 5500.00, '党员', '孙菲菲', '1996-09-02');

1. 
2. 
3. 
4. 
5. 
6. 
7. 
8. 
9. 
10. 
11. 
12. 
13. 
14. 
15.