mysql获取数据库中所有表的名称

SHOW TABLES;

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

import pymysql

# 连接MySQL数据库
connection = pymysql.connect(host='your_mysql_host',
                             port=your_mysql_port,
                             user='your_mysql_user',
                             password='your_mysql_password',
                             db='your_database_name',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        # 执行查询语句
        cursor.execute("SHOW TABLES;")
        
        # 获取所有表的名称
        tables = cursor.fetchall()
        
        # 输出表名
        for table in tables:
            print(table['Tables_in_your_database_name'])

finally:
    # 关闭数据库连接
    connection.close()