List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:October 6 1999 11:25am
Subject:Re: TABLE EXISTS
View as plain text  
toxalot@stripped writes:
 > I see in the handbook that there is a way to see that a table exists before
 > dropping it, but how do you check if one exists before trying to create it?
 > 
 > Jennifer
 > 
 > 
 > 

Hi!

IF EXISTS works with DROP and CREATE, with a later being rather
recent.

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
TABLE EXISTStoxalot6 Oct
  • Re: TABLE EXISTSsinisa6 Oct
  • Re: TABLE EXISTSCarsten H. Pedersen6 Oct
    • Re: TABLE EXISTSPaul DuBois6 Oct
      • Re: TABLE EXISTStoxalot7 Oct