求助 mysql排序出问题了
- SQL code
sql语句select * from dm_sell where 1=1 and sell_user_id='9' and sell_time = '1323273600' order by sell_id desc limit 180,60
竟然是重高到底排序
36900
36901
36902
- SQL code
改了下limit0,60select * from dm_sell where 1=1 and sell_user_id='9' and sell_time = '1323273600' order by sell_id desc limit 0,60
排序又正常了
38459
38458
38457
这是神马情况啊 , 急的象蚂蚁 求教
[解决办法]
check table dm_sell ; 看看索引文件的情况。