SET SQL _MODE = & quot; NO_AUTO_VALUE_ON_ZERO & quot;

SET SQL _MODE = "NO_AUTO_VALUE_ON_ZERO" NO_AUTO_VALUE_ON_ZERO affects the processing of the AUTO_INCREMENT column. Generally, you can insert NULL or 0 to this column to generate the next serial number. NO_AUTO_VALUE_ON_ZERO disables 0, so only NULL can generate the next serial number. This mode is useful if the result is to save 0 to the AUTO_INCREMENT column of the table. (This Convention is not recommended ). For example, if you use mysqldump to dump a table and reload the table, MySQL generates a new serial number when it encounters a value of 0. The contents of the generated table are different from those of the dump table. Enable NO_AUTO_VALUE_ON_ZERO before reloading the dump file to solve this problem.