外鍵測試

DROP TABLE IF EXISTS child;
DROP TABLE IF EXISTS parent;

DROP TABLE IF EXISTS child;
DROP TABLE IF EXISTS parent;

# creat table start
create table parent
(
 par_id int not null,
 primary key (par_id)
) type = innodb;

create table child
(
 par_id int not null,
 child_id int not null,

原文轉自：http://www.kjueaiud.com