I'm running MySQL 4.0.21 In order to use Foreign Keys, I'm trying to convert a table Type to INNODB. I issue a statement of the form
Alter Table TblName Type=INNODB; This statement appears to execute correctly. I would expect this to affect the Show Create Table output, but when I say Show Create Table TblName; The output still indicates MyISAM. If I add a Foreign Key with On Delete Cascade On Update Cascade, it does not show up in the Show Create Table, and Updating the Foreign key does not cascade to the table with the Foreign Key Constraint. What am I doing wrong?
pgpgDFbx8Rkft.pgp
Description: PGP signature
