mysql - 删除mysql中包含空格的列

Question

我想知道如何在 mysql 中删除包含空格的列。尝试了以下，并得到以下异常:

alter table test17 drop column [added column2];
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 '[added column2]' at line 1

alter table test17 drop column 'added column2';
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 ''added column2'' at line 1

alter table test17 drop column (added column2);
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 '(added column2)' at line 1

谢谢:)

Answer 1

您应该尝试使用反引号 ("`") 来引用您的列名。

ALTER TABLE test17 DROP COLUMN `added column2`;

或

没有COLUMN字

ALTER TABLE test17 DROP `added column2`;