1、错误描述
[SQL]show table status WHERE auto_increment-rows <> 1;
[Err] 1690 - BIGINT UNSIGNED value is out of range in '(`information_schema`.`tables`.`AUTO_INCREMENT` - `information_schema`.`tables`.`TABLE_ROWS`)'
2、错误原因
show table status WHERE auto_increment-rows <> 1;
在查看数据库表行数和自增长间隔不为1的表记录,超出了范围
3、解决办法
USE information_schema;
show table status WHERE information_schema.`TABLES`.AUTO_INCREMENT - information_schema.`TABLES`.TABLE_ROWS <> 1;