good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re: Re: Issue with simultaneous MySQL actionsby LanceDeeply (Chaplain) |
on Jul 31, 2003 at 22:32 UTC ( [id://279814]=note: print w/replies, xml ) | Need Help?? |
you should consider storing an agent's max id in another table. ( the following is MS-SQL compliant.. your flavor may require something slightly different ) you can quickly create this table like so: and then, before running your insert, run a transactioned query to get and set the max id of an agent this should ensure you have no ID collissions HTH! Update: I just read the auto-incremental part of your post... which pretty much squashes this reply. shame on me.
In Section
Seekers of Perl Wisdom
|
|