Hi. I think you should upgrade to MySQL 4.0.22.
Michael Satterwhite <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding quoted-printable, charset: us-ascii, 23 lines --] > > 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? > > [-- application/pgp-signature, encoding 7bit, 8 lines --] > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]