Easiest way to tell if a table already exists?

[Mark Riehl]

All,

What's the easiest way to check and see if a table already exists in a
database?  I'm running MySQL on a Win2k box.

The New Riders MySQL book has the following statements:
SELECT COUNT(*) FROM table_name
SELECT * FROM table_name WHERE 1=0

Each statement will succeed if the table exists.

Any other way (other than calling $dbh->tables() and looping through the
results?

Thanks,
Mark


--
Mark Riehl
Agile Communications, Inc.
Email: [EMAIL PROTECTED]