DEFAULT SERIAL

[Uwe Haussmann]

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/[EMAIL PROTECTED]