Re: How do I select the last Id in a column???

All,

i got the answer i was needing. I used the following:

select max(id) from table

it works great!! :)

--- Josh Goldberg <josh(at)4dmatrix(dot)com> wrote:
> What could cause a table to act serialized when read
> committed transactions
> are set in the configuration? That is something I
> am running into, which
> provoked my [incorrect] example.
>
> From: "Bruno Wolff III" <bruno(at)wolff(dot)to>
> Sent: Thursday, June 26, 2003 4:30 PM
> > 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.
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
>

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com