CREATE DATABASE test;
use test;
CREATE TABLE yuangong(
id char(4) PRIMARY KEY NOT NULL,
name varchar(20) UNIQUE,
sex varchar(4) NOT NULL,
birthday char(4),
d_id varchar(20) NOT NULL,
salary Float,
address varchar(50)
);
INSERT INTO yuangong VALUES (8001,'韩鹏','男',25,1002,4000,'北京市海淀区');
INSERT INTO yuangong VALUES (8002,'张峰','男',26,1001,2500,'北京市昌平区');
INSERT INTO yuangong VALUES (8003,'欧阳','男',20,1003,1500,'湖南省永州市');
INSERT INTO yuangong VALUES (8004,'王武','男',30,1001,3500,'北京市顺义区');
INSERT INTO yuangong VALUES (8005,'欧阳宝贝','女',21,1002,3000,'北京市昌平区');
INSERT INTO yuangong VALUES (8006,'呼延','男',28,1003,1800,'天津市南开区');
SELECT d_id FROM yuangong UNION SELECT d_id FROM bumen;