前辈请帮忙看看下面代码为何出现 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
============================================================
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
`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
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