SQL – IF EXISTS UPDATE ELSE INSERT INTO

by

  1. Create a UNIQUE constraint on your subs_email column, if one does not already exist:

    ALTER TABLE subs ADD UNIQUE (subs_email)

  2. Use INSERT ... ON DUPLICATE KEY UPDATE:

    INSERT INTO subs
  (subs_name, subs_email, subs_birthday)
VALUES
  (?, ?, ?)
ON DUPLICATE KEY UPDATE
  subs_name     = VALUES(subs_name),
  subs_birthday = VALUES(subs_birthday)

You can use the VALUES(col_name) function in the UPDATE clause to
refer to column values from the INSERT portion of the INSERT … ON
DUPLICATE KEY UPDATE – dev.mysql.com

  1. Note that I have used parameter placeholders in the place of string literals, as one really should be using parameterised statements to defend against SQL injection attacks.

More Related Contents:

  1. How to do a batch insert in MySQL
  2. How to copy a row and insert in same table with a autoincrement field in MySQL?
  3. MySQL Error 1264: out of range value for column
  4. How do I get the ID of multiple inserted rows in MySQL?
  5. How to insert data to MySQL with auto-incremented column(field)?
  6. MySQL INSERT INTO … VALUES and SELECT
  7. MySQL error 1241: Operand should contain 1 column(s)
  8. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  9. MySQL optimizing INSERT speed being slowed down because of indices
  10. MySQL: Insert datetime into other datetime field
  11. “Unknown column in ‘field list'”, but column does exist
  12. Insert and set value with max()+1 problems
  13. MySQL – Get row number on select
  14. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  15. How can I tell when a MySQL table was last updated?
  16. Operand Should Contain 1 Column – MySQL NOT IN
  17. SQL Query to get column values that correspond with MAX value of another column?
  18. MySQL : transaction within a stored procedure
  19. When to use SELECT … FOR UPDATE?
  20. BULK INSERT in MYSQL
  21. Setting column values as column names in the SQL query result
  22. How to get current date & time in MySQL?
  23. Laravel join with 3 Tables
  24. SELECT query return 1 row from each group
  25. How to regex in a MySQL query
  26. MySQL Group By Hours
  27. RMySQL dbWriteTable with field.types
  28. Syntax error on MERGE statement
  29. MySQL OPTIMIZE all tables?
  30. Strip last two characters of a column in MySQL

Leave a Comment