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:
Sent: W
I don't think that the limit cause the stange problem.
thank you anyway.
- Original Message -
From: "Phil" <[EMAIL PROTECTED]>
To: "liaojian_163" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
>
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|
+--+
