Re: a strange problem

2008-04-23 Thread 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 [EMAIL PROTECTED] To: liaojian_163 [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, April 23

a strange problem

2008-04-22 Thread liaojian_163
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|

Re: a strange problem

2008-04-22 Thread liaojian_163
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