Hi The mySQL documentation for LAST_INSERT_ID says that it returns the last auto-incremented field value for 'that client'.
I am not sure what the client is in a mod_perl situation with Apache::DBI? I have an Apache child process which uses one open database connection for its lifetime. If 2 page requests use the same child process and thus the same database connection does the mySQL server not see this as the same client? If so - this seems to suggest that I can't rely on LAST_INSERT_ID ... Unless (and I don't understand much about Apache) each the process is used to serve one request completely and then the next. If this is the case then it seems that LAST_INSERT_ID would be reliable. I hope that makes some kind of sense and thanks for any help Justin Wyllie
