AUTO_ VALUE_ ON_ ZERO
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: SQL Modes
Topics on this page:
This mode disables the default behavior that occurs when the value
0 is inserted into an
AUTO_INCREMENT column. By default, the value
0 is handled similar to
NULL, so a new auto-increment value is generated and inserted into the column, and the value
0 is discarded. When this mode is enabled, no auto-increment value is generated, and the value
0 is inserted into the column.
See also: SQL Modes, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
See also: SQL Modes, in 10.5 ES, and in 10.4 ES