MySQL 5.5.8 and CREATE TABLE statement
Posted: 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
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