Re: a strange problem

[Phil]

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 <jianliao82@stripped>:

> 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 !