Syntax error when running a MySQL CREATE TABLE statement [duplicate]

Instead of

TYPE=INNODB

set

Engine=InnoDB

mysql sql database syntax

Use ENGINE=InnoDB;

mysql sql database syntax

The manual for CREATE TABLE doesn't include TYPE; it seems to use:

ENGINE = INNODB;

And that is the default engine, so you don't really need to specify it.

CodeHunter