t; Sent: Thursday, April 03, 2003 5:10 PM
> To: [EMAIL PROTECTED]
> Subject: self foreign keys and InnoDB is it possible ?
>
>
> hi all
>
> I'm creating a table like this
>
> CREATE TABLE test (
> id integer not null primary key auto_increment,
>
hi all
I'm creating a table like this
CREATE TABLE test (
id integer not null primary key auto_increment,
testchar(20),
father integer key default ='-1' not null,
FOREIGN KEY (id) RERERENCES test(padre) ON DELETE CASCADE
) Type=InnoDB;
But I made some mi