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
