python mysql表是否存在

import mysql.connector

def check_table_exists(host, user, password, database, table_name):
    try:
        # 建立数据库连接
        connection = mysql.connector.connect(
            host=host,
            user=user,
            password=password,
            database=database
        )
        
        cursor = connection.cursor()
        
        # 使用information_schema查询表是否存在
        query = """
        SELECT COUNT(*) FROM information_schema.TABLES 
        WHERE TABLE_SCHEMA = %s AND TABLE_NAME = %s
        """
        cursor.execute(query, (database, table_name))
        
        # 获取查询结果
        result = cursor.fetchone()
        
        # 如果存在，result[0]将为1
        return result[0] == 1
    
    except mysql.connector.Error as err:
        print(f"Error: {err}")
        return False
    
    finally:
        # 关闭连接
        if connection.is_connected():
            cursor.close()
            connection.close()

# 使用示例
host = 'localhost'
user = 'your_username'
password = 'your_password'
database = 'your_database'
table_name = 'your_table'

if check_table_exists(host, user, password, database, table_name):
    print(f"Table '{table_name}' exists.")
else:
    print(f"Table '{table_name}' does not exist.")