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