Insert into a MySQL table or update if exists

by

Use INSERT ... ON DUPLICATE KEY UPDATE

QUERY:

INSERT INTO table (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE    
name="A", age=19

More Related Contents:

  1. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  2. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  3. SQL Query needed for fetch value from Two identical table but not fully identical table
  4. Error related to only_full_group_by when executing a query in MySql
  5. Remove duplicate rows in MySQL
  6. How to do the Recursive SELECT query in MySQL?
  7. MySQL, update multiple tables with one query
  8. Error Code: 2013. Lost connection to MySQL server during query
  9. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  10. SQL Performance UNION vs OR
  11. How do I select an entire row which has the largest ID in the table?
  12. How do I use on delete cascade in mysql?
  13. Adding a leading zero to some values in column in MySQL
  14. Using SQL to determine word count stats of a text field
  15. Update one MySQL table with values from another
  16. MySQL/MariaDB – order by inside subquery
  17. How to transpose mysql table rows into columns
  18. View’s SELECT contains a subquery in the FROM clause
  19. MySQL Group By and Sum total value of other column
  20. MySQL incorrect key file for tmp table when making multiple joins
  21. Does the order of conditions in a WHERE clause affect MySQL performance?
  22. Difference between these two joining table approaches?
  23. MySQL Stored Procedures not working with SELECT (basic question)
  24. MySQL query, MAX() + GROUP BY
  25. MySQL export into outfile : CSV escaping chars
  26. Simple Random Samples from a MySQL Sql database
  27. ALTER table – adding AUTOINCREMENT in MySQL
  28. MySQL Select minimum/maximum among two (or more) given values
  29. MySQL: Computed Column
  30. mySQL query to search all tables within a database for a string?

Leave a Comment