Alternatives for creating InnoDB tables: 1) When you start mysql, you can pass a parameter to set default-table-type=InnoDB; Then, when you create tables, InnoDB type table is the default type, or
2) In order to create InnoDB type table, you need to create the table in the following way: CREATE TABLE `my_table` (`field1` TINYINT (3) UNSIGNED DEFAULT '0') TYPE = InnoDB; To change between table types: ALTER TABLE my_table TYPE = target_table_type; Hope this help. Best regards, Michael -----Original Message----- From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 10:18 AM To: [EMAIL PROTECTED] Subject: Changing MyISAM to InnoDB For the life of me I can not figure out why I can not create or change my tables from MyISAM to InnoDB. I create the table with InnoDB and MySQL creates the table as MyISAM. I am using MySQL-max-nt. Any ideas how I can change the tables or even create them as InnoDB for that matter? Thanks in advanced. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php