python操作mysql数据库

import pymysql

db = pymysql.connect("192.168.3.5","root","passwd","dbname")

cursor = db.cursor()

sql = "select version()"

try:

cursor.execute(sql)

db.commit()

except Exception as e:

db.rollback()

db.close()

本文转自chenzudao51CTO博客，原文链接：http://blog.51cto.com/victor2016/2072484 ，如需转载请自行联系原作者