From: | "Josh Goldberg" <josh(at)4dmatrix(dot)com> |
---|---|
To: | "Michael Kovalcik" <makd32(at)yahoo(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How do I select the last Id in a column??? |
Date: | 2003-06-26 21:00:33 |
Message-ID: | 01f401c33c25$fbffd5d0$6e02a8c0@4dmatrix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
----- Original Message -----
From: "Michael Kovalcik" <makd32(at)yahoo(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Monday, June 23, 2003 11:47 AM
Subject: [ADMIN] How do I select the last Id in a column???
> Hello,
>
> I'm trying to find out how I select the last id in a
> column if I don't know anything else about the row.
> What i am doing is inserting information into my
> Orders table and the id is auto-incrementing. The
> next thing i want to be able to do is grab the the id
> of the order i just inserted. How do i do this?
>
> Here is the code i have so far:
>
> my $sql = "INSERT INTO ${Orders}
> (locationid,shippingid,statusid,date) VALUES (?
> ,?,?,?)";
>
> my $sth = $dbh->prepare($sql);
>
> $sth->execute(${LocationID},${ShippingID},${StatusID},${date});
> #--*************************************
> my $sth = $dbh->prepare("SELECT id FROM ${Orders}");
>
> $sth->execute();
> $OrderID = $sth->fetchrow_arrayref;
>
> I know the select statement that i have will not work,
> because it will bring me every id number in the table.
> I just want the latest one.....
>
> Please HELP............
>
> Thank you so much,
> Mike
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ericson Smith | 2003-06-26 21:10:04 | Re: How do I select the last Id in a column??? |
Previous Message | Bruno Wolff III | 2003-06-26 20:39:11 | Re: Newbie question |