maxdb@lists.mysql.com
[Top] [All Lists]

Re: DEFAULT SERIAL

Subject: Re: DEFAULT SERIAL
From: "Erik Rehrmann"
Date: Mon, 11 Apr 2005 15:31:25 +0200
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

<Prev in Thread] Current Thread [Next in Thread>
  • Re: DEFAULT SERIAL, Erik Rehrmann <=