How to force MySQL to take 0 as a valid auto-increment value

by

From the answer I got here:

You can use:

SET [GLOBAL|SESSION] sql_mode="NO_AUTO_VALUE_ON_ZERO"

Which as described here, will prevent MySQL from interpreting an INSERT/UPDATE ID of 0 as being the next sequence ID. Such behaviour will be limited to NULL.

It is what I’d consider pretty bad behaviour from the application though. You’ll have to be real careful that it’s used consistently, especially if you choose to implement replication at a later date.

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. MySQL AUTO_INCREMENT does not ROLLBACK
  6. Get current AUTO_INCREMENT value for any table
  7. SQL: Creating a Relational table with 2 different auto_increment
  8. How to handle fragmentation of auto_increment ID column in MySQL
  9. Prevent auto increment on MySQL duplicate insert
  10. Add Auto-Increment ID to existing table?
  11. How to fill in the “holes” in auto-increment fields?
  12. How to insert data to MySQL with auto-incremented column(field)?
  13. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  14. auto_increment by group
  15. How does MySQL Auto Increment work?
  16. Why does MySQL autoincrement increase on failed inserts?
  17. Defining Composite Key with Auto Increment in MySQL
  18. mysql Failed to read auto-increment value from storage engine
  19. Too many auto increments with ON DUPLICATE KEY UPDATE
  20. How to reuse auto_increment values? [duplicate]
  21. make an ID in a mysql table auto_increment (after the fact)
  22. How to escape single quotes in MySQL
  23. MySQL comparison with null value
  24. INTERSECT in MySQL
  25. MySQL select with CONCAT condition
  26. mysql field name from variable
  27. Multiple select statements in Single query
  28. How to import large sql file in phpmyadmin
  29. How to figure out size of Indexes in MySQL
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment