Select last rows from MySQL table.
Moderator: General Moderators
Select last rows from MySQL table.
How to select the last rows having a primary key that is auto incremented, how to select only the last x amount of records that were inserted into the table for example.
Re: Select last rows from MySQL table.
Code: Select all
SELECT foo FROM table_name ORDER BY id DESC LIMIT 10