MySQL Lists: mysql: all tables with certain type

List:	General Discussion	« Previous Message Next Message »
From:	walter harms	Date:	December 14 2009 5:25pm
Subject:	all tables with certain type
View as plain text

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 ?

re,
 wh

Thread
• all tables with certain type	walter harms	14 Dec
• Re: all tables with certain type	Gary Smith	14 Dec