List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 10 2000 6:30pm
Subject:Re: Problems with a number of SQL commands ("IF NOT EXISTS" and
more)
View as plain text  
At 6:47 PM +0100 04-10-2000, Max wrote:
>Hello,
>
>>  > I have problems with a number of SQL statements which are supposed to work
>>  > (at the least that is what I think) but produce an error.
>>
>>  > - I use this binary distribution :
>>  > mysql-3.22.30-sun-solaris2.7-sparc
>>
>>You're probably trying to use features which are only in 3.23.xx. For
>>instance, if you read the section in the manual on the syntax for CREATE
>>TABLE, you should see:
>>
>>    In MySQL 3.23 or later, you can use the keywords IF NOT EXISTS so that
>>    an error does not occur if the table already exists. Note that there
>>    is no verification that the table structures are identical.
>
>Okay, I admit the "IF NOT EXISTS" and "TEMPORARY" feature does not 
>exist in 3.22.xx. Sorry for not reading the manual more thoroughly.
>
>However I didn't find any remarks in the manual which say that
>         "COUNT (DISTINCT <colname>)"
>or
>         "CREATE TABLE <tablename> SELECT * FROM <othertablename>"
>wouldn't work in 3.22.

The remarks you're looking for are the change notes for 3.23 which 
indicate when those
features were added.



-- 
Paul DuBois, paul@stripped
Thread
Problems with a number of SQL commands ("IF NOT EXISTS" andmore)Max9 Apr
  • Re: Problems with a number of SQL commands ("IF NOT EXISTS" and more)Jonathan Stimmel9 Apr
Re: Problems with a number of SQL commands ("IF NOT EXISTS"and more)Max10 Apr
  • Re: Problems with a number of SQL commands ("IF NOT EXISTS"and more)sinisa10 Apr
  • Re: Problems with a number of SQL commands ("IF NOT EXISTS" andmore)Paul DuBois10 Apr