把数据库转换gbk

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='test', charset='utf8mb4')
cursor = conn.cursor()

# 查询数据
cursor.execute("SELECT * FROM table_name")
rows = cursor.fetchall()

# 转换为GBK编码并插入新表
cursor.execute("CREATE TABLE new_table_name LIKE table_name")
for row in rows:
    converted_row = [s.encode('gbk').decode('gbk') for s in row]
    cursor.execute("INSERT INTO new_table_name VALUES (%s, %s, ...)", converted_row)

# 提交事务并关闭连接
conn.commit()
cursor.close()
conn.close()

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='test', charset='utf8mb4')
cursor = conn.cursor()

# 查询数据
cursor.execute("SELECT * FROM table_name")
rows = cursor.fetchall()

# 转换为GBK编码并插入新表
cursor.execute("CREATE TABLE new_table_name LIKE table_name")
for row in rows:
    try:
        converted_row = [s.encode('gbk').decode('gbk') for s in row]
        cursor.execute("INSERT INTO new_table_name VALUES (%s, %s, ...)", converted_row)
    except UnicodeEncodeError as e:
        print(f"Error converting row: {row}. Error: {e}")

# 提交事务并关闭连接
conn.commit()
cursor.close()
conn.close()