数据库第二次作业

1.

mysql> create database mydb8_worker;
Query OK，1 row affected(0.01 sec)

mysql> use mydb8_worker;
Database changed

​​mysql> 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'姓名',
         ->birth_date date not null comment'出生日期');
Query OK，0 rows affected, 3 warnings(0.01 sec)

2.

mysql>insert into t_worker values(101,1001,'2015-5-4'7500.00,'群众'"张春燕’'1990-7-1');OK，1 row affected(0.00 sec)Query
mysql>insert intot_worker values(101,1002,'2019-2-6'5200.00团员'李名博·'1997-2-8');Query OK,1 row affected(0.00 sec)
mysql>insert into t_worker values(102,1003,'2008-1-4'10500.00,'党员'王博涵''1983-6-8');Query OK,1 row affected(0.00 sec)
mysql>insert intot_worker values(102,10042016-10-10'5500.00,群众''赵小军''1994-9-5'):Query OK,1 row affected(0.01 sec)
mysql>insert into t_worker values(102,1005,2014-4-1'8800.00党员'"钱有财''1992-12-30');Query OK，1 row affected(.01 sec)
mysql>insert into t_worker values(103,1006,'2019-5-5',5500.00,'党员'孙菲菲''1996-9-2')Query OK,1 row affected(0.00 sec)

3.

(1).

(2).

(3).

(4).

(5).

(6).

(7).

(8).

(9).

(10).

(11).

(12).

(13).

(14).

(15).