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 ，如需轉載請自行聯系原作者