查询不同字段的3个SQL语句及对应的结果:
mysql>
select
sid,order_no,order_status
from
oms_order limit 10;
+
-----+----------------+--------------+
| sid | order_no | order_status |
+
-----+----------------+--------------+
| 20 | 20100319000003 | 0 |
| 21 | 20100319000004 | 0 |
| 63 | 20100319000046 | -1 |
| 69 | 20100320000006 | 0 |
| 76 | 20100323000001 | 0 |
| 77 | 20100323000002 | 0 |
| 78 | 20100323000003 | 0 |
| 79 | 20100323000004 | 8 |
| 86 | 20100324000007 | -1 |
| 93 | 20100324000014 | -1 |
+
-----+----------------+--------------+
10
rows
in
set
(0.00 sec)
mysql>
select
sid,order_status
from
oms_order limit 10;
+
-----+--------------+
| sid | order_status |
+
-----+--------------+
| 240 | -1 |
| 261 | -1 |
| 263 | -1 |
| 285 | -1 |
| 286 | -1 |
| 288 | -1 |
| 339 | -1 |
| 383 | -1 |
| 387 | -1 |
| 452 | -1 |
+
-----+--------------+
10
rows
in
set
(0.00 sec)
mysql>
select
sid
from
oms_order limit 10;
+
---------+
| sid |
+
---------+
| 1171641 |
| 1171651 |
| 1171661 |
| 1171671 |
| 1171681 |
| 1171691 |
| 1171701 |
| 20 |
| 21 |
| 63 |
+
---------+
10
rows
in
set
(0.00 sec)
排序规则:
以上信息整理与互联网,笔者本人还没完全搞懂,大家可以探讨!