Re: create fails with on delete set null

2003-02-21 Thread Paul DuBois
At 22:07 + 2/21/03, Ross Davis wrote: Simply said this works: drop table if exists detail; create table detail ( detail_id int not null auto_increment , master_id int not null , name varchar(50) not null , primary key (detail_id) , index master_idx(master_id) , foreign key (master_id) refe

Re: create fails with on delete set null

2003-02-21 Thread Heikki Tuuri
Ross, - Original Message - From: ""Ross Davis"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, February 22, 2003 12:14 AM Subject: create fails with on delete set null > > Simply said this works: > drop table if exists detail; > create table detail > ( > detail_i