外键测试

ydz5

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,
primary key (par_id,child_id),
foreign key (par_id) references parent (par_id) on delete cascade
) type = innodb;
# creat table end
# insert strat
insert into parent (par_id) values (1),(2),(3);
insert into child (par_id,child_id) values (1,1),(1,2);
insert into child (par_id,child_id) values (2,1),(2,2),(2,3);
insert into child (par_id,child_id) values (3,1);
# insert end


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/6039/showart_20888.html