MySQL加盟详解_MySQL

还是先创建表吧

创建表 emp(
id int 非空主键,
name varchar(10)
);

创建表 emp_dept(
dept_id varchar(4) not null,
emp_id int not null,
emp_name varchar(10),
主键 (dept_id,emp_id));

插入 emp() 值
(1,"Dennis-1"),
(2,"Dennis-2"),
(3,"Dennis-3"),
(4,"丹尼斯-4"),
(5,"丹尼斯-5"),
(6,"丹尼斯-6"),
(7,"丹尼斯-7"),
(8,"丹尼斯-8"),
(9,"丹尼斯-9"),
(10,"丹尼斯-10");

插入 emp_dept() 值
("R&D",1,"Dennis-1"),
("DEv",2,"Dennis-2"),
("R&D" ,3,"Dennis-3"),
("测试",4,"Dennis-4"),
("测试",5,"Dennis-5");