MySQL Insert on duplicate key

MySQL insert data, if present, update

INSERT  into Subs  (Subs_name, Subs_email, Subs_birthday) VALUES   (?, ?, ?)  on KEY UPDATE   subs_name     =VALUES(subs_name),  =  VALUES(Subs_birthday)

If you are working in bulk, use 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