Re: DEFAULT SERIAL

["Erik Rehrmann"]

Hi,

this definitively does not work for us!

DROP DEFAULT
ADD DEFAULT SERIAL(1000)
INSERT RECORD
CURRVAL=9 (highest value in column=862)

:-(

MaxDB (7.5.00.18 on Linux, Tests via SQLStudio 7.5.00.03)

Any help is greatly appreciated

Erik


 >One can easily change the serial start value  by altering the default
 >serial(xx) to the desired  start value:
 >
 >
 >ALTER TABLE ownername.tablename COLUMN "columnname" DROP DEFAULT
 >
 >//
 >
 >ALTER TABLE ownername.tablename COLUMN "columnname" ADD DEFAULT  
SERIAL(220)
 >
 >//
 >
 >Replace 220 with your record count + 1
 >
 >Greetings
 >UH

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mailarch@xxxxxxx