From: Reindl Harald
Date: January 31 2011 12:36pm
Subject: Re: Table creation
List-Archive: http://lists.mysql.com/mysql/224262
Message-Id: <4D46ACE0.3000202@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig9E5A2D231F7A56CBAFA8EA48"

--------------enig9E5A2D231F7A56CBAFA8EA48
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

'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!
>=20
> I'm trying to create a InnoDB table.
>=20
> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
> VARCHAR(10)) TYPE=3DInnoDB;
>=20
> show table status from DATABASE like 'Teste2';
>=20
> +--------+--------+---------+------------+------+----------------+-----=
--------+-----------------+--------------+-----------+----------------+--=
-------------------+---------------------+------------+------------------=
-+----------+----------------+---------+
> | 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 |                |         |
> +--------+--------+---------+------------+------+----------------+-----=
--------+-----------------+--------------+-----------+----------------+--=
-------------------+---------------------+------------+------------------=
-+----------+----------------+---------+
>=20
> As you can see, the table creates in MyISAM type.
> What's going on?

--=20

Mit besten Gr=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


--------------enig9E5A2D231F7A56CBAFA8EA48
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk1GrOAACgkQhmBjz394AnlcXwCeOqGO8OewI7i5VsoCC/Lr0S72
C3sAn14eH1nCz0uZLRv++W8Sj9IgtFi4
=10NS
-----END PGP SIGNATURE-----

--------------enig9E5A2D231F7A56CBAFA8EA48--