Home >Database >Mysql Tutorial >MySQL查询和修改auto_increment的方法_MySQL
MySQL查询和修改auto_increment的方法_MySQL
- WBOYOriginal
- 2016-06-01 13:04:501447browse
本文实例讲述了MySQL查询和修改auto_increment的方法。分享给大家供大家参考。具体如下：
查询表名为tableName的auto_increment值：
代码如下:
SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name="tableName";
修改表名为tableName的auto_increment值：
代码如下:
ALTER TABLE tableName auto_increment=number ;
希望本文所述对大家的MySQL程序设计有所帮助。
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中的if和case语句使用总结_MySQLNext article：MySQL ERROR 2013 (HY000)错误解决方法_MySQL