Greetings... In the "show tables"....if there is no database selected in the Server...it will give an error that no database is selected.
In the second query...it will always return a resultset....maybe an empty resultset if there are no fields in the table. hope it helps. Insane SQLyog - The Definitive Win32 GUI for MySQL http://www.sqlyog.com ----- Original Message ----- From: "Fabio Checconi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 8:36 PM Subject: SHOW question > > I'm writing a program using the C API. When I do a query "SHOW TABLES" am > I sure that on every installation it will return a result set of one > column containing the tables name, or there are systems where that's not > true ? > Am I sure that from a "SHOW FIELDS FROM table" i'll get a result set with > the column name in the first field and the type in the second (with other > info on other fields) ? > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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