Python Alter Database Table
Sometimes, we may forget to create some columns, or we may need to update the table schema. The alter statement used to alter the table schema if required. Here, we will add the column branch_name to the table Employee. The following SQL query is used for this purpose.
alter table Employee add branch_name varchar(20) not null
Python Alter Database Table Example
import mysql.connector myconn = mysql.connector.connect(host = "localhost", user = "root",password = "naveen",database = "PythonDB") cur = myconn.cursor() try: #adding a column branch name to the table Employee cur.execute("alter table Employee add branch_name varchar(20) not null") except: myconn.rollback() myconn.close()