|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...
|• IF EXISTS||toxalot||9 Nov|
|• Re: IF EXISTS||Jim Faucette||9 Nov|
|• RE: IF EXISTS||Exchange)||9 Nov|