[Err] 1690 - BIGINT UNSIGNED value is out of range in

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;