Re: IF EXISTS

[Jim Faucette]

toxalot@stripped wrote:
> 
> The shared version of MySQL that I have with my host is only version
> 3.21.33b.
> 
> DROP TABLE IF EXISTS doesn't exist with that version.
> 
> What can I use to check whether or not a tbl exists before I drop it?

You can do a simple select and if it returns an error then the table
does not exist:
SELECT * FROM table LIMIT 1;

  jim...