sql1.py


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

# pip install mysql-connector-python

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="foobar",
  database="employees"
)

mycursor = mydb.cursor()
mycursor.execute("SHOW TABLES")
myresult = mycursor.fetchall()
for x in myresult:
  print(x)