Re: a strange problem

[liaojian_163]

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" <lists@stripped>
To: "liaojian_163" <jianliao82@stripped>
Cc: <[e-mail]>
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/mysql?unsub=jianliao82@stripped
>