Answers for "mysql select last 5 rows"

mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

Posted by: Guest on March-04-2020

php sql last 10 rows

SELECT * FROM big_table ORDER BY A DESC LIMIT 10

Posted by: Guest on March-03-2020

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");

Posted by: Guest on August-06-2020

Code answers related to "mysql select last 5 rows"