Re: Checking existence of a table.

[Paul DuBois]

At 11:10 -0500 2/17/03, <ed@stripped> wrote:
>What query would I use to check for an existence of a table within a
>database? I'm currently writting a set of scripts in php. Is this possible
>with MySQL or do I need to create a condition within PHP?

You can check the output of SHOW TABLES or you can issue the following
query and see if it produces an error (if so, the table doesn't exist):

SELECT * FROM tbl_name WHERE 0

The WHERE 0 part prevents the query from returning rows if the table
does exist.

>
>Thanks,
>
>Ed
>
>mysql