A connector is employed when we have to use mysql with other programming languages. The work ofmysql-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:

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

Output:

Example 2: Display table names present inside a server:

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

Output:

Similar Reads