On duplicate key ignore? [duplicate]

by

Would suggest NOT using INSERT IGNORE as it ignores ALL errors (ie its a sloppy global ignore).
Instead, since in your example tag is the unique key, use:

INSERT INTO table_tags (tag) VALUES ('tag_a'),('tab_b'),('tag_c')
ON DUPLICATE KEY UPDATE tag=tag;

on duplicate key produces:

Query OK, 0 rows affected (0.07 sec)

More Related Contents:

  1. left join query keep a column empty
  2. How to do a regular expression replace in MySQL?
  3. Rank function in MySQL
  4. Count the number of occurrences of a string in a VARCHAR field?
  5. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  6. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  7. Can’t connect to MySQL server error 111 [closed]
  8. How to import a CSV file into a MySQL table
  9. How to store arrays in MySQL?
  10. Include headers when using SELECT INTO OUTFILE?
  11. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  12. How do I select between the 1st day of the current month and current day in MySQL?
  13. Subqueries with EXISTS vs IN – MySQL
  14. MySQL timezone change?
  15. ON DUPLICATE KEY + AUTO INCREMENT issue mysql
  16. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  17. Capitalize first letter. MySQL
  18. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  19. MySQL remote connection fails with “unknown authentication method”
  20. SQL Group By with an Order By
  21. Import MySQL database into a SQL Server
  22. How does MySQL’s ORDER BY RAND() work?
  23. How create json format with group-concat mysql?
  24. UPDATE all records with a random number from a range
  25. mysql sorting of version numbers
  26. Get Insert Statement for existing row in MySQL
  27. DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
  28. Can’t access mysql from command line on a Mac
  29. MySQL errorno 121
  30. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?

Leave a Comment