I am suspecting that serial in MySQL works like serial in PostgreSQL in which
a sequence is automatically created. If so, you should be able to query the
last_value field in the sequence without having to call the function. The
name might be different in MySQL, I don't know. This will give you the last
value inserted and if you need the next just add 1.
Also, if it is an auto increment column and again if it is like PostgreSQL
then all you have to do is use the word 'default' without quotes and it "auto
increments" the value for the new insert. See if there is a default for your
On Thursday 11 June 2009 08:36:21 Merav Ben-David wrote:
> I am working with zope & mysql.
> I have a table with SERIAL column type, I create "z-sql method" for insert
> operation, how can I get the value for the auto increment column?
> I know that in mysql I can call last_insert_id(), how do I call it, should
> I create another "z sql method" and if I do, how can I be sure the the
> value return is for my insert command and not for another. Is there a way
> to call 2 query from the same "z sql method"?
> I am really lost on this, any help will be wellcom.
> Thank in advanced.
Normally I'm against big things,
I think the world is going to be saved by millions of small things.
Too many things can go wrong when they get big.
- Pete Seeger at his 90th birthday party Sunday May 3, 2009
Thomas McMillan Grant Bennett Appalachian State University
Operations & Systems Analyst P O Box 32026
University Library Boone, North Carolina 28608
(828) 262 6587
Library Systems Help Desk: https://www.library.appstate.edu/help/
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -