On Wed, 9 Oct 2002, Brian Reichert wrote: > On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote: > > Hi all, > > There is a way to know if I have table x in my db? > > Let's say some catalog tables that hold information about the db like tables > > name etc. > > and i can do query like "select tables from catalogName" and get all the > > tables in the db > > 'show tables'
But can you do a SELECT on the result set from that statement? Please let me know if it's possible. Iikka ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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