Thanks for all the replies. I've got a hnadle on it now. Ed
On Mon, 17 Feb 2003, Paul DuBois wrote: > At 11:10 -0500 2/17/03, <[EMAIL PROTECTED]> wrote: > >What query would I use to check for an existence of a table within a > >database? I'm currently writting a set of scripts in php. Is this possible > >with MySQL or do I need to create a condition within PHP? > > You can check the output of SHOW TABLES or you can issue the following > query and see if it produces an error (if so, the table doesn't exist): > > SELECT * FROM tbl_name WHERE 0 > > The WHERE 0 part prevents the query from returning rows if the table > does exist. > > > > >Thanks, > > > >Ed > > > >mysql > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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