MySQL Modify data table increment step

System variables can be modified auto_increment_increment

Mysql>SHOW VARIABLES like 'auto_inc%'; +--------------------------+-------+|Variable_name|Value|+--------------------------+-------+|Auto_increment_increment| 1     | View Step Size|Auto_increment_offset| 1     |+--------------------------+-------+

2 inset(0.00 sec)

MySQL>SET@ @auto_increment_increment=ten;   0 rows affected (0.00 sec)

Mysql>SHOW VARIABLES like 'auto_inc%';+--------------------------+-------+|Variable_name|Value|+--------------------------+-------+|Auto_increment_increment| Ten    | has been set to ten|Auto_increment_offset| 1     |+--------------------------+-------+2Rowsinch Set(0.01Sec

Data table self-increment will increment by 10

MySQL Modify data table increment step