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/mysql?unsub=arch...@jab.org
