Prevent InnoDB auto increment ON DUPLICATE KEY

by

You could set the innodb_autoinc_lock_mode config option to "0" for “traditional” auto-increment lock mode, which guarantees that all INSERT statements will assign consecutive values for AUTO_INCREMENT columns.

That said, you shouldn’t depend on the auto-increment IDs being consecutive in your application. Their purpose is to provide unique identifiers.

More Related Contents:

  1. PHP MYSQL UPDATE if Exist or INSERT if not?
  2. PHP mySQL – Insert new record into table with auto-increment on primary key
  3. multiple auto increment in mysql
  4. If number have inside number string [closed]
  5. recurring system my sql query [closed]
  6. MySQL query won't update database [closed]
  7. Cannot modify header information [duplicate]
  8. Gather column name of a table from database [closed]
  9. PHP sending form data to the database
  10. inserting information and image in php and mysql
  11. CodeIgniter – foreach loop
  12. Insert form in MySQL with PDO [duplicate]
  13. Is the following code valid? [closed]
  14. Project Links do not work on Wamp Server
  15. SET NAMES utf8 in MySQL?
  16. Using Jquery Ajax to retrieve data from Mysql
  17. PHP, MySQL error: Column count doesn’t match value count at row 1
  18. displaying an image stored in a mysql blob
  19. Run a mySQL query as a cron job?
  20. Can I create a database using PDO in PHP?
  21. MySQL PHP incompatibility
  22. PHP PDO and MySQLi [duplicate]
  23. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  24. How to store an array into mysql?
  25. Error 1148 MySQL The used command is not allowed with this MySQL version
  26. How can I debug why simplest MySQL query returns false?
  27. How does {} affect a MySQL Query in PHP? [duplicate]
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. Limit pagination page number

Leave a Comment