List:General Discussion« Previous MessageNext Message »
From:P. Evans Date:November 10 2005 3:10pm
Subject:Re: 1266 creating innodb tables
View as plain text  
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.  
Thread
1266 creating innodb tablesP. Evans10 Nov
  • Re: 1266 creating innodb tablesJasper Bryant-Greene10 Nov
    • Re: 1266 creating innodb tablesP. Evans10 Nov
      • Re: 1266 creating innodb tablesSGreen10 Nov
        • Re: 1266 creating innodb tablesP. Evans10 Nov
          • Re: 1266 creating innodb tablesJasper Bryant-Greene10 Nov
            • Re: 1266 creating innodb tablesP. Evans11 Nov
              • Re: 1266 creating innodb tablesJasper Bryant-Greene11 Nov
                • Re: 1266 creating innodb tablesP. Evans13 Nov
          • Re: 1266 creating innodb tablesGleb Paharenko11 Nov