[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