At 12:21 +0000 12/18/02, Jeff Snoxell wrote:
Hi,
I'm adding records to a db using the Perl DBI. Subsequent to adding
a record I need to know the value of the auto-incrementing 'Ref'
field so that I can place a copy of the relavent details into a log
file.
I could query for the "LAST_INSERT_ID" but what if another process
has added another record in the interim?
Doesn't matter.
Is this a job for table locking?
No, it's probably more of a job for reading the section on LAST_INSERT_ID()
in the manual again, particularly the part about "cannot be changed by
another client." :-)
http://www.mysql.com/doc/en/Miscellaneous_functions.html
Many thanks,
Jeff
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php