NO_AUTO_VALUE_ON_ZERO

This page is part of MariaDB's Documentation.

The parent of this page is: SQL Modes

Topics on this page:

• Overview

• USAGE

• DETAILS

  • SYNONYMS

  • SCHEMA

  • PARAMETERS

  • SKYSQL

  • PRIVILEGES

• EXAMPLES

• ERROR HANDLING

• FEATURE INTERACTION

• RESPONSES

• DIAGNOSIS

• ISO 9075:2016

• CHANGE HISTORY

• RELATED TOPICS

• EXTERNAL REFERENCES

Overview

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.