Description:
mysql> desc photo_category_user14;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| uid | int(11) unsigned | NO | PRI | | |
| categoryid | int(11) unsigned | NO | PRI | | |
| amount | int(11) | YES | | 0 | |
| picurl | varchar(128) | YES | | | |
| password | varchar(20) | YES | | | |
| level | int(2) | YES | | 0 | |
| createtime | datetime | YES | | | |
| updatetime | datetime | YES | | | |
+------------+------------------+------+-----+---------+-------+
"select * from photo_category_user14 where uid=34957710 order by createtime desc;" result of query is null
but "select * from photo_category_user14 where uid=34957710 order by createtime asc;" it is ok
mysql> desc photo_category_user14;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| uid | int(11) unsigned | NO | PRI | | |
| categoryid | int(11) unsigned | NO | PRI | | |
| amount | int(11) | YES | | 0 | |
| picurl | varchar(128) | YES | | | |
| password | varchar(20) | YES | | | |
| level | int(2) | YES | | 0 | |
| createtime | datetime | NO | | | |
| updatetime | datetime | NO | | | |
+------------+------------------+------+-----+---------+-------+
"select * from photo_category_user14 where uid=34957710 order by createtime desc;" it is ok
but "select * from photo_category_user14 where uid=34957710 order by createtime asc;" it is ok
why ??
sorry,my english is not ok
How to repeat:
ysql> desc photo_category_user14;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| uid | int(11) unsigned | NO | PRI | | |
| categoryid | int(11) unsigned | NO | PRI | | |
| amount | int(11) | YES | | 0 | |
| picurl | varchar(128) | YES | | | |
| password | varchar(20) | YES | | | |
| level | int(2) | YES | | 0 | |
| createtime | datetime | YES | | | |
| updatetime | datetime | YES | | | |
+------------+------------------+------+-----+---------+-------+
"select * from photo_category_user14 where uid=34957710 order by createtime desc;" result of query is null
but "select * from photo_category_user14 where uid=34957710 order by createtime asc;" it is ok
mysql> desc photo_category_user14;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| uid | int(11) unsigned | NO | PRI | | |
| categoryid | int(11) unsigned | NO | PRI | | |
| amount | int(11) | YES | | 0 | |
| picurl | varchar(128) | YES | | | |
| password | varchar(20) | YES | | | |
| level | int(2) | YES | | 0 | |
| createtime | datetime | NO | | | |
| updatetime | datetime | NO | | | |
+------------+------------------+------+-----+---------+-------+
"select * from photo_category_user14 where uid=34957710 order by createtime desc;" it is ok
but "select * from photo_category_user14 where uid=34957710 order by createtime asc;" it is ok
why ??
sorry,my english is not ok