select TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,AUTO_INCREMENT,TABLE_ROWS from information_schema.`TABLES` where TABLE_SCHEMA = '数据库名' and TABLE_NAME = '表名' ;select TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,AUTO_
阅读背景：
mysql 查询表信息,递增主键id
来源：互联网
分享到：
