mysql 插入数据，如果存在，更新
INSERT INTO subs (subs_name, subs_email, subs_birthday) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE subs_name = VALUES(subs_name), subs_birthday = VALUES(subs_birthday)
如果批量操作，使用python:
sql = "insert into elec_workshop_15min_2017(start_time, " "name " \"values(%(start_time)s, %(name)s) ""on DUPLICATE KEY UPDATE stat_time = values(start_time), " "name = values(name)"
mysql_conn.executemany(sql, data) # data is a list of dict, for method to insert batch of tuple, google it.
ref: https://stackoverflow.com/questions/15383852/sql-if-exists-update-else-insert-into
原文：http://www.cnblogs.com/buxizhizhoum/p/7660530.html