Note
This variable is available starting with V1.4.
Description
auto_increment_offset specifies the starting value of the AUTO_INCREMENT column.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the values of Global system variables.Modify variables
systenants can directly modify the values of Global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the values of Global system variables.
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 starting value of the AUTO_INCREMENT column to 1.
Global level
obclient> SET GLOBAL auto_increment_offset =1;Session level
obclient> SET auto_increment_offset =1;