RE: Changing MyISAM to InnoDB

2002-07-15 Thread Tam, Michael
chael -Original Message- From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:23 PM To: 'Tam, Michael' Subject: RE: Changing MyISAM to InnoDB Hi Michael, I tried creating the table as you described below and same thing happened. MySQL makes it into a

RE: Changing MyISAM to InnoDB

2002-07-15 Thread Tam, Michael
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