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()
python操作mysql数据库
原文：http://blog.51cto.com/victor2016/2072484
