Hi all, I have a table that includes an auto_increment field.
This is used to build up an audit trail of the passage of a file through my server. As a file is received from a remote system I create the first entry for that file in the audit trail table. I build up an sql INSERT command (I'm updating the table using Perl and DBI) using information about the file - it's name, the IP address of the sending machine and so on. What I want to do is immediately retrieve or otherwise have returned to my perl program the value of the auto increment field for the newly added row. It is possible (indeed likely) that multiple processes might be updating the table at the same time. Thanks Bob --------------------------------------------------------------------- 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
