Home »
Python »
Python programs
Insertion of Records to Database in Python
Here, we will see a program to illustrate the insertion of records to a database in Python.
Submitted by Shivang Yadav, on February 16, 2021
Problem Statement: We need to take input from users about all information to be fed in the tables and then insert it into the database using Python.
Problem Description: We will take input from the user for all table columns and then create a query to insert the information into the database using Python.
Algorithm:
- Step 1: Create a connection using connect method.
- Step 2: Take input from the user.
- Step 3: Create a Query, using the inserted information.
- Step 4: Execute the query which will enter the information to the table.
Program to illustrate Insertion of records to database in Python
import pymysql as ps
try:
cn=ps.connect(host='localhost',port=3306,user='root',password='123',db='tata')
cmd=cn.cursor()
pid=input("Enter Product Id:")
pn=input("Enter Product Name:")
pr = input("Enter Product Rate:")
md = input("Enter Mf. Date:")
query="insert into products values('{}','{}',{},'{}')".format(pid,pn,pr,md)
cmd.execute(query)
cn.commit()
cn.close()
print("Record Submitted")
except Exception as e:
print(e)
Output:
Enter Product Id: 001
Enter Product Name: Sensor 421
Enter Product Rate: 250
Enter Mf. Date: 3.2.2020
Record Submitted
Python database (SQL/MySQL) programs »
ADVERTISEMENT
ADVERTISEMENT