设置MySQL自动增长起点和步长_MySQL
- WBOYOriginal
- 2016-06-01 13:38:251392browse
bitsCN.com
设置MySQL自动增长起点和步长
mysql> SET @auto_increment_increment=10;
mysql> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 10 |
| auto_increment_offset | 1 |
+--------------------------+-------+
2 rows in set (0.01 sec)
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MYSQL入门之三_将本地MySQL数据导入SAE数据库_MySQLNext article：mysql导出导入中文表_MySQL