作者：陈庭勇筱玲喜芳 | 来源：互联网 | 2014-06-09 00:50
设置MySQL自动增长起点和步长mysql>SET@auto_increment_increment10;www.2cto.commysql>SHOWVARIABLESLIKE'auto_inc%';+--------------------------+-------+..
设置MySQL自动增长起点和步长
mysql> SET @auto_increment_increment=10;
www.2cto.com
mysql> SHOW VARIABLES LIKE &＃39;auto_inc%&＃39;;
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 10 |
| auto_increment_offset | 1 |
+--------------------------+-------+
2 rows in set (0.01 sec)
京公网安备 11010802041100号