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