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
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|
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: mysql@lists.mysql.com
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
Not knowing your msqyl version