mysql - PhPMyAdmin 错误#1064；语法错误

Question

我正在尝试为论坛构建 MySQL 数据库，当我尝试制作分区表时，我不断遇到问题

#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 7

代码如下:

 CREATE TABLE sections (
sect_id          INT(8) NOT NULL AUTO_INCREMENT,
sect_name      VARCHAR(255) NOT NULL,
sect_desc     VARCHAR(255) NOT NULL,
UNIQUE INDEX sect_name_unique (sect_name),
PRIMARY KEY (sect_id)
) TYPE=INNODB;

Answer 1

使用以下查询

CREATE TABLE IF NOT EXISTS sections (
  sect_id          INT(8) NOT NULL AUTO_INCREMENT,
sect_name      VARCHAR(255) NOT NULL,
sect_desc     VARCHAR(255) NOT NULL,
UNIQUE INDEX sect_name_unique (sect_name),
PRIMARY KEY (sect_id)
) ENGINE=InnoDB

要提及引擎类型，请使用 ENGINE 关键字。