July 10th, 2000, 07:05 PM
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,
July 11th, 2000, 09:46 AM
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...