[thelist] Doh! question for MySQL
walker
walker at sdproductions.com
Tue Feb 13 21:00:47 CST 2001
Hello out there...
I'm looking for a little sql syntax on mysql.
I need a way to select the last 10inserts into a db table. I know this is
probably simple, but I can't seem to get it.
I was thinking about doing this:
select count(orderitemid) as oidcount from orderitem;
then set a new variable (oidmin) to the result of the previous query - 10
select * from orderitem limit oidmin,10;
seems like there might be a cleaner way to do this. Any suggestions?
thanks
-w
_________________________________________
walker fenton
walker at sdproductions.com
303.722.5473
More information about the thelist
mailing list