python通过参数方式向mysql中添加数据的代码

将开发过程常用的内容段记录起来，如下的资料是关于python通过参数方式向mysql中添加数据的内容，希望对各朋友有用途。

#!/usr/bin/python

import MySQLdb

Open database connection

db = MySQLdb.connect(“localhost”,“testuser”,“test123”,“TESTDB” )

prepare a cursor object using cursor() method

cursor = db.cursor()

Prepare SQL query to INSERT a record into the database.

sql = “INSERT INTO EMPLOYEE(FIRST_NAME,
LAST_NAME, AGE, SEX, INCOME)
VALUES (’%s’, ‘%s’, ‘%d’, ‘%c’, ‘%d’ )” %
(‘Mac’, ‘Mohan’, 20, ‘M’, 2000)
try:

Execute the SQL command

cursor.execute(sql)

Commit your changes in the database

db.commit()
except:

Rollback in case there is any error

db.rollback()

disconnect from server

db.close()