thank you Sebastian! I have re-created the table.there are not any problems in the table.
if the table is new,need to rebuild de indexes? ----- Original Message ----- From: "Sebastian Mendel" <[EMAIL PROTECTED]> To: "liaojian_163" <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Wednesday, April 23, 2008 2:11 PM Subject: Re: a strange problem > 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] >
