How to use Python connector to check if a table/database in MySQL already exists?

Question

So, I want to create a program that will take input from the user about everything, i.e. database name, table name, table structure (column names), data and then perform various add, delete, update on it and other functions. But I can't check if the table/database entered by the user already exists. I tried the following code:

def create_table():
    table_in_database=input('Please enter the name of the database in which you want to create this table:')
    x=mysql.connect(host=host_name,user=user_name,password=user_password,database=table_in_database)
    y=x.cursor()
    if table_in_database in y.fetchall():
        name_table=input('Please enter the name of the table to be created:')
        if name_table in y.fetchall():
            print('Table already exists, please try another name or use an existing table')
        else:
            table_structure=tuple(input('Please enter the structure/row names of the table (separated by commas):'))
            y.execute('create table ' name_table '' table_structure '')
            print('table', name_table, 'created successfully')
            x.commit()
    else:
        print('database', table_in_database, 'does not exist')

But it fails to do y.fetchall(), so I even tried using a different function show_database() which shows all databases instead of using y.fetchall(), but then I got a NoneType error. Is there any way to check if the table/database exists?

Answer 1

If you connect to a database and run the query SHOW TABLES;, it will return a list of all tables in that database.
You can use criteria to search more precisely:

SHOW tables 
WHERE Tables_in_test ='triangle';
+----------------+
| Tables_in_test |
+----------------+
| triangle       |
+----------------+

You need to modify the column names to match your database.

Tables_in_[database_name]