September 7th, 1999, 03:45 AM
I am trying to figure out a way to write a query that would select the last ten files that have been created in a table. The table has a Primary Key (just an auto_increment integer). The table also has a column containing the timestamp of each file also.
Also I would like to be able to use a limit function such as LIMIT 5,10 (and variations of this), while I assume this would be the same as any other select I figured I should include it just in case that would change the parameters of the query.
new media arts
September 9th, 1999, 12:57 AM
SELECT * FROM mytable ORDER BY date_column DESC LIMIT 10;