Hi
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
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
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.