Question

How to check if database exists in MySQL with Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd=""
)

db_cursor = db.cursor()

# db_cursor.execute("CREATE DATABASE python_database")  # database already exists

db_cursor.execute("SHOW DATABASES")

for db_name in db_cursor:
    if db_name[0] == 'python_database':
        print(db_name[0])


'''
run:

python_database

'''

 

70+ SQL courses for beginners and professionals

Answer 2

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
 
import mysql.connector
 
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd=""
)
 
db_cursor = db.cursor()

db_cursor.execute("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'python_database'")

result = db_cursor.fetchall()

print(result)

for s in result:
    print(s)
    print(s[0])
 
 
'''
run:
 
[('python_database',)]
('python_database',)
python_database
 
'''

 

70+ SQL courses for beginners and professionals