mysql error 'TYPE=MyISAM'

Question

Below query I'm executing in Ubuntu 12, MySQL 5.1 version and receiving error as mentioned:

CREATE TABLE mantis_config_table (
    config_id VARCHAR(64) NOT NULL,
    project_id INTEGER NOT NULL DEFAULT 0,
    user_id INTEGER NOT NULL DEFAULT 0,
    access_reqd INTEGER DEFAULT 0,
    type INTEGER DEFAULT 90,
    value LONGTEXT NOT NULL,
    PRIMARY KEY (config_id, project_id, user_id)
) TYPE=MyISAM;

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=MyISAM' at line 9

Can anyone suggest what's wrong?

yes replacing `TYPE=MyISAM` with `ENGINE=MyISAM` works ! thanks guys — Aditya P Bhatt, Jul 13 '12 at 13:06

Aditya P Bhatt · Accepted Answer · 2012-07-13T13:31:45.353

93

Replace

TYPE=MyISAM

with

ENGINE=MyISAM

The problem was "TYPE=MyISAM" which should be "ENGINE=MyISAM" as per MySQL version updates - a simple search / replace has fix it.

edited Jul 13 '12 at 13:31

answered Jul 13 '12 at 13:06

Aditya P Bhatt

21,431
18
85
104

juergen d · Answer 2 · 2017-09-15T12:12:55.507

29

Do not use the keyword TYPE anymore. Use ENGINE instead.

TYPE keyword is depreciated (since 5.0) and not supported in MySQL5.5

CREATE TABLE mantis_config_table 
( 
   ...   
) 
ENGINE = MyISAM;
^^^^^^--------------------- HERE

edited Sep 15 '17 at 12:12

answered Jul 13 '12 at 13:04

juergen d

201,996
37
293
362

3

This should be the accepted answer. With version info. – Pacerier Feb 08 '16 at 02:22

score 15 · Answer 3 · answered Jul 13 '12 at 13:04

15

In newer MySQL Versions its:

ENGINE=MyISAM

here the tutorial (MySQL)

answered Jul 13 '12 at 13:04

René Höhle

26,716
22
73
82

Thank you for the URI to the corresponding documentation. – Alexis Wilke Oct 05 '13 at 22:52

score 7 · Answer 4 · answered Jul 13 '12 at 13:06

7

Use ENGINE instead of TYPE

ENGINE = MYISAM ;

answered Jul 13 '12 at 13:06

Besnik

6,469
1
31
33

score 0 · Answer 5 · answered May 11 '23 at 08:11

in my case, fixed the issue by replacing the older dialect with newer one (compatible with the database):

old: spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect new:spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect

mysql error 'TYPE=MyISAM'

5 Answers5

Linked

Related