OK,here goes more information about my problem:
I have a table with the next structure:
flag char(1)
nextval bigint(20) unsigned autoincrement
The query i execute with no problems in mysql 3.22 is:
select * from table;
REPLACE INTO table values (\'\',nextval+1)
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.
n
I have a problem in 3.23.32,
The query
select * from table
repalce table values('','nextval+1)
returns me always nextval=1.
table has 1 row and the query runs fine in mysql 3.22.x
Any idea?
Thanks.
