On 24-Jan-01 Jesús Gómez Pastor wrote:
> I have a problem in 3.23.32,
> The query
>
>   select * from table
>   repalce table values('','nextval+1)

    ^^^^^^                  ^ 
these might be a problem, in addition to your select/replace/(update)
confusion.

>
> returns me always nextval=1.

no, it return a syntax error.

>
> table has 1 row and the query runs fine in mysql 3.22.x

I doubt it.

How about a cut & paste of the table definition, and a short
description of what you think you are trying to do ?


Regards,
-- 
Don Read                                         [EMAIL PROTECTED]
-- If you are going to sin, sin against God, not the bureaucracy. 
                  God will forgive you but the bureaucrats won't. 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to