That should work just fine. :)
Thanks!
----- Original Message -----
From: "John Meyer" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 3:21 PM
Subject: Re: not selecting last row
> At 12:25 PM 7/20/01 -0500, Tyler Longren wrote:
> >Hi everyone,
> >
> >Is there a way to NOT select the last row that was inserted into a table?
I
> >want everything before it.
> >
> >I know how I could do this using 2+ queries, but can it be done by
issuing
> >just 1 query?
> >
> >Thanks everyone,
> >Tyler
>
> Assuming you had a unique ID, couldn't you do it this way:
>
> "SELECT * FROM TABLE WHERE ID=!LAST_INSERT_ID();"
>
>
> John Meyer
> [EMAIL PROTECTED]
> Programmer
>
>
> If we didn't have Microsoft, we'd have to blame ourselves for all of our
> programs crashing
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
