Note
This variable is available starting with V1.4.
Description
auto_increment_increment specifies the increment value for auto-increment columns. This variable is available only for MySQL clients.
Privilege requirements
Query variables
Global level
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a Global system variable.Session level
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the value of a Session system variable.
Modify variables
Global level
The
systenant can modify the value of a Global system variable.A MySQL user tenant must have the
SUPERorALTER SYSTEMprivilege to modify the value of a Global system variable.
Session level
The
systenant and all user tenants can modify the value of a Session system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Uint |
| Default value | 1 |
| Value range | [1, 65535] |
| Scope |
|
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the increment value for auto-increment columns to 1.
Global level
obclient> SET GLOBAL auto_increment_increment =1;Session level
obclient> SET auto_increment_increment =1;