Just my .02
At 9:50 PM -0700 10/7/03, Michael Klem wrote:
Just quoting from the MySQL docs. I will verify for myself too. I am using 4.0.14
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
-- 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
