Error 1064 in MySql

EH1818 2008-09-15 09:14:28

前辈请帮忙看看下面代码为何出现 1064的错误？谢谢。
============================================================
CREATE TABLE `map`.`blog` (
`blogID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`createUser` VARCHAR(45)),
`createDate` DATETIME,
`subtitle` VARCHAR(100),
`contents` BLOB,
`tags` VARCHAR(100),
`reviewNum` INTEGER UNSIGNED COMMENT '浏览次数',
`status` TINYINT UNSIGNED,
`allowComment` BOOLEAN,
PRIMARY KEY (`blogID`)
)
ENGINE = InnoDB

...全文

55 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

WWWWA 2008-09-16

打赏
举报

CREATE TABLE `map`.`blog` (
`blogID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`createUser` VARCHAR(45),
`createDate` DATETIME,
`subtitle` VARCHAR(100),
`contents` BLOB,
`tags` VARCHAR(100),
`reviewNum` INTEGER UNSIGNED COMMENT '浏览次数',
`status` TINYINT UNSIGNED,
`allowComment` BOOLEAN,
PRIMARY KEY (`blogID`)
)
ENGINE = InnoDB

SICTXK 2008-09-16

打赏
举报

第三行多了一个 '）'

懒得去死 2008-09-16

打赏
举报



CREATE TABLE `map`.`blog` (

  `blogID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

  `createUser` VARCHAR(45),

  `createDate` DATETIME,

  `subtitle` VARCHAR(100),

  `contents` BLOB,

  `tags` VARCHAR(100),

  `reviewNum` INTEGER UNSIGNED COMMENT '浏览次数',

  `status` TINYINT UNSIGNED,

  `allowComment` BOOLEAN,

  PRIMARY KEY (`blogID`)

)

ENGINE = InnoDB