How to create and show table in mysql database using python on CentOS and RHEL 6/7 step by step guide

In this article we will learn how to create mysql table in database using python language.

We need to install the mysql.connector module using the below command.

#pip3 install mysql.connector

Normally we create mysql table into database using “create table” statement and select the database in which mysql table will be created.

How to create mysql table into databse using python

First we need to create one file named createtable.py and enter the below code into this file .

import mysql.connector

mydb = mysql.connector.connect(

host="localhost",

user="root",

passwd="abc123",

database=” pythonclass”

)

cur = mydb.cursor()

cur.execute("CREATE TABLE student (name VARCHAR(30), location VARCHAR(100))")

How to execute the python progam

To execute the python program we need to execute the below command.

[root@localhost ~]# python3 createtable.py

After executing the above command new table has been created.

Now enter the mysql promt and verify it is created or not using “show tables” statement.

mysql> show tables;

+-----------------------+

| Tables_in_pythonclass |

+-----------------------+

| student |

+-----------------------+

1 row in set (0.00 sec)

How to create and show table in mysql database using python on CentOS and RHEL 6/7 step by step guide

How to view mysql database table using python

We also can check created table list using python program.

We create one file name showtable.py and enter the below command.

import mysql.connector

mydb = mysql.connector.connect(

host="localhost",

user="root",

passwd="abc123"

database=”pythonclass”

)

cur = mydb.cursor()

cur.execute("SHOW TABLES")

for x in cur:

print(x)

That’s all. If this article is helpful please share it!!!!

How to create and show table in mysql database using python on CentOS and RHEL 6/7 step by step guide