Here's an example :
mysql> create table petest (col1 integer,col2 char(5)) engine=innodb;
Query OK, 0 rows affected, 1 warning (0.07 sec)
mysql> show warnings
-> ;
+---------+------+------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------+
| Warning | 1266 | Using storage engine MyISAM for table 'petest' |
+---------+------+------------------------------------------------+
1 row in set (0.00 sec)
Jasper Bryant-Greene <jasper@stripped> wrote:
P. Evans wrote:
> Whenever I try to create a table using innodb, i get a 1266 warning that the table
> has been created with myisam instead. I receive the error both at the mysql command line
> and using the mysql query browser.
Can you please show us the CREATE TABLE command that you are using?
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
