On Fri, Mar 29, 2002 at 11:38:30PM +0100, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > On Thu, Mar 28, 2002 at 04:30:25PM -0600, BD wrote: > > At 06:20 AM 3/28/2002, you wrote: > > >> > > >> What is the fastest way to check if a table exists? > > >> Do a select and catch the error? > > >> Try to create the table, and catch the error? > > >> Other options? > > What about > > show tables like 'TABLE'; > > If TABLE exists it returns a row, otherwise the empty set. > > -- > René Seindal ([EMAIL PROTECTED]) http://www.seindal.dk/rene/ >
-- René Seindal ([EMAIL PROTECTED]) http://www.seindal.dk/rene/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
