当列名包含特殊字符时，该如何重命名该列？当我尝试运行下面的代码时，出现以下错误：

Unknown column 'Actual gross' in 'field list'

ALTER TABLE practice.practice1 

RENAME COLUMN \`Actual gross\` TO \`Actual_Gross\`;

我在使用MySQL 8。

解决方案

SELECT CONCAT( 'ALTER TABLE practice.practice1 RENAME COLUMN `',
               COLUMN_NAME,
               '` TO Actual_Gross'
               ) 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'practice' 
  AND TABLE_NAME = 'practice1' 
  AND COLUMN_NAME LIKE 'Actual%gross'
INTO @sql;

PREPARE stmt FROM @sql;
EXECUTE stmt;
DROP PREPARE stmt;