MySQL syntax error when specifying innodb database type and character set

Question

I cant seem to import my tables.sql to a database called callumba_login. Here is the SQL:

CREATE TABLE Country(
    country_code                char(2) not null,
    country_name                varchar(60) not null,
    primary key(country_code)
    )type=innodb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL says:

#1064 - 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 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci at line 5

Barmar · Accepted Answer · 2014-05-20 17:24:04Z

6

The error message points you directly to the bad syntax.

type=innodb should be engine=innodb.

answered May 20, 2014 at 17:24

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL syntax error when specifying innodb database type and character set

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related