Hi Johann, Im using old version of mysql Distrib 3.23.53 which this command is not available.
I tried another mysql which running version 5 and its working at that version. Allen --- On Wed, 9/22/10, Johann Vincent Paul Tagle <[email protected]> wrote: From: Johann Vincent Paul Tagle <[email protected]> Subject: Re: [plug] how to check if databases has existing tables To: "Philippine Linux Users' Group (PLUG) Technical Discussion List" <[email protected]> Date: Wednesday, September 22, 2010, 2:37 PM 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 -----Inline Attachment Follows----- _________________________________________________ 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
