关于python使用MySQLdb新增操作

import MySQLdbfrom time import ctimeconn = MySQLdb.connect(host="localhost",user="root",passwd="",db="python")cursor = conn.cursor()sql = """INSERT INTO python.py_user_test            (username,             PASSWORD,             fstcreate)SELECT  username,  PASSWORD,  fstcreateFROM python.py_user"""try:    res = cursor.execute(sql)    print "success"    conn.commit()except:    print "error"    conn.rollback()    conn.close()