From: walter harms
Date: December 14 2009 5:25pm
Subject: all tables with certain type
List-Archive: http://lists.mysql.com/mysql/219738
Message-Id: <4B26751F.9070505@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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