mysql 修改表前缀命令

-- 假设原前缀为 old_prefix，新前缀为 new_prefix
RENAME TABLE old_prefix_table1 TO new_prefix_table1;
RENAME TABLE old_prefix_table2 TO new_prefix_table2;
-- 以此类推，修改所有表

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 获取所有表名
cursor.execute("SHOW TABLES")
tables = cursor.fetchall()

# 修改表前缀
old_prefix = "old_prefix"
new_prefix = "new_prefix"

for table in tables:
    if table[0].startswith(old_prefix):
        new_table_name = table[0].replace(old_prefix, new_prefix, 1)
        cursor.execute(f"RENAME TABLE {table[0]} TO {new_table_name}")

# 提交更改
db.commit()

# 关闭连接
cursor.close()
db.close()