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
Bruce,
Friday, November 15, 2002, 5:35:21 AM, you wrote:
BL> I have a problem about foreign key in using MySQL.com manual. According to
BL> the example in MySQL.com manual, one foreign key is ok. However, I have 3
BL> tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more
quot;foreign key (customerId) references customerTb (customerId) on delete
cascade".
José Ceferino Ortega
-Mensaje original-
De: Bruce Lee [mailto:itnobita@;hotmail.com]
Enviado el: viernes, 15 de noviembre de 2002 4:35
Para: [EMAIL PROTECTED]
Asunto: Foreign Keys and InnoDb in MyS
Hello,
I have a problem about foreign key in using MySQL.com manual. According to
the example in MySQL.com manual, one foreign key is ok. However, I have 3
tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more
foreign keys, I have the following errors.
Case 1:
mysql> cr
Hi,
if you want to enjoy the foreign keys from innodb in mysql 4 then you
can't use binaries from the rpm files.
The rpm files contain innodb .43, not .43b!
But the source 4.0.0 and the .tar.gz binary 4.0.0 (non-rpm)
contains .43b which supports foreign keys.
Kind regards
Tore
--
