Insert into a MySQL table or update if exists

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

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. MySQL create table if not exists and insert record only if table was created
  8. How do I use properly CASE..WHEN in MySQL
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. What’s the difference between VARCHAR and CHAR?
  12. Case statement in MySQL
  13. How to declare a variable in MySQL?
  14. MySQL Cannot Add Foreign Key Constraint
  15. How to split the name string in mysql?
  16. How do I import an SQL file using the command line in MySQL?
  17. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  18. mysql Foreign key constraint is incorrectly formed error
  19. MySQL: Invalid use of group function
  20. How can I return pivot table output in MySQL?
  21. Compare dates in MySQL
  22. MySQL “WITH” clause
  23. MySQL Multiple Joins in one query?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. MySQL syntax for Join Update
  26. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  27. SQLite – UPSERT *not* INSERT or REPLACE
  28. how to drop partition without dropping data in MySQL?
  29. MySQL combine two columns into one column
  30. Simple way to calculate median with MySQL
  31. Error 1046 No database Selected, how to resolve?
  32. MySQL Error 1264: out of range value for column
  33. Remove duplicate rows in MySQL
  34. How to SUM and SUBTRACT using SQL?
  35. Cast from VARCHAR to INT – MySQL
  36. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  37. How do you force mysql LIKE to be case sensitive?
  38. MySQL – UPDATE multiple rows with different values in one query
  39. How to create a MySQL hierarchical recursive query?
  40. ERROR 1148: The used command is not allowed with this MySQL version
  41. How to round down to nearest integer in MySQL?
  42. MySQL starts with searching issue
  43. Query to convert from datetime to date mysql
  44. Is it possible to GROUP BY multiple columns using MySQL?
  45. MySQL error: key specification without a key length
  46. Best way to test if a row exists in a MySQL table
  47. Check if MySQL table exists without using “select from” syntax?
  48. MySQL equivalent of DECODE function in Oracle
  49. mysql update column with value from another table
  50. The used SELECT statements have a different number of columns
  51. How to delete from multiple tables in MySQL?
  52. MySQL: Can’t create table (errno: 150)
  53. How to copy a row and insert in same table with a autoincrement field in MySQL?
  54. Join vs. sub-query
  55. Alternative to except in MySQL
  56. Equivalent of explode() to work with strings in MySQL
  57. ROW_NUMBER() in MySQ
  58. Solutions for INSERT OR UPDATE on SQL Server
  59. MySQL OPTIMIZE all tables?
  60. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  61. MySQL – Get row number on select
  62. MySQL error: Unknown column in ‘where clause’
  63. How to truncate the text returned for a column in a MySQL query
  64. Using union and order by clause in mysql
  65. MySQL LIKE IN()?
  66. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  67. What’s the best way to search for a UPC code in a Database?
  68. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  69. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  70. What is the difference between UNION and UNION ALL?
  71. Selecting COUNT(*) with DISTINCT
  72. Case in Select Statement
  73. What is a stored procedure?
  74. ORA-00904: invalid identifier
  75. SQL WITH clause example [duplicate]
  76. SQL Inner-join with 3 tables?
  77. The wait operation timed out. ASP
  78. What is SELF JOIN and when would you use it? [duplicate]
  79. The wait operation timed out. ASP
  80. Conversion failed when converting date and/or time from character string while inserting datetime
  81. Self Join to get employee manager name
  82. How do I UPDATE from a SELECT in SQL Server?
  83. how to fix oracle ORA-01722 invalid number error
  84. SQL query to select dates between two dates
  85. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  86. SQL SELECT WHERE field contains words
  87. Conversion failed when converting date and/or time from character string while inserting datetime
  88. When should I use CROSS APPLY over INNER JOIN?
  89. Insert Data Into Temp Table with Query
  90. error, string or binary data would be truncated when trying to insert
  91. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  92. NOT IN vs NOT EXISTS
  93. SQL SELECT WHERE field contains words
  94. Online SQL Query Syntax Checker
  95. How can I do an UPDATE statement with JOIN in SQL Server?
  96. Must declare the scalar variable
  97. How do I use MySQL through XAMPP?
  98. ORA-00979 not a group by expression
  99. ORA-00907: missing right parenthesis
  100. Must declare the scalar variable

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)