python executemany
生活随笔
收集整理的這篇文章主要介紹了
python executemany
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
#coding:utf8
conn = MySQLdb.connect(host = “localhost”, user = “root”, passwd = “123456”, db = “myDB”)
cursor = conn.cursor()
sql = “insert into myTable (created_day,name,count) values(%s,%s,%s) ON DUPLICATE KEY UPDATE count=count+values(count)”
args=[("2012-08-27","name1",100),("2012-08-27","name1",200),("2012-08-27","name2",300)]
try:cursor.executemany(sql, args)
except Exception as e:print0(“執行MySQL: %s 時出錯：%s” % (sql, e))
finally:cursor.close()conn.commit()conn.close()
總結
以上是生活随笔為你收集整理的python executemany的全部內容，希望文章能夠幫你解決所遇到的問題。
