ALTER TABLE 中的 MySQL 语法错误

Question

Sql 不断向我抛出语法错误，我似乎无法弄清楚出了什么问题。

ALTER TABLE `productList` ALTER COLUMN `ASIN` VARCHAR(32);

该错误是正常的sql语法错误

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 'VARCHAR(32)' at line 1

Answer 1

试试这个:

 ALTER TABLE `productList` MODIFY COLUMN `ASIN` VARCHAR(32);

change the column name 的语法是

ALTER TABLE tablename MODIFY COLUMN new-column-definition