Re: a strange problem

[Sebastian Mendel]

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