mysql 批量查询数据库是否存在

import mysql.connector

def check_database_exists(cursor, database_name):
    cursor.execute(f"SHOW DATABASES LIKE '{database_name}'")
    result = cursor.fetchone()
    return result is not None

def check_table_exists(cursor, database_name, table_name):
    cursor.execute(f"SHOW TABLES IN `{database_name}` LIKE '{table_name}'")
    result = cursor.fetchone()
    return result is not None

# 连接到 MySQL 服务器
cnx = mysql.connector.connect(user='your_username', password='your_password', host='your_host', database='your_database')
cursor = cnx.cursor()

# 检查数据库是否存在
database_name = 'your_database_name'
if check_database_exists(cursor, database_name):
    print(f"Database '{database_name}' exists.")
else:
    print(f"Database '{database_name}' does not exist.")

# 检查表是否存在
table_name = 'your_table_name'
if check_table_exists(cursor, database_name, table_name):
    print(f"Table '{table_name}' exists in database '{database_name}'.")
else:
    print(f"Table '{table_name}' does not exist in database '{database_name}'.")

# 关闭连接
cursor.close()
cnx.close()