MySQL ERROR 1064 (42000) - 即使有反引号

Question

我一定遗漏了一些明显的东西，但仍然......

当我尝试运行以下命令时出现 MySQL 错误 1064 (42000):

CREATE TABLE `mgr_user`
(
    `id` INT NOT NULL AUTO_INCREMENT,
    `customer_id` INT NOT NULL,
    `username` VARCHAR(25),
    `password` VARCHAR(100),

    INDEX(`customer_id`),
    FOREIGN KEY `customer_id` REFERENCES `customer`(`id`) ON UPDATE CASCADE ON     DELETE RESTRICT
 );

Answer 1

您需要用括号将外键名称括起来。此外，您的自动列必须是一个键。见下文

CREATE TABLE `mgr_user`
(
    `id` INT NOT NULL AUTO_INCREMENT,
    `customer_id` INT NOT NULL,
    `username` VARCHAR(25),
    `password` VARCHAR(100),
    INDEX(`customer_id`),
    UNIQUE KEY (`id`),  --  <- Auto column is should be a key
    FOREIGN KEY (`customer_id`) REFERENCES `customer`(`id`) ON UPDATE CASCADE ON DELETE RESTRICT
 );

在这 2 个更改之后，我得到了 Query OK, 0 rows affected (0.07 sec)