INSERT … ON DUPLICATE KEY UPDATE with WHERE?

by

I suggest you to use IF() to do that.

Refer: conditional-duplicate-key-updates-with-mysql

INSERT INTO daily_events (created_on, last_event_id, last_event_created_at)
  VALUES ('2010-01-19', 23, '2010-01-19 10:23:11')
ON DUPLICATE KEY UPDATE
  last_event_id = IF(last_event_created_at < VALUES(last_event_created_at), VALUES(last_event_id), last_event_id);

More Related Contents:

  1. Mysql replication with UPDATE JOIN on an ignored table
  2. Scaling solutions for MySQL (Replication, Clustering)
  3. How can “set timestamp” be a slow query?
  4. Should I use the datetime or timestamp data type in MySQL?
  5. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  6. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  7. Compare two MySQL databases [closed]
  8. MySQL – Trigger for updating same table after insert
  9. How do I get the current time zone of MySQL?
  10. Storing image in database directly or as base64 data?
  11. How to get the difference in years from two different dates?
  12. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  13. MySQL grant all privileges to database except one table
  14. Writing optional parameters within stored procedures in MySQL? [duplicate]
  15. How to get all columns’ names for all the tables in MySQL?
  16. How do I get MySQL to use an INDEX for view query?
  17. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  18. mysql stored procedure that calls itself recursively
  19. Restore the mysql database from .frm files
  20. When to use NULL in MySQL tables
  21. How to change MySQL table names in Linux server to be case insensitive?
  22. MySQL command line formatting with UTF8
  23. Mysql insert into 2 tables
  24. MySQL UPDATE and SELECT in one pass
  25. where does MySQL store database files?
  26. MySQL: How to retrieve a random row or multiple random rows?
  27. connecting to a docker-compose mysql container denies access but docker running same image does not
  28. MySQL’s lower_case_table_names won’t change
  29. #1214 – The used table type doesn’t support FULLTEXT indexes
  30. Optimistic locking in MySQL

Leave a Comment