walter harms wrote:
hi list, is it possible to get a list of all tables with a certain type in one statement ?for now i collect all tables (show tables) and search for the type (show columns). Any way to circumvent that ? make it one statement ?
use information_schema;select column_name,data_type from columns where data_type='YOUR DATA TYPE HERE';
Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
