php - 无法创建 mySQL 表

Question

这里我要创建基本的 mysql 表，但是遇到了问题。

Error is : #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 'IDENTITY PRIMARY KEY NOT NULL, NAME varchar(100) )' at line 3

CREATE TABLE `AB_CATEGORY`
(
ID integer IDENTITY PRIMARY KEY NOT NULL,
NAME varchar(100)
);

Answer 1

只需删除 IDENTITY 关键字即可 -

CREATE TABLE `AB_CATEGORY`
(
   ID integer PRIMARY KEY NOT NULL,
   NAME varchar(100)
);