MySQL 5.5.8 and CREATE TABLE statement

General usage of Access to MySQL

Moderator: jr

MySQL 5.5.8 and CREATE TABLE statement

Postby Lehan » Sun Apr 17, 2011 10:42 am

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
Lehan
 
Posts: 1
Joined: Sun Apr 17, 2011 10:32 am

Return to General

Who is online

Users browsing this forum: No registered users and 2 guests