How do I UPDATE a row in a table or INSERT it if it doesn’t exist?

by

MySQL (and subsequently SQLite) also support the REPLACE INTO syntax:

REPLACE INTO my_table (pk_id, col1) VALUES (5, '123');

This automatically identifies the primary key and finds a matching row to update, inserting a new one if none is found.

Documentation: https://dev.mysql.com/doc/refman/8.0/en/replace.html

More Related Contents:

  1. Why do results from a SQL query not come back in the order I expect?
  2. Insert into a MySQL table or update if exists
  3. How to filter SQL results in a has-many-through relation
  4. How to select the nth row in a SQL database table?
  5. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  6. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  7. Simple Random Samples from a Sql database
  8. SQL: Repeat a result row multiple times, and number the rows
  9. Best practices for SQL varchar column length [closed]
  10. Are SELECT type queries the only type that can be nested?
  11. how to cast the hexadecimal to varchar(datetime)?
  12. Postgres LEFT JOIN with WHERE condition
  13. What are the max number of allowable parameters per database provider type?
  14. What happens when I exhaust a bigint generated key? How to handle it?
  15. Recreating a query using INNER JOIN? [duplicate]
  16. Create a Cumulative Sum Column in MySQL
  17. Equivalent of explode() to work with strings in MySQL
  18. mysql select dynamic row values as column names, another column as value
  19. MySQL DELETE FROM with subquery as condition
  20. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  21. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  22. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  23. How do I use properly CASE..WHEN in MySQL
  24. Determine Rank based on Multiple Columns in MySQL
  25. Checking multiple columns for one value
  26. What is better in MYSQL count(*) or count(1)?
  27. Delete query not working in mysql
  28. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment