Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

by

Unfortunately not.

You can get half-way there by not having to repeat the value:

INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3)
  ON DUPLICATE KEY UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`);

But you still have to list the columns.

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. MySQL Conditional Insert
  3. How to set initial value and auto increment in MySQL?
  4. How to do a batch insert in MySQL
  5. Get the new record primary key ID from MySQL insert query?
  6. On Duplicate Key Update same as insert
  7. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  8. LAST_INSERT_ID() MySQL
  9. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  10. MySql Table Insert if not exist otherwise update
  11. MySQL trigger On Insert/Update events
  12. How to copy a row and insert in same table with a autoincrement field in MySQL?
  13. MySQL Error 1264: out of range value for column
  14. BULK INSERT in MYSQL
  15. How do I get the ID of multiple inserted rows in MySQL?
  16. MySQL trigger to update a field to the value of id
  17. How to insert data to MySQL with auto-incremented column(field)?
  18. How to insert values in table with foreign key using MySQL?
  19. MySQL Insert & Joins
  20. How to add a where clause in a MySQL Insert statement?
  21. Reserved word in column name – insert into MySQL [duplicate]
  22. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  23. MySQL – insert data from another table merged with constants
  24. Insert data into table with result from another select query
  25. Too many auto increments with ON DUPLICATE KEY UPDATE
  26. MySQL optimizing INSERT speed being slowed down because of indices
  27. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  28. Incorrect integer value: ” for column ‘id’ at row 1
  29. “Unknown column in ‘field list'”, but column does exist
  30. Insert and set value with max()+1 problems

Leave a Comment