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) references master (master_id) on delete
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_id int
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)