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