Fast way to determine if a table exists ... using the C API

[Michael Widenius]

>>>>> "Vasanthan" == Vasanthan Gunaratnam <vasg@stripped>
> writes:

Vasanthan> I am trying to use the C API to determine if a table exists in the
Vasanthan> database and I know of two ways to do this:
Vasanthan>     1) Use mysql_list_tables() and then go through the list of tables to
Vasanthan> determine if the table exists.
Vasanthan>     or
Vasanthan>     2) Use the SQL statement 'SHOW TALBES LIKE "tableName"' and check if
Vasanthan> the result has a match.

Vasanthan> Unfortunately, both ways are relatively slow. I would appreciate it if
Vasanthan> someone could tell me of a faster way to accoplish the above.

Vasanthan> Thanks in advance,

Hi!

SELECT count(*) from tablename is fast!

Regards,
Monty