Too many auto increments with ON DUPLICATE KEY UPDATE

by

I don’t think there is a way to bypass this behaviour of INSERT ... ON DUPLICTE KEY UPDATE.

You can however put two statements, one UPDATE and one INSERT, in one transaction:

START TRANSACTION ;

UPDATE pages
SET etc="randomness"
WHERE name="bob" ;

INSERT INTO pages (name, etc)
SELECT 
      'bob' AS name
    , 'randomness' AS etc 
FROM dual 
WHERE NOT EXISTS
      ( SELECT *
        FROM pages p
        WHERE p.name="bob"
      ) ;

COMMIT ;

More Related Contents:

  1. How to reset AUTO_INCREMENT in MySQL
  2. How to make MySQL table primary key auto increment with some prefix
  3. How to set initial value and auto increment in MySQL?
  4. Get the new record primary key ID from MySQL insert query?
  5. On Duplicate Key Update same as insert
  6. MySQL AUTO_INCREMENT does not ROLLBACK
  7. Get current AUTO_INCREMENT value for any table
  8. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  9. SQL: Creating a Relational table with 2 different auto_increment
  10. How to handle fragmentation of auto_increment ID column in MySQL
  11. Prevent auto increment on MySQL duplicate insert
  12. Prevent InnoDB auto increment ON DUPLICATE KEY
  13. Add Auto-Increment ID to existing table?
  14. How to fill in the “holes” in auto-increment fields?
  15. How to insert data to MySQL with auto-incremented column(field)?
  16. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  17. auto_increment by group
  18. How does MySQL Auto Increment work?
  19. Why does MySQL autoincrement increase on failed inserts?
  20. How to force MySQL to take 0 as a valid auto-increment value
  21. Defining Composite Key with Auto Increment in MySQL
  22. mysql Failed to read auto-increment value from storage engine
  23. How to reuse auto_increment values? [duplicate]
  24. make an ID in a mysql table auto_increment (after the fact)
  25. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?
  26. MySql Query Replace NULL with Empty String in Select
  27. What are the max number of allowable parameters per database provider type?
  28. How to handle a query with special characters / (forward slash) and \ (backslash)
  29. Does MySQL support historical date (like 1200)?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment