mysql 自动加减步长,【Mysql】自增步长调整

mysql> show variables like '%increment%';

+-----------------------------+-------+

| variable_name | value |

+-----------------------------+-------+

| auto_increment_increment | 2 |

| auto_increment_offset | 1 |

| div_precision_increment | 4 |

| innodb_autoextend_increment | 64 |

+-----------------------------+-------+

4 rows in set (0.03 sec)

mysql> set @@global.auto_increment_increment = 1;

query ok, 0 rows affected (0.00 sec)

mysql> show variables like '%increment%';

+-----------------------------+-------+

| variable_name | value |

+-----------------------------+-------+

| auto_increment_increment | 2 |

| auto_increment_offset | 1 |

| div_precision_increment | 4 |

| innodb_autoextend_increment | 64 |

+-----------------------------+-------+

4 rows in set (0.07 sec)

mysql> set @@auto_increment_increment =1;

query ok, 0 rows affected (0.00 sec)

mysql>

mysql> show variables like '%increment%';

+-----------------------------+-------+

| variable_name | value |

+-----------------------------+-------+

| auto_increment_increment | 1 |

| auto_increment_offset | 1 |

| div_precision_increment | 4 |

| innodb_autoextend_increment | 64 |

+-----------------------------+-------+

4 rows in set (0.04 sec)

希望与广大网友互动？？

点此进行留言吧！