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  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
