Re: INNODB still not working Re: Does mysql support foreign keyon delete cascade and on update cascade?

1 | 1 | 1 | +---++--++---+---+---+ 1 row in set (0.00 sec) Jing Paul DuBois wrote: > At 15:12 -0800 12/11/02, Jing Dai wrote: > >After install mysql-max 3.23.52 and enable innodb setting in /etc/my.cnf >

INNODB still not working Re: Does mysql support foreign key on delete cascade and on update cascade?

After install mysql-max 3.23.52 and enable innodb setting in /etc/my.cnf file, recreate table, this time show create table indicated it's innodb type, but tried update on cascade still not working. Any idea? mysql> create table samDB.license_info ( -> licenseID integer(5) auto_increment primar

Re: Does mysql support foreign key on delete cascade and on update cascade?

Ok, I found answer, I did need uncomment out my.cnf to support InnoDB type. Also I need to install mysql-max binary as I am running on Unix Platform. jing Jing Dai wrote: > Hi, > Thank you for the reply. > I did what you suggested, but show create table is still MYISM, why? >

Re: Does mysql support foreign key on delete cascade and on update cascade?

Hi, Thank you for the reply. I did what you suggested, but show create table is still MYISM, why? Do I need to configure something in the my.cfn file? mysql> create table samDB.license_info ( -> licenseID integer(5) auto_increment primary key, -> vendorName VARCHAR(30) NOT NULL, -> fe

Does mysql support foreign key on delete cascade and on update cascade?

I am just working on mySQL and create two tables, defined licenseID is the primary key in license_info, and foreign key in license_data. But I tested it didn't work the way as like in Oracle delete cascade or update cascade. Did I do something incorrect? mysql> create table samDB.license_info (