(Thomas Corell T.Corell@t-online.de):
Ok, I will try to understand what is the extention they made, first look at the function in the mysql docs did not give me a hint. Possibly I miss at midnight the reason why I need to know this number and what extention is handled with it. But currval(seq-name) must be similar.
The MySQL extension is the availability of auto-increment integer fields. They're handy when you need an integer key value that's guaranteed to be unique, but you don't care what it is. Without the extension, you can do that by keeping a "last used ID" filed value in a separate table and updating it every time you insert. But with MySQL, you just go ahead and do the insert, and then ask it "Oh, by the way, what integer value did you just assign to the auto- increment field of the record I just inserted?"
-- Lee Daniel Crocker lee@piclab.com http://www.piclab.com/lee/ "All inventions or works of authorship original to me, herein and past, are placed irrevocably in the public domain, and may be used or modified for any purpose, without permission, attribution, or notification."--LDC