mysql - 在 mysql 数据库中创建表，错误 1064 (42000)？

Question

**正在使用 MySQL 8.0 命令行客户端

我正在尝试在 mysql 数据库中创建通用表，但不断收到以下错误:

"ERROR 1064 (42000): 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 'AUTO_INCREMENT, ManufacturerPTNO VARCHAR(40) NOT NULL, QuantityAvailable12am I' at line 2"

我已经浏览了手册，但没有找到任何有助于解决此问题的内容；还尝试删除索引(id)列并将其指定为 KEY

CREATE TABLE quantity ( 
    id INT NOT NULL AUTO_INCREMENT, 
    ManufacturerPTNO VARCHAR(40) NOT NULL, 
    QuantityAvailable12am INT, 
    QuantityAvailable01am INT, 
    PRIMARY KEY (ManufacturerPTNO),
    );

Answer 1

CREATE TABLE quantity ( 
    id INT NOT NULL AUTO_INCREMENT, 
    ManufacturerPTNO VARCHAR(40) NOT NULL, 
    QuantityAvailable12am INT, 
    QuantityAvailable01am INT, 
    PRIMARY KEY (id)
    );

主键应该是id

根据您的评论更新答案

CREATE TABLE quantity ( 
    id INT NOT NULL AUTO_INCREMENT, 
    ManufacturerPTNO VARCHAR(40) NOT NULL, 
    QuantityAvailable12am INT, 
    QuantityAvailable01am INT, 
    PRIMARY KEY (ManufacturerPTNO),
    UNIQUE KEY (id)
    );