List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:November 9 1999 4:18pm
Subject:Re: IF EXISTS
View as plain text  
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...
Thread
IF EXISTStoxalot9 Nov
  • Re: IF EXISTSJim Faucette9 Nov
RE: IF EXISTSExchange)9 Nov