开发者

error (1064) while creating table in mysql [duplicate]

This question already has answers here: 1064 error in CREATE TABLE ... TYPE=MYISAM (5 answers) Closed 9 years ago.

I am using mysql db(version 5.5) and using mysql query browser(v 1.1.5) .But when i try to create a simple table using query browser am getting following error:

CREATE 开发者_开发百科TABLE `tstaks`.`employee` (
  `empid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  PRIMARY KEY(`empid`)
)
TYPE = InnoDB;


mysql error no 1064
you have an error in your sql sytax,check the manual that corresponds to your mysqlserver version for right syntax to use
near type ='innoDB


TYPE needs to be ENGINE: ENGINE=InnoDB

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜