List:General Discussion« Previous MessageNext Message »
From:Ed Carp Date:October 21 2002 4:50pm
Subject:RE: SHOW question
View as plain text  
> 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 ?

Depending on the release of MySQL (3.x, haven't tried it on 4.x yet), it
will return the table names in a field called "Tables in XX" or
"Tables_in_XX", where XX is the database name.

> 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) ?

Yes.

Thread
SHOW questionFabio Checconi21 Oct
  • RE: SHOW questionEd Carp21 Oct
  • Re: SHOW questionInsanely Great21 Oct
  • Re: SHOW questionPaul DuBois22 Oct