type innodb 报错 mysql_mysql建立INNODB时出现1064错误

CREATETABLEcategories(`categories_id`int(10)unsignedNOTNULLPRIMARYKEYauto_increment,`categories_name`VARCHAR(52),)TYPE=INNODB;CREATETABLEusers(`user_id`int(10)unsignedNOT...

CREATE TABLE categories

(`categories_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment,

`categories_name` VARCHAR(52),

)TYPE=INNODB;

CREATE TABLE users

(

`user_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment,

`user_name` VARCHAR(52),

`user_email` VARCHAR(52),

`user_password` VARCHAR(52),

`user_age` int(10),

`user_sex` VARCHAR(10),

`user_introduce` TEXT,

)TYPE=InnoDB;

CREATE TABLE news

(

`news_id` INT(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,

`news_title` VARCHAR(150),

`news_body` text,

`user` VARCHAR(52),

`news_publishing_date` DATE,

`news_publishing_time` TIME,

`category` VARCHAR(52),

INDEX (`users`),

FOREIGN KEY (`user`) REFERENCES users(`user_name`) ON DELETE CASCADE,

INDEX (`category`),

FOREIGN KEY (`category`) REFERENCES category(`category_name`) ON DELETE CASCADE,

)TYPE=InnoDB;

CREATE TABLE comment

(

`comment_id` INT(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,

`user` VARCHAR(52),

`news_title` VARCHAR(150),

`comment_body` text,

`comment_publishing_date` DATE,

`comment_publishing_time` TIME,

NDEX (`users`),

FOREIGN KEY (`user`) REFERENCES users(`user_name`) ON DELETE CASCADE,

INDEX (`news`),

FOREIGN KEY (`news_title`) REFERENCES news(`news_title`) ON DELETE CASCADE,

)TYPE=InnoDB;

这是建表的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 ')TYPE=INNODB' at line 5

使用的是phpmyadmin,直接Import

展开