Thursday, 30 August 2018
Subscribe to:
Post Comments (Atom)
ID). Stripping away all the extraneous stuff, the following works as desired, using the index (primary):EXPLAIN SELECT ID FROM table ORDER BY ID DESC
EXPLAIN SELECT ID, field2 FROM table ORDER BY ID DESC
EXPLAIN SELECT * FROM table ORDER BY ID DESC
EXPLAIN SELECT * FROM table FORCE INDEX (Primary) ORDER BY ID DESC
select * from table order by id desc limit (pageNO-1) * noEntries , noEntries
select * from table order by id desc limit 0, 10
select * from table order by id desc limit 10, 10
Hello Friends! I am Ramana a part time blogger from Hyderabad.
0 comments:
Post a Comment