MySQL 5.5.8 and CREATE TABLE statement

General usage of Access to MySQL

Moderator: jr

Lehan
Posts: 1
Joined: Sun Apr 17, 2011 10:32 am

MySQL 5.5.8 and CREATE TABLE statement

Post by Lehan »

Hi and thank's for this usefull soft :)

After an update of mysql server an error appends during tables creation.

Conversion results :
- Creating '[table1]' failed
- SQL: CREATE TABLE [...] TYPE=InnoDB
- Error: -2147217900 (80040E14) [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1
- 0 records moved
- Creating '[table2]' failed
- SQL: CREATE TABLE [...] TYPE=InnoDB
- Error: -2147217900 (80040E14) [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1
- 0 records moved

TYPE is used instead of ENGINE keyword, if i understand all

Regards