Hi. On Tue, Oct 09, 2001 at 07:18:53PM +0530, [EMAIL PROTECTED] wrote: > Hi, > > I am developing a application by using MySql database server. I have > requierment in my application, that i need to know/show all the tables > available in all the databases/catalogs of MySql. By using "show tables from > test" i can get tables from "test" database. But I need to know all the > tables from all the databases in a single shot/query. > Please give me solution.
There is no SQL solution for this. But you can simply query in your application all databases with SHOW DATABASES and then loop through the result and query the tables for each of them SHOW TABLES FROM tableX Bye, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php