Determining what tables with an auto incrementing primary key are coming close to the max of the int datatype (80%)

its_its_its_its_BIGINT_time.sql

SELECT t.TABLE_NAME, `AUTO_INCREMENT`
FROM information_schema.TABLES AS t
JOIN information_schema.COLUMNS AS c ON (
  c.COLUMN_NAME = 'id' AND
  c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
  c.TABLE_NAME = t.TABLE_NAME AND
  c.`DATA_TYPE` = 'int'
)
WHERE AUTO_INCREMENT > 1717986918;