Re: a strange problem

[liaojian_163]

I don't think that the limit cause the stange problem.

thank you anyway.
----- Original Message ----- 
From: "Phil" <freedc.bok@stripped>
To: "liaojian_163" <jianliao82@stripped>
Cc: <mysql@stripped>
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 <[e-mail]>:
> 
>> 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 |
>> | 2540 |      41 | 2008-04-19 12:29:30 |
>> | 2537 |      41 | 2008-04-18 17:38:50 |
>> | 2536 |      41 | 2008-04-18 17:37:56 |
>> | 2534 |      41 | 2008-04-18 12:22:24 |
>> | 2533 |      41 | 2008-04-18 01:19:49 |
>> | 2532 |      41 | 2008-04-18 01:18:42 |
>> | 2527 |      41 | 2008-04-16 18:45:34 |
>> | 2526 |      41 | 2008-04-16 18:43:03 |
>> | 2523 |      41 | 2008-04-16 08:47:16 |
>> +------+---------+---------------------+
>> 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 |
>> | 2537 |      41 | 2008-04-18 17:38:50 |
>> | 2536 |      41 | 2008-04-18 17:37:56 |
>> | 2534 |      41 | 2008-04-18 12:22:24 |
>> | 2533 |      41 | 2008-04-18 01:19:49 |
>> | 2532 |      41 | 2008-04-18 01:18:42 |
>> | 2527 |      41 | 2008-04-16 18:45:34 |
>> | 2526 |      41 | 2008-04-16 18:43:03 |
>> | 2523 |      41 | 2008-04-16 08:47:16 |
>> | 2522 |      41 | 2008-04-15 15:34:55 |
>> +------+---------+---------------------+
>>
>>
>> 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)
>>
>>
>> desc  phome_ecms_zhichang;
>>
>> +-------------+--------------+------+-----+---------------------+----------------+
>> | Field       | Type         | Null | Key | Default             | Extra
>>        |
>>
>> +-------------+--------------+------+-----+---------------------+----------------+
>> | id          | int(11)      | NO   | PRI | NULL                |
>> auto_increment |
>> | classid     | smallint(6)  | NO   | MUL | 0                   |
>>        |
>> | onclick     | int(11)      | NO   |     | 0                   |
>>        |
>> | newspath    | varchar(50)  | NO   |     |                     |
>>        |
>> | keyboard    | varchar(255) | NO   |     |                     |
>>        |
>> | keyid       | varchar(255) | NO   |     |                     |
>>        |
>> | userid      | int(11)      | NO   |     | 0                   |
>>        |
>> | username    | varchar(30)  | NO   |     |                     |
>>        |
>> | ztid        | varchar(255) | NO   |     |                     |
>>        |
>> | checked     | tinyint(1)   | NO   | MUL | 0                   |
>>        |
>> | istop       | tinyint(4)   | NO   |     | 0                   |
>>        |
>> | truetime    | int(11)      | NO   | MUL | 0                   |
>>        |
>> | ismember    | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | dokey       | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | userfen     | int(11)      | NO   |     | 0                   |
>>        |
>> | isgood      | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | titlefont   | varchar(50)  | NO   |     |                     |
>>        |
>> | titleurl    | varchar(200) | NO   |     |                     |
>>        |
>> | filename    | varchar(60)  | NO   |     |                     |
>>        |
>> | filenameqz  | varchar(28)  | NO   |     |                     |
>>        |
>> | fh          | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | groupid     | smallint(6)  | NO   |     | 0                   |
>>        |
>> | newstempid  | smallint(6)  | NO   |     | 0                   |
>>        |
>> | plnum       | int(11)      | NO   |     | 0                   |
>>        |
>> | firsttitle  | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | isqf        | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | totaldown   | int(11)      | NO   |     | 0                   |
>>        |
>> | title       | varchar(200) | NO   |     |                     |
>>        |
>> | newstime    | datetime     | NO   | MUL | 0000-00-00 00:00:00 |
>>        |
>> | titlepic    | varchar(200) | NO   |     |                     |
>>        |
>> | closepl     | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | havehtml    | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | lastdotime  | int(11)      | NO   |     | 0                   |
>>        |
>> | haveaddfen  | tinyint(1)   | NO   |     | 0                   |
>>        |
>> | infopfen    | int(11)      | NO   |     | 0                   |
>>        |
>> | infopfennum | int(11)      | NO   |     | 0                   |
>>        |
>> | votenum     | int(11)      | NO   |     | 0                   |
>>        |
>> | ftitle      | varchar(200) | NO   |     |                     |
>>        |
>> | smalltext   | text         | NO   |     | NULL                |
>>        |
>> | writer      | varchar(30)  | NO   |     |                     |
>>        |
>> | befrom      | varchar(60)  | NO   |     |                     |
>>        |
>> | newstext    | mediumtext   | NO   |     | NULL                |
>>        |
>>
>> +-------------+--------------+------+-----+---------------------+----------------+
>>
> 
> 
> 
> -- 
> Help build our city at http://free-dc.myminicity.com !
>