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.connectormydb = 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.connectormydb = 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
