Skip navigation links

MySQL Forums :: Data Dictionary & Information Schema :: How to check with SQL if a table exists


Advanced Search

How to check with SQL if a table exists
Posted by: jmf ()
Date: July 12, 2005 07:13AM

Hello,

I have to check if a table whether exists or not because depending on the answer I will have to update a record or insert it.

I tried many things but none worked. How can I do this with MySQL ?

Thanks.

Options: ReplyQuote


Subject Views Written By Posted
How to check with SQL if a table exists 146856 jmf 07/12/2005 07:13AM
Re: How to check with SQL if a table exists 83960 Roland Bouman 07/12/2005 01:53PM
Re: How to check with SQL if a table exists 68255 jmf 07/13/2005 05:57AM
Re: How to check with SQL if a table exists 61239 KimSeong Loh 07/12/2005 06:49PM
Re: How to check with SQL if a table exists 42925 jmf 07/13/2005 05:58AM
Re: How to check with SQL if a table exists 45205 Roland Bouman 07/13/2005 12:22AM
Re: How to check with SQL if a table exists 35736 jmf 07/13/2005 05:59AM
Re: How to check with SQL if a table exists 41242 jmf 07/13/2005 06:33AM
Re: How to check with SQL if a table exists 22042 shan jin 03/17/2009 11:45PM
Re: How to check with SQL if a table exists 41889 Roland Bouman 07/13/2005 06:13AM
Re: How to check with SQL if a table exists 22963 Roland Bouman 07/13/2005 07:02AM
Re: How to check with SQL if a table exists 15981 Roland Bouman 07/13/2005 07:04AM
Re: How to check with SQL if a table exists 19145 jmf 07/13/2005 07:16AM
Re: How to check with SQL if a table exists 15331 mvdkwast 08/19/2005 07:27AM
Re: How to check with SQL if a table exists 13829 Roland Bouman 08/19/2005 07:33AM
Re: How to check with SQL if a table exists 9300 Mike Harris 08/19/2008 03:46AM
Re: How to check with SQL if a table exists 36425 www.phpcontrol.com 08/30/2005 08:48AM
Re: How to check with SQL if a table exists 15229 Bora Turan 10/26/2006 06:13PM
Re: How to check with SQL if a table exists 12301 Kedar Waghmode 01/11/2007 04:35AM
Re: How to check with SQL if a table exists 16554 Tau Lim 06/03/2007 10:57AM
Re: How to check with SQL if a table exists --> Here is a function to use 19952 jeff maass 07/19/2008 05:10PM
Re: How to check with SQL if a table exists --> Here is a function to use 11994 Pratik Asthana 03/19/2009 12:15AM
Re: How to check with SQL if a table exists 12903 Pratik Asthana 03/19/2009 12:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.