Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

How to Show All Tables in MySQL using Python?

  • Last Updated : 29 Sep, 2021

A connector is employed when we have to use mysql with other programming languages. The work of mysql-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and the MySQL Server.

In order to make python interact with the MySQL database, we use Python-MySQL-Connector. Here we will try implementing SQL queries which will show the names of all the tables present in the database or server.

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course

Syntax:



To show the name of tables present inside a database:

SHOW Tables;

To show the name of tables present inside a server:

SELECT table_name

FROM information_schema.tables;

Database in use:

Schema of the database used

The following programs implement the same.

Example 1: Display table names present inside a database:

Python3




import mysql.connector
 
mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    password="",
    database="gfg"
)
 
mycursor = mydb.cursor()
 
mycursor.execute("Show tables;")
 
myresult = mycursor.fetchall()
 
for x in myresult:
    print(x)

Output:

Table names in gfg  database

Example 2: Display table names present inside a server:

Python3




import mysql.connector
 
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="",
)
 
mycursor = mydb.cursor()
 
mycursor.execute("SELECT table_name FROM information_schema.tables;")
 
myresult = mycursor.fetchall()
 
for x in myresult:
  print(x)

Output:

Table names in server




My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!