create table with mysql and set TYPE=InnoDB in the sql string

Question

I want to create a mysql table with this code:

create table geodb_type_names (
  type_id              integer not null,
  type_locale          varchar(5) not null,
  name                 varchar(255) not null,             /* varchar(500)? */
unique (type_id, type_locale)
) TYPE=InnoDB CHARACTER SET utf8;

It comes from a mysql dump for OpenGeoDb.

So I didn't create it by myself. If I include this statement in phpmyadmin I get this error message:

#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 CHARACTER SET utf8' at line 10

But I can't find the issue. Maybe someone can help me?

Thanks a lot.

possible duplicate of 1064 error in CREATE TABLE ... TYPE=MYISAM — Aman Aggarwal
– Aman Aggarwal, Commented Sep 16, 2015 at 7:27
Now TYPE is not in use. Please use ENGINE in the place of TYPE. — Sonia Bhatia
– Sonia Bhatia, Commented Sep 16, 2015 at 7:28

Aman Aggarwal · Accepted Answer · 2015-09-16 07:26:41Z

7

TYPE is replaced by ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5.

Use this query:

create table geodb_type_names (
  type_id              integer not null,
  type_locale          varchar(5) not null,
  name                 varchar(255) not null,             /* varchar(500)? */
unique (type_id, type_locale)
) ENGINE=InnoDB CHARACTER SET utf8;

answered Sep 16, 2015 at 7:26

Aman Aggarwal

18.6k10 gold badges55 silver badges84 bronze badges

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

1 Comment

cgee Over a year ago

Thank you. I'll try it in view minutes.

Collectives™ on Stack Overflow

create table with mysql and set TYPE=InnoDB in the sql string

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related