我正在使用mysql (5.5版)和mysql query browser (1.1.5版) .But,当我尝试使用query browser创建一个简单的表时,遇到以下错误:
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发布于 2011-06-29 17:41:17
TYPE需要为ENGINE:ENGINE=InnoDB
https://stackoverflow.com/questions/6518591
复制相似问题