RE: Query problem in mysql.3.23.32

2001-01-24 Thread jgomez
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)

RE: Query problem in mysql.3.23.32

2001-01-24 Thread Don Read
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