I don't have the time to write the exact SQL right now, but use the information_schema database/schema. Join the SCHEMATA table (which lists all databases) and the TABLES table (which lists tables in the database), just exclude the mysql and information_schema databases.
On Wed, Sep 22, 2010 at 2:28 PM, Allen Umlas <[email protected]> wrote: > > > Hi guys, > > I have shared web hosting using mysql database. I was referring > multiple databases. It will take time for me to use such common command like > > use <database>; > then > show <tables>; to verify if there's existing tables. > > I try to use this command > > select User,Db from mysql.db; > > to check the all databases but still i cannot get what i want > > How can i get information for the database with existing tables and those > database without tables? > > > > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph >
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
