mysql编码转换工具

import pymysql

def convert_encoding(host, user, password, db_name, from_charset, to_charset):
    conn = pymysql.connect(host=host, user=user, password=password, db=db_name, charset=from_charset)
    cursor = conn.cursor()
    
    cursor.execute(f"ALTER DATABASE {db_name} CHARACTER SET {to_charset} COLLATE {to_charset}_unicode_ci")
    
    cursor.execute(f"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{db_name}'")
    tables = cursor.fetchall()
    
    for table in tables:
        table_name = table[0]
        cursor.execute(f"ALTER TABLE {table_name} CONVERT TO CHARACTER SET {to_charset} COLLATE {to_charset}_unicode_ci")
    
    conn.commit()
    cursor.close()
    conn.close()

# 示例调用
convert_encoding('localhost', 'username', 'password', 'your_database_name', 'latin1', 'utf8mb4')