mysql查询数据库所有表记录

import mysql.connector

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

cursor = db.cursor()

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

for table in tables:
    table_name = table[0]
    print(f"Fetching records from table: {table_name}")
    
    # 查询每个表的所有记录
    cursor.execute(f"SELECT * FROM {table_name}")
    records = cursor.fetchall()
    
    for record in records:
        print(record)

cursor.close()
db.close()

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase",
    connect_timeout=300  # 设置连接超时时间为300秒
)

offset = 0
limit = 1000
while True:
    cursor.execute(f"SELECT * FROM {table_name} LIMIT {limit} OFFSET {offset}")
    records = cursor.fetchall()
    if not records:
        break
    for record in records:
        print(record)
    offset += limit