数据库学习:MySQL Join详解

还是先 Create table 吧

create table emp(

id int not null primary key

name varchar()

);

create table emp_dept(

dept_id varchar() not null

emp_id int not null

emp_name varchar()

primary key (dept_idemp_id));

insert into emp() values

(Dennis)

(Dennis)

(Dennis)

(Dennis)

(Dennis)

(Dennis)

(Dennis)

(Dennis)

(Dennis)

(Dennis);

insert into emp_dept() values

(R&DDennis)

(DEvDennis)

(R&DDennis)

(TestDennis)

(TestDennis);