Shulou(Shulou.com)06/01 Report--

First execute the command to view the configuration, as follows:

Show variables like'% increment%'

If:

Auto_increment_increment=2

Then execute:

Set @ @ global.auto_increment_increment = 1; set @ @ auto_increment_increment = 1

If:

Auto_increment_offset=2

Then execute:

Set @ @ global.auto_increment_offset = 1 * set @ @ auto_increment_offset = 1

These are the details of the self-increasing step size adjustment of mysql. Please pay attention to other related articles for more information.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.