Mysql建表

建立一个主外键关系

create table t_dept(

id int(4) not null, name varchar(50) not null,
primary key(id))type=innodb;

create table t_emp (

id int(6) not null,
name char(255) not null,fk_id int(4) not null,

primary key(id),
foreign key (fk_id) references t_dept (id)) type=innodb;