CREATE TABLE blogentries ( blog_id INT(100) PRIMARY KEY, author_id INT REFERENCES author (author_id), title TEXT NOT NULL, description TEXT, TYPE NVARCHAR(10) NOT NULL, allowcomment CHAR(1) NOT NULL, private CHAR(1) NOT NULL, body TEXT NOT NULL, datecreated TIMESTAMP DEFAULT 0, datepublish TIMESTAMP DEFAULT 0, datemodified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, islock CHAR(1), blogtype_id INT REFERENCES blogotypes(blogtype_id),
) 多了这个逗号。提示中其实已经告诉你的第十七行前有问题。 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 ')' at line 17
(
blog_id INT(100) PRIMARY KEY,
author_id INT REFERENCES author (author_id),
title TEXT NOT NULL,
description TEXT,
TYPE NVARCHAR(10) NOT NULL,
allowcomment CHAR(1) NOT NULL,
private CHAR(1) NOT NULL,
body TEXT NOT NULL,
datecreated TIMESTAMP DEFAULT 0,
datepublish TIMESTAMP DEFAULT 0,
datemodified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
islock CHAR(1),
blogtype_id INT REFERENCES blogotypes(blogtype_id),
)
多了这个逗号。提示中其实已经告诉你的第十七行前有问题。
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 ')' at line 17