At 6:47 PM +0100 04-10-2000, Max wrote:
>> > 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>)"
> "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