Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/python/how-to-show-all-tables-in-mysql-using-python/ below:

How to Show All Tables in MySQL using Python?

Last Updated : 23 Jul, 2025

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:

The following programs implement the same.

Example 1: Display table names present inside a database:

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:

Example 2: Display table names present inside a server:

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:

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4