aCJcsANs

1import MySQLdb
2# Open database connection
3db = MySQLdb.connect("localhost","root","1234","TESTDB" )
4
5# prepare a cursor object using cursor() method
6cursor = db.cursor()
7
8cursor.execute("DROP TABLE IF EXISTS EMP")
9
10sql = """CREATE TABLE EMP (NAME  CHAR(25) NOT NULL, DESIGNATION  CHAR(10),BASIC_PAY FLOAT)"""
11
12cursor.execute(sql)
13
14n = int(input('Enter Number of Records :'))
15
16for i in range(n):
17    name        = input('Enter Name :')
18    designation = input('Enter Designation :')
19    basic_pay   = float(input('Enter basic_pay :'))
20    sql = "INSERT INTO EMP(FNAME,DESIGNATION, BASIC_PAY) VALUES ('%s', '%s','%d' )" %(name, designation, basic_pay)
21
22    try:
23        cursor.execute(sql)
24        # Commit your changes in the database
25        db.commit()
26    except:
27        # Rollback in case there is any error
28        db.rollback()
29
30# disconnect from server
31db.close()