Not the answer you need?
Register and ask your own question!

Find integer columns nearing the max column value

RkotRkot Current User Role Contributor


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

Best Answer

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.