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
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