> 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.