mysql 从所有表中查询结果

SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = 'your_database_name';

import mysql.connector

db = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="your_database_name"
)

cursor = db.cursor()

# 获取所有表的名称
cursor.execute("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database_name'")
tables = cursor.fetchall()

# 对每个表执行查询
for table in tables:
    table_name = table[0]
    query = f"SELECT * FROM {table_name} LIMIT 10"  # 示例查询，限制返回前10条记录
    cursor.execute(query)
    result = cursor.fetchall()
    print(f"Results from {table_name}:")
    for row in result:
        print(row)

cursor.close()
db.close()