error (1064) while creating table in mysql [duplicate]
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
精彩评论