还是先 create table 吧
create table emp(
id int not null primary key,
name varchar(10)
);
create table emp_dept(
dept_id varchar(4) not null,
emp_id int not null,
emp_name varchar(10),
primary key (dept_id,emp_id));
insert into emp() values
(1,dennis-1),
(2,dennis-2),
(3,dennis-3),
(4,dennis-4),
(5,dennis-5),
(6,dennis-6),
(7,dennis-7),
(8,dennis-8),
(9,dennis-9),
(10,dennis-10);
insert into emp_dept() values
(r&d,1,dennis-1),
(dev,2,dennis-2),
(r&d,3,dennis-3),
(test,4,dennis-4),
(test,5,dennis-5);
http://www.bkjia.com/phpjc/631052.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/631052.htmltecharticle还是先 create table 吧 create table emp( id int not null primary key, name varchar(10) ); create table emp_dept( dept_id varchar(4) not null, emp_id int not null, emp_name varc...