Re: update auto increment

2003-01-09 Thread Christian Kohlschütter
Am Donnerstag, 9. Januar 2003 15:28 schrieb Csongor Fagyal: > Hi, > > Sorry if this had been asked on this list previously. > > If you had an auto_increment field in a table (let's name it "id"), > previously (in 3.23.x, 4.0.x) the following (legal) SQL statement > resulted in a "duplicate key" err

Re: update auto increment

2003-01-09 Thread Paul DuBois
At 15:28 +0100 1/9/03, Csongor Fagyal wrote: Hi, Sorry if this had been asked on this list previously. If you had an auto_increment field in a table (let's name it "id"), previously (in 3.23.x, 4.0.x) the following (legal) SQL statement resulted in a "duplicate key" error: UPDATE whatevertable

update auto increment

2003-01-09 Thread Csongor Fagyal
Hi, Sorry if this had been asked on this list previously. If you had an auto_increment field in a table (let's name it "id"), previously (in 3.23.x, 4.0.x) the following (legal) SQL statement resulted in a "duplicate key" error: UPDATE whatevertable SET id = id +1; Will this be fixed in 4.1.x?