inserting sql data by using python
import mysql.connector
vishwa=mysql.connector.connect(user="name",host="localhost",password="password",database="maths")
my=vishwa.cursor()
print("Enter the name:")
a=input()
print("Enter the id:")
c=input()
b=","
d=a+b+c
e="insert into vishwa values("+d
f=e+")"
my.execute(f)
for i in my:
print(i)
print(my.rowcount,"data inserted")
vishwa.commit()
Comments
Post a Comment