MySQL ‘UPDATE ON DUPLICATE KEY’ without a unique column?

by

You can create a PRIMARY or UNIQUE key out of multiple columns (called a composite key) in MySQL, which’ll allow ON DUPLICATE KEY to work just fine.

// create a composite index
CREATE INDEX my_composite_index ON my_table (column1, column2);

// insert or update
INSERT INTO my_table (column1, column2) VALUES ('value1', 'value2') ON DUPLICATE KEY UPDATE column3=column3+1;

More Related Contents:

  1. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  2. MySQL update table based on another tables value
  3. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  4. On Duplicate Key Update same as insert
  5. Ordering by the order of values in a SQL IN() clause
  6. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  7. LAST_INSERT_ID() MySQL
  8. conditional join in mysql
  9. How to export and import a .sql file from command line with options? [duplicate]
  10. a count for each join – optimisation
  11. How to grant all privileges to root user in MySQL 8.0
  12. MySQL Group by SUM
  13. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  14. Search for all occurrences of a string in a mysql database [duplicate]
  15. How to add not null constraint to existing column in MySQL
  16. connect ECONNREFUSED – node js , sql
  17. MySQL Aggregate Functions without GROUP BY clause
  18. Count days between two dates, excluding weekends (MySQL only)
  19. How to insert values in table with foreign key using MySQL?
  20. Difference in minutes from two time fields in MySQL
  21. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  22. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  23. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  24. How to swap values of two rows in MySQL without violating unique constraint?
  25. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  26. Storing images in MySQL [closed]
  27. Would it help to add index to BIGINT column in MySQL?
  28. For homebrew mysql installs, where’s my.cnf?
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment