'TYPE' is deprecated since long time ago and should be replaced everywhere with 'ENGINE'
with mysql 5.5 'TYPE' is a hard error which can be problematic if running statement-based replication with a 5.1 master and 5.5 slave because the master writes the statement to binlog and slave will stop replication after that Am 31.01.2011 13:16, schrieb M. Rodrigo Monteiro: > Hi! > > I'm trying to create a InnoDB table. > > CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome` > VARCHAR(10)) TYPE=InnoDB; > > show table status from DATABASE like 'Teste2'; > > +--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ > | Name | Engine | Version | Row_format | Rows | Avg_row_length | > Data_length | Max_data_length | Index_length | Data_free | > Auto_increment | Create_time | Update_time | > Check_time | Collation | Checksum | Create_options | Comment | > +--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ > | Teste2 | MyISAM | 10 | Dynamic | 0 | 0 | > 0 | 281474976710655 | 1024 | 0 | NULL > | 2011-01-31 08:53:49 | 2011-01-31 08:53:49 | NULL | > latin1_swedish_ci | NULL | | | > +--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ > > As you can see, the table creates in MyISAM type. > What's going on? -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/
signature.asc
Description: OpenPGP digital signature