At 9:12 PM -0400 10/7/03, Guy Rouillier wrote:
Michael Klem wrote:From MySQL version 4.0, InnoDB is enabled by default. So sql used to create a db table will default to being an InnoDB table. To explicitly create a table as InnoDB do this:
CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB;
That has not been my experience. I have MySQL 4 on both Windows 2000 and Linux, and if I don't specify a type, tables end up as MyISAM.
--
Guy Rouillier
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
-- Michael Klem <[EMAIL PROTECTED]> 626-296-3027
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
