主页 / 问题 / 1143669
Accepted
Emperor's chosen
Asked:2020-06-21 02:24:26 +0000 UTC2020-06-21 02:24:26 +0000 UTC

我的命令有什么问题（MySQL）

  • 772
ALTER TABLE project_list
    -> CHANGE COLUMN number proj_id INT NOT NULL AUTO_INCREMENT,
    -> ADD PRIMARY KEY ('proj_id');

错误

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 ''proj_id')' at line 3
mysql

1 个回答

  1. Best Answer

    尝试 -> ADD PRIMARY KEY (proj_id);

    • 0

相关问题