On Thu, Jun 26, 2003 at 14:00:33 -0700, Josh Goldberg <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
