ansaurus

Question

Answer 1

+4 A:

select * from tableName ORDER BY `created_at` DESC LIMIT 10

Salil 2010-07-06 05:19:44

how can i retrieve through user id

Hari kanna 2010-07-06 05:22:04

I guess you want something like select * from tableName where user_id=10 ORDER BY `created_at` DESC LIMIT 10

Salil 2010-07-06 05:33:12

Answer 2

+1 A:

MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 11.13 ...

ratty 2010-07-06 05:20:36

Answer 3

+1 A:

Hi you can use the below query, please ensure about the primary-key field

select * from tbl ORDER BY 'ID' DESC LIMIT 10

VAC-Prabhu 2010-07-06 05:29:53

Retrieve last inserted 10 rows in table