mysql的默许排序规则探讨
程序员文章站
2022-05-11 11:49:00
...
mysql的默认排序规则探讨 3个SQL语句的不同结果（注意sid的值）： ? mysql? select ? sid,order_no,order_status? from ? oms_order???limit?10; + -----+----------------+--------------+ |?sid?|?order_no???????|?order_status?| + -----+---------------
mysql的默认排序规则探讨
3个SQL语句的不同结果（注意sid的值）：
?
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)
?
排序规则：
? ? 以上信息整理与互联网，笔者本人还没完全搞懂，大家可以探讨！
?
上一篇： MySQL Innodb表导致死锁日志情况分析与归纳
下一篇： 字符串分割成数组