1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    I need get information (names) of all tables in all databases in MySQL. I know that exist the command "show tables;" but I need to change to every database one by one. My question is:

    Is there a command that give me this information of all databases in one step?

    Thank you very much,
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Rep Power
    I don't know about a single query that would do it, but why don't you grab each db from the result of 'show databases' and stuff them into an array then use the array as imput into a series of 'show tables' queries. Its a hack I know, but...

Similar Threads

  1. Show databases, Show tables, Describe table
    By genedavinci in forum PostgreSQL Help
    Replies: 6
    Last Post: October 20th, 2004, 02:43 PM
  2. Replies: 3
    Last Post: April 27th, 2003, 11:19 PM
  3. Replies: 1
    Last Post: January 16th, 2003, 12:35 PM
  4. C and databases
    By Saaden in forum C Programming
    Replies: 2
    Last Post: July 29th, 2002, 05:07 PM
  5. Coherent data in multiple tables
    By Sungam in forum Database Management
    Replies: 1
    Last Post: May 27th, 2002, 07:34 PM

IMN logo majestic logo threadwatch logo seochat tools logo