|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 10th, 2000, 06: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, adriana URL
|
|
#2
July 11th, 2000, 08: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...
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > How can I get information about all tables in all databases? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
