[thelist] Free Tip about SQL
Rob Smith
rob.smith at THERMON.com
Fri Jul 18 11:29:59 CDT 2003
<snip>
SELECT MAX(ID) FROM foo ?
</snip>
That would work too. But there is a small gap in time from when you insert
and when you retrieve. Its possible that someone else could insert between
your insert and retrieval calls.
Timestamping with incredulously detailed values was the only fur sure way to
get the absolute record just inserted.
I think there will be some debate over this,
Rob
More information about the thelist
mailing list