Jens-Peter C. Hillers wrote > >Hello, > >Reading the Documenrtation I found the CREATE SEQUENCE Statement >Looks nice but how can I use it ???? > >I cant use it in Create Table like >bla int NOT NULL SERIAL SEQUENCE wupp > >I use it in an insert or update like >INSERT into TAB (f1, f2) VALUES (1, wupp) > >so what is the use to it ? > >regards >jph > >
The nextval function yields the next sequence value, i.e. INSERT into TAB (f1, f2) VALUES (1, wupp.nextval) should do the job. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
