mysql 如何修改表前缀

-- 创建新表并复制数据
CREATE TABLE new_prefix_users LIKE old_prefix_users;
INSERT INTO new_prefix_users SELECT * FROM old_prefix_users;

-- 删除旧表
DROP TABLE old_prefix_users;

-- 重命名新表
RENAME TABLE new_prefix_users TO users;

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()