Syntax error on MERGE statement

by

MERGE is not supported by MySQL, The equivalent for that is

INSERT … ON DUPLICATE KEY UPDATE

Try this,

INSERT INTO tableName (email, secret, passwd, ts, newAcct) 
VALUES ($1,$2,$3,$4,TRUE)
ON DUPLICATE KEY UPDATE newAcct=TRUE, existingUser=NULL, secret=$2, ts=$4

but be sure email is set as Primary Key or Unique.

More Related Contents:

  1. If two columns are 1 then make new column
  2. MySQL – Get row number on select
  3. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  4. Equivalent of explode() to work with strings in MySQL
  5. How can I tell when a MySQL table was last updated?
  6. Retrieving the last record in each group – MySQL
  7. Cast from VARCHAR to INT – MySQL
  8. Operand Should Contain 1 Column – MySQL NOT IN
  9. MySQL DELETE FROM with subquery as condition
  10. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  11. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  12. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  13. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  14. Determine Rank based on Multiple Columns in MySQL
  15. Checking multiple columns for one value
  16. What is better in MYSQL count(*) or count(1)?
  17. Best practices for SQL varchar column length [closed]
  18. ALTER TABLE to add a composite primary key
  19. How to get the count of each distinct value in a column? [duplicate]
  20. How to enable INNODB in mysql
  21. Bash script to insert values in MySQL
  22. What are differences between INSERT and UPDATE in MySQL?
  23. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  24. MySQL GROUP BY DateTime +/- 3 seconds
  25. How do I lag columns in MySQL?
  26. How to get multiple records against one record based on relation?
  27. SQL query to check if a name begins and ends with a vowel
  28. How to use a user variables in MySQL LIKE clause?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment