Insert

Writing a SQL Query in python using Insert statement to insert records in MySql

We use Insert statement to insert data into database. Get inputs-code and name from screen and pass as parameter to query. Data is inserted to database on commit;

#MySql – Python Insert Statement

File: insert_emp.py

from database_connection import *

mycursor=db_con.cursor()

#query="insert into emp(code,name) values('a03','arvind')"

#mycursor.execute(query)

#db_con.commit()

pcode=raw_input("Enter code: ")

pname=raw_input("Enter Name: ")

query="insert into emp(code,name) values(%s,%s)"

mycursor.execute(query,(pcode,pname))

db_con.commit()

db_con.close()

Result