更改包含某些字符的表的所有列

使用以下SQL创建脚本:

SELECT CONCAT("ALTER TABLE ",TABLE_SCHEMA,".",TABLE_NAME," RENAME COLUMN ",COLUMN_NAME," TO ",REPLACE(COLUMN_NAME,"_euro",""),"; ")
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE "%_euro"

ALTER TABLE test.t1_euro RENAME COLUMN t1_euro TO t1;

检查脚本,并在数据库上执行它(在备份之后…)

将您的select放入一个存储过程中,在all上创建一个游标和循环,然后执行alter操作

您可以在此处找到一个过程的示例: https://stackoverflow.com/questions/15786240/mysql-create-stored-procedure-syntax-with-delimiter#:~:text=Getting%20started%20with%20stored%20procedure%20syntax%20in%20MySQL%3A,Why%20didn%27t%20this%20work%3F%20...%20More%20items...%20

如果使用python和MySQL连接器,可以将列标题放入一个列表中,然后通过for循环运行它?

for name in table_names:
    if name.endswith("_euro"):
        new_name = name.replace("_euro", "")