mysql insert on duplicate key

標籤：val   pre   pytho   https   flow   dict   any   min   大量操作   

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

mysql insert on duplicate key