get last 10 records in mysql code example

Example: mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;