On Thu, Jun 26, 2003 at 14:00:33 -0700,
Josh Goldberg <josh(at)4dmatrix(dot)com> wrote:
> to get the last record inserted just
> select * from row order by autoincId desc limit 1;
>
> if you have several clients doing this you might want to put your insert and
> the select inside a transaction.
That won't help. Your suggestion will only work in serializable transactions.
In read committed mode the select might see a value for autoincId from
a transaction that committed between the insert and the select.