List:General Discussion« Previous MessageNext Message »
From:Keith Ivey Date:October 6 2005 4:31pm
Subject:Re: Detect if table exists from within MySQL?
View as plain text  
Ryan Stille wrote:

> If I have to, I could resort to doing another query in my application
> (SHOW TABLES) and seeing if my table was returned in that list.  But I
> was hoping for a more elegant way to do it, within the single query.

Maybe you could use

    SHOW TABLES LIKE 'your_table';

-- 
Keith Ivey <keith@stripped>
Smokefree DC
http://www.smokefreedc.org
Washington, DC
Thread
• Detect if table exists from within MySQL?Ryan Stille6 Oct
  • Re: Detect if table exists from within MySQL?Peter Brawley6 Oct
  • A question about stored proceduresLeonardo Javier Belén6 Oct
    • Re: A question about stored proceduresGleb Paharenko7 Oct
  • Re: Detect if table exists from within MySQL?Jeff Smelser6 Oct
• RE: Detect if table exists from within MySQL?Ryan Stille6 Oct
  • Re: Detect if table exists from within MySQL?Keith Ivey6 Oct
• RE: A question about stored proceduresSujay Koduri6 Oct
• RE: Detect if table exists from within MySQL?Ryan Stille6 Oct