On Duplicate Key Update same as insert

by

The UPDATE statement is given so that older fields can be updated to new value. If your older values are the same as your new ones, why would you need to update it in any case?

For eg. if your columns a to g are already set as 2 to 8; there would be no need to re-update it.

Alternatively, you can use:

INSERT INTO table (id,a,b,c,d,e,f,g)
VALUES (1,2,3,4,5,6,7,8) 
ON DUPLICATE KEY
    UPDATE a=a, b=b, c=c, d=d, e=e, f=f, g=g;

To get the id from LAST_INSERT_ID; you need to specify the backend app you’re using for the same.

For LuaSQL, a conn:getlastautoid() fetches the value.

More Related Contents:

  1. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  2. Too many auto increments with ON DUPLICATE KEY UPDATE
  3. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?
  4. mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  5. How to group by two rows in a column
  6. How to perform grouped ranking in MySQL
  7. How to abort INSERT operation in MySql trigger?
  8. MySQL: Select All Dates In a Range Even If No Records Present
  9. mysql update column with value from another table
  10. How to import an excel file in to a MySQL database
  11. MySQL strip non-numeric characters to compare
  12. How to get the sizes of the tables of a MySQL database?
  13. How to shrink/purge ibdata1 file in MySQL
  14. SQL query: Delete all records from the table except latest N?
  15. Rename a column in MySQL
  16. How to change collation of database, table, column?
  17. The total number of locks exceeds the lock table size
  18. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  19. How to subtract hours from a datetime in MySQL?
  20. MySQL “IN” operator performance on (large?) number of values
  21. Advanced MySql Query: Update table with info from another table
  22. MySQL CREATE FUNCTION Syntax
  23. MySQL sum elements of a column
  24. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  25. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  26. Why MySQL is giving error “Not allowed to return a result set from a function”?
  27. How to store decimal in MySQL?
  28. MySQL cumulative sum grouped by date
  29. Where I can find a list of “mysqldump” exit codes?
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment