关于MYSQL语法错误，该怎么解决。。初学者

[u010800530]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '---mysql数据库

--权限表
CREATE TABLE `bbs`.`limit` (
`id` INTEGE' at line 1
[Err] ---mysql数据库

--权限表
CREATE TABLE `bbs`.`limit` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(10) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;

INSERT INTO `limit` VALUES (1,'管理员');
INSERT INTO `limit` VALUES (2,'版主');
INSERT INTO `limit` VALUES (3,'普通用户');
--用户表
CREATE TABLE `bbs`.`users` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`username` VARCHAR(20) NOT NULL,
`password` VARCHAR(20) NOT NULL,
`email` VARCHAR(45) NOT NULL,
`nickname` VARCHAR(10) NOT NULL,
`posttime` DATETIME DEFAULT null,
limitid int NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
alter table users add constraint un_username unique(username);
INSERT INTO `users` VALUES (1,'admin','admin','[e-mail]','mm','2009-06-18',1);

--版块表
CREATE TABLE `spaces` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`describe` varchar(200) NOT NULL,
`userid` int(10) unsigned default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `un_name` (`name`),
KEY `fk02` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--帖子表

CREATE TABLE `bbs`.`article` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(50) NOT NULL,
`content` VARCHAR(225) NOT NULL,
`userid` INTEGER UNSIGNED NOT NULL,
`spaceid` INTEGER UNSIGNED NOT NULL,
`addtime` datetime NOT NULL,
PRIMARY KEY (`id`)
)

ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `article`
ADD CONSTRAINT `fk03` FOREIGN KEY (`userid`) REFERENCES `users` (`id`);
ALTER TABLE `article`
ADD CONSTRAINT `fk04` FOREIGN KEY (`spaceid`) REFERENCES `spaces` (`id`);

--帖子回复表

CREATE TABLE `bbs`.`articlereply` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`articleid` INTEGER UNSIGNED NOT NULL,
`userid` INTEGER UNSIGNED NOT NULL,
`content` VARCHAR(500) NOT NULL,
`replaytime` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `fk05` (`articleid`),
KEY `fk06` (`userid`),
CONSTRAINT `fk05` FOREIGN KEY (`articleid`) REFERENCES `article` (`id`),
CONSTRAINT `fk06` FOREIGN KEY (`userid`) REFERENCES `users` (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;


--公告表

CREATE TABLE `bbs`.`bulletin` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(50) NOT NULL,
`content` VARCHAR(1000) NOT NULL,
`posttime` DATETIME DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
这是错误信息

---mysql数据库

--权限表
CREATE TABLE `bbs`.`limit` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;

INSERT INTO `limit` VALUES (1,'管理员');
INSERT INTO `limit` VALUES (2,'版主');
INSERT INTO `limit` VALUES (3,'普通用户');
--用户表
CREATE TABLE `bbs`.`users` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(20) NOT NULL,
  `password` VARCHAR(20) NOT NULL,
  `email` VARCHAR(45) NOT NULL,
  `nickname` VARCHAR(10) NOT NULL,
  `posttime` DATETIME DEFAULT null,
   limitid int   NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
alter table users add constraint un_username unique(username);
INSERT INTO `users` VALUES (1,'admin','admin','[e-mail]','mm','2009-06-18',1);

--版块表
CREATE TABLE `spaces` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `describe` varchar(200) NOT NULL,
  `userid` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `un_name` (`name`),
  KEY `fk02` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--帖子表

CREATE TABLE `bbs`.`article` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(50) NOT NULL,
  `content` VARCHAR(225) NOT NULL,
  `userid` INTEGER UNSIGNED NOT NULL,
  `spaceid` INTEGER UNSIGNED NOT NULL,
  `addtime` datetime NOT NULL,
  PRIMARY KEY (`id`)
)

ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `article`
ADD CONSTRAINT `fk03` FOREIGN KEY (`userid`) REFERENCES `users` (`id`);
ALTER TABLE `article`
ADD CONSTRAINT `fk04` FOREIGN KEY (`spaceid`) REFERENCES `spaces` (`id`);

--帖子回复表

CREATE TABLE `bbs`.`articlereply` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `articleid` INTEGER UNSIGNED NOT NULL,
  `userid` INTEGER UNSIGNED NOT NULL, 
  `content` VARCHAR(500) NOT NULL,
  `replaytime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk05` (`articleid`),
  KEY `fk06` (`userid`),
  CONSTRAINT `fk05` FOREIGN KEY (`articleid`) REFERENCES `article` (`id`),
  CONSTRAINT `fk06` FOREIGN KEY (`userid`) REFERENCES `users` (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;


--公告表

CREATE TABLE `bbs`.`bulletin` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(50) NOT NULL,
  `content` VARCHAR(1000) NOT NULL,
  `posttime` DATETIME DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;

[ACMAIN_CHM]

一段一段执行，看执行到哪一句报的错，把完整错误信息一同贴出。

[-江沐风-]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '***' 很简单，1064即为SQL语法错误，仔细检查错误提示信息所指语句附近改正即可

[xiejijun_05]

-- 后面紧跟空格

[wwwwb]

语法问题，哪1段有问题