mysql select last 5 rows code example

Example 1: mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

Example 2: php sql last 10 rows

SELECT * FROM big_table ORDER BY A DESC LIMIT 10

Example 3: get from database the most recent data limit by 5

$result = mysql_query("SELECT * FROM notes WHERE note_author_id='$u_id' ORDER BY date_time DESC LIMIT 0, 10");