mysql - MySQL新建表时SQL语法错误

Question

我不会创建 sql 表，但收到错误。

#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 'CREATE TABLE `articles_ratings` ( `ID` INT(11) NOT NULL AUTO_INCREMENT, `a' at line 10

CREATE TABLE `articles` (
   `ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
   `a_title` varchar( 255 ) ,
   `a_subtitle` tinytext,
   `a_content` text,
   PRIMARY KEY ( `ID` )
) 

CREATE TABLE `articles_ratings` (
   `ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
   `article_id` int( 11 ) NOT NULL ,
   `rating_value` tinyint( 2 ) NOT NULL ,
   `rater_ip` varchar( 20 ) NOT NULL ,
)

Answer 1

将主键添加到您的文章评级声明中或删除最后一个逗号。

CREATE TABLE articles ( 
    ID int( 11 ) NOT NULL AUTO_INCREMENT , 
    a_title varchar( 255 ) , 
    a_subtitle tinytext, 
    a_content text, 
  PRIMARY KEY ( ID ) 
);
CREATE TABLE articles_ratings ( 
    ID INT( 11 ) NOT NULL AUTO_INCREMENT , 
  article_id int( 11 ) NOT NULL , 
  rating_value tinyint( 2 ) NOT NULL , 
  rater_ip varchar( 20 ) NOT NULL , 
PRIMARY KEY ( ID ) 
);