INSERT … ON DUPLICATE KEY (do nothing)

by

Yes, use INSERT ... ON DUPLICATE KEY UPDATE id=id (it won’t trigger row update even though id is assigned to itself).

If you don’t care about errors (conversion errors, foreign key errors) and autoincrement field exhaustion (it’s incremented even if the row is not inserted due to duplicate key), then use INSERT IGNORE like this:

INSERT IGNORE INTO <table_name> (...) VALUES (...)

More Related Contents:

  1. difference between primary key and unique key
  2. how to delete data from table A besides the customer service and director data in table B?
  3. Get records with max value for each group of grouped SQL results
  4. How to populate a table with a range of dates?
  5. MYSQL OR vs IN performance
  6. SELECTING with multiple WHERE conditions on same column
  7. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  8. How to find gaps in sequential numbering in mysql?
  9. MySQL: Invalid use of group function
  10. MySQL: View with Subquery in the FROM Clause Limitation
  11. MySQL/MariaDB – order by inside subquery
  12. Can MySQL replace multiple characters?
  13. OUTPUT Clause in MySQL
  14. Using ORDER BY and GROUP BY together
  15. Sorting by date & time in descending order?
  16. Case statement in MySQL
  17. MySQL Pivot Table Column Data as Rows
  18. updating columns with a sequence number mysql
  19. MySQL, Concatenate two columns
  20. Select a column with a keyword name
  21. MySQL: Inner join vs Where [duplicate]
  22. ERROR 1148: The used command is not allowed with this MySQL version
  23. Selecting from two tables with inner join and limit [duplicate]
  24. Use Composite Primary Key as Foreign Key
  25. How to select data where a field has a min value in MySQL?
  26. How to SELECT by MAX(date)?
  27. get a recursive parent list
  28. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  29. Deleting a row based on the max value
  30. MySQL Multiple Joins in one query?

Leave a Comment