'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/
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
