HI Victoria, Harald, Dyego
you all were right, the database is not supporting the InnoDb tables;
I configure it with "--with --innodb" option & add innodb_data_file_path
to the my.cnf. Now it's working!!
Thank you so much
Vinita
sql
Dyego Souza do Carmo wrote:
vvM> HI
vvM> still not workin
vinita,
Tuesday, November 19, 2002, 2:06:01 AM, you wrote:
vvM> still not working :-(
vvM> I didn't do the installation , Do we need to set any option
vvM> specifically during the installation for foreign key to work??
Check that your both tables are InnoDB:
SHOW TABLE STATUS LIKE "tabl
HI
still not working :-(
I didn't do the installation , Do we need to set any option
specifically during the installation for foreign key to work??
mysql> CREATE TABLE unit (
-> unitCode CHAR(20) NOT NULL,
-> unitName CHAR(50),
-> unitYear CHAR(20) NOT NULL,
-> PRIMARY KEY (unitCode
Change room to unit
FOREIGN KEY (unitCode) REFERENCES room (unitCode) ON DELETE CASCADE
FOREIGN KEY (unitCode) REFERENCES unit(unitCode) ON DELETE CASCADE
Hope this helps,
Sil
- Original Message -
From: "vinita vigine Murugiah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, Nove
