mySQL查询返回每个表的最后一条记录

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')

# 获取数据库中所有的表名
cursor = cnx.cursor()
cursor.execute("SHOW TABLES")
tables = cursor.fetchall()

# 遍历每个表名
for table in tables:
    table_name = table[0]
    
    # 构建查询语句
    query = "SELECT * FROM {} ORDER BY id DESC LIMIT 1".format(table_name)
    
    # 执行查询语句
    cursor.execute(query)
    
    # 获取结果集中的最后一条记录
    result = cursor.fetchone()
    
    # 打印结果
    print("Table: {}".format(table_name))
    print(result)
    print()

# 关闭数据库连接
cursor.close()
cnx.close()