Adding new enum column to an existing MySQL table using Python
Prerequisite: Python: MySQL Create Table
In this article, we are going to see how to add a new enum column to an existing MySQL table using Python. Python allows the integration of a wide range of database servers with applications. A database interface is required to access a database from Python. MySQL Connector-Python module is an API in python for communicating with a MySQL database.
Database table in use:
We are going to use geeks(Database name) database and table describing the salary.
Approach:
- Import module.
- Make a connection request with the database.
- Create an object for the database cursor.
- Execute the following MySQL query:
ALTER TABLE table_name ADD colunm_name ENUM('field1','field2',...)
Below is the implementation with python:
Python3
import mysql.connector
db = mysql.connector.connect(
host = "localhost" ,
user = "root" ,
password = "rot23" ,
database = "geeks"
)
mycursor = db.cursor()
query = "ALTER TABLE store ADD Department ENUM('Sweet','Snaks');"
mycursor.execute(query)
mycursor.execute( " desc store;" )
myresult = mycursor.fetchall()
for row in myresult:
print (row)
db.commit()
db.close()
|
Output:
Let’s check on SQL shell:
Last Updated :
25 Feb, 2021
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...