liaojian_163 schrieb:
> 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?
no
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
ednesday, 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_e
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;
> +--+-
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
>
Not knowing your msqyl version, perhaps it's the form of your LIMIT clause.
try LIMIT 0,10 instead.
Phil
2008/4/22 liaojian_163 <[EMAIL PROTECTED]>:
> hi,all.
> In my mysql server,I have a strange problem.
> can someone help me?
> Thank you.
>
> mysql>
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 | ne
