Re: Table exists ?

[Jim Faucette]

You can SELECT count(*) FROM tablename. Then check the error message.

  jim...

Derek Lavine wrote:
> 
> Hi,
> 
> I would like to check if a table exists before I do a
> 
> create table mytbl
> ( ... );
> 
> or drop table mytbl;
> 
> would someone be so kind as to tell me how.
> 
> I guess I have to query a mysql table to see if the table i am about  to
> create or drop are in it, but I don't know which table or what column of
> that table
>