Is there any way to find all columns in all tables in a database where the max value is approaching the max value of the integer column ?
eg - when column is integer
Select * from table where max(column) > 2147480000
Hi, you should be able to write a script to determine this by querying the max(col) for each column for each table and comparing to the max possible value. Something like this for example: https://github.com/RickPizzi/pztools/blob/master/findmax.sh
Please note I haven't tested it so use with care
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.