fastest way to check if table exists

[CloudedVision]

whats the fastest way with PHP to check if a MySQL table really exists?

[able]

How about doing: 'describe table_name;' ?

If it exists, you'll get some result.
It's better than doing a select on the table because the select may return 0 results if the table exists but is empty and/or corrupt.

[puzz]

Originally Posted by CloudedVision

whats the fastest way with PHP to check if a MySQL table really exists?

I don't know if it is the fastest way, but I use this SQL:

show tables like 'your_table_name'

if it returns 1 rows => then your table exists.

[Rob]

Originally Posted by puzz

I don't know if it is the fastest way, but I use this SQL:

show tables like 'your_table_name'

if it returns 1 rows => then your table exists.

I think this would be the method I would use.