mysql 查询结果格式化

import pandas as pd
import mysql.connector

# 连接数据库
conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
cursor = conn.cursor()

# 执行查询
query = "SELECT * FROM table_name"
cursor.execute(query)

# 获取查询结果并格式化
result = cursor.fetchall()
df = pd.DataFrame(result, columns=[i[0] for i in cursor.description])
print(df)

SELECT CONVERT(column_name USING utf8) AS formatted_column FROM table_name;

import mysql.connector

# 连接数据库
conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
cursor = conn.cursor(dictionary=True)

# 分页查询
page_size = 100
offset = 0
while True:
    query = f"SELECT * FROM table_name LIMIT {page_size} OFFSET {offset}"
    cursor.execute(query)
    result = cursor.fetchall()
    if not result:
        break
    for row in result:
        print(row)
    offset += page_size