Python MySQLDB insert

db-insert.txt

#!/usr/bin/python

import MySQLdb
import datetime

# Open database connection
db = MySQLdb.connect("localhost","root","","know_your_beat" )

# prepare a cursor object using cursor() method
cursor = db.cursor()

current_time = datetime.datetime.utcnow()
# Prepare SQL query to INSERT a record into the database.
sql = """INSERT INTO current_heart_beat(bpm,tyme)
         VALUES ('50', '2012-12-15 11:15:09.205000')"""
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()