List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:January 31 2011 12:36pm
Subject:Re: Table creation
View as plain text  
'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
Thread
Table creationM. Rodrigo Monteiro31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationM. Rodrigo Monteiro31 Jan
      • Re: Table creationRodrigo Ferreira31 Jan
      • Re: Table creationReindl Harald31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationAnanda Kumar31 Jan
  • Re: Table creationReindl Harald31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationM. Rodrigo Monteiro31 Jan
      • Re: Table creationpetya31 Jan
Re: Table creationM. Rodrigo Monteiro31 Jan