Question

How to get a list of all MySQL tables from a specific database in 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="",
    database="standupd"
)

db_cursor = db.cursor()

db_cursor.execute("SHOW TABLES")

for tbl_name in db_cursor:
    print(tbl_name[0])

'''
run:

am_categories
am_code
am_url_click_info
am_users

'''

 

70+ SQL courses for beginners and professionals