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
