Skip to content
Related Articles

Related Articles

How to Show All Tables in MySQL using Python?
  • Last Updated : 26 Dec, 2020
GeeksforGeeks - Summer Carnival Banner

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.

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  databasse

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


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.

My Personal Notes arrow_drop_up
Recommended Articles
Page :