开发者

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

开发者 https://www.devze.com 2023-03-15 23:12 出处:网络
This question already has answers here: 1064 error in CREATE TABLE ... TYPE=MYISAM (5 answers) Closed 9 years ago.
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

精彩评论

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