Command-Line Format | --auto-increment-increment=# |
---|---|
System Variable | auto_increment_increment
|
Scope | Global, Session |
Dynamic | Yes |
SET_VAR Hint
Applies |
Yes |
Type | Integer |
Default Value | 1 |
Minimum Value | 1 |
Maximum Value | 65535 |
[...]
auto_increment_increment
is also supported for use with
NDB
tables.
[...]
[...]
[...]
auto_increment_increment
controls the interval between successive column values.
For example:
auto_increment_offset
determines the starting point for the
AUTO_INCREMENT
column value. Consider
the following, assuming that these statements are
executed during the same session as the example given in
the description for
auto_increment_increment
:
When the value of
auto_increment_offset
is greater than that of
auto_increment_increment
,
the value of
auto_increment_offset
is ignored.
[...]
auto_increment_offset
+
N
×
auto_increment_increment
where N
is a positive integer
value in the series [1, 2, 3, ...]. For example:
[...]
[...]
[...]
Command-Line Format | --auto-increment-offset=# |
---|---|
System Variable | auto_increment_offset
|
Scope | Global, Session |
Dynamic | Yes |
SET_VAR Hint
Applies |
Yes |
Type | Integer |
Default Value | 1 |
Minimum Value | 1 |
Maximum Value | 65535 |
[...]
[...]
[...]