;检查对应于你的mysql服务器版本使用附近的正确的语法手册,＃1064-您的SQL语法有误；检查与您的MySQL服务器版本相对应的手册，以在'）'附近使用正确的语法...

This is the code. However I kept getting this error

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 ')' at line 7

Weirdly line 7 is the CREATE TABLE academicnews( line. Which does not contain ')' .

CREATE TABLE academicnews(

anewsID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(50) NOT NULL,

anewsContent TEXT NOT NULL,

imagePath VARCHAR(200) NOT NULL,

timeNews DATE NOT NULL,

); #Line 7

解决方案

Get rid of the last comma. It is unnecessary and invalid.

CREATE TABLE academicnews(

anewsID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(50) NOT NULL,

anewsContent TEXT NOT NULL,

imagePath VARCHAR(200) NOT NULL,

timeNews DATE NOT NULL,

);

It should be

CREATE TABLE academicnews(

anewsID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(50) NOT NULL,

anewsContent TEXT NOT NULL,

imagePath VARCHAR(200) NOT NULL,

timeNews DATE NOT NULL

);