liaojian_163 schrieb: > hi,all. > In my mysql server,I have a strange problem. > can someone help me? > Thank you. > > mysql> select id,classid,newstime from phome_ecms_zhichang where classid=41 > and id >2500 order by id desc limit 10; > +------+---------+---------------------+ > | id | classid | newstime | > +------+---------+---------------------+ > | 2543 | 41 | 2008-04-22 21:55:22 | > [...] > 10 rows in set (0.00 sec) > > mysql> select id,classid,newstime from phome_ecms_zhichang where classid=41 > order by id desc limit 10; > +------+---------+---------------------+ > | id | classid | newstime | > +------+---------+---------------------+ > | 2540 | 41 | 2008-04-19 12:29:30 | > [...] > > > mysql> select id,classid,newstime from phome_ecms_zhichang where classid=41 > and id >0 order by id desc limit 10; > Empty set (0.00 sec)
did you tried to repair the table and/or rebuild the indexes? -- Sebastian Mendel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]