HomeInsert value “0″ for primary keys with auto increment in MySQL
Sunday, July 12th, 2009In order to insert value 0 in a field that is set as primary key for a MySQL table you need to execute the following query prior to any insert query: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; Now you can successfully run the insert query with 0 set as value for a primary key, ...
