A super detailed tutorial: springboot integrates mybatis plus>>> 
NO_ AUTO_ VALUE_ ON_ Zero affects Auto_ Processing of the increment column. In general, you can insert null or 0 into the column to generate the next sequence number. NO_ AUTO_ VALUE_ ON_ Zero disable 0, so only null can generate the next sequence number.
If you save 0 to the table’s auto_ The increment column, which is useful（ This practice is not recommended). For example, if you dump a table with mysqldump and overload it, MySQL will generate a new serial number when it encounters a value of 0. The content of the generated table is different from that of the dumped table. Enable no before reloading dump files_ AUTO_ VALUE_ ON_ Zero can solve this problem.
Similar Posts:
- mysql: [Err] 1075 – Incorrect table definition; there can be only one auto column and it must be d…
- mysqldump unknown table ‘column_statistics’
- Postgres invalid command data recovery processing
- Failed to read auto-increment value from storage
- MySQL timestamp set default value error Invalid default value reason and solution
- [Solved] MySQL uses the workbench tool, and the table status is read only
- MYSQL ERROR 1005 (HY000): Can’t create table [How to Solve]
- [Solved] MySQL query reports an error: Legal mix of settlements
- [Solved] Backup mysql8.0 with the mysqldump of mysql5.7 Error
- When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’