Brian, you can also set a default storage engine in your mysql config
file (my.cnf) to ensure future tables get created with the desired
storage engine (unless otherwise specified in your create statement).
From http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
If you omit the ENGINE
most of my Storage enines is MyISAM i wanna change them all to|InnoDB
how do i do this >?
ALTER TABLE tblname ENGINE="innodb";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
most of my Storage enines is MyISAM i wanna change them all to|InnoDB
how do i do this >?thanks
|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
