[請益] my sql 排序方式
我用 SELECT 來撈 mysql 的資料
用 ORDER BY date DESC 來做排序
於是撈出來的資料,都會以時間比較早的為開始。
例如 :
2011-01-01 00:00:10
2011-01-01 00:00:20
2011-01-01 00:00:30
請問要用甚麼方式,才能讓時間比較晚的當成一開始呢 ? ?
例如 :
2011-01-01 00:00:30
2011-01-01 00:00:20
2011-01-01 00:00:10
再請老手指導一下,謝謝各位。
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 180.217.187.177
※ 文章網址: https://www.ptt.cc/bbs/PHP/M.1500360668.A.1C5.html
※ 編輯: move5566 (180.217.187.177), 07/18/2017 14:53:17
→
07/18 14:59, , 1F
07/18 14:59, 1F
→
07/18 16:13, , 2F
07/18 16:13, 2F
→
07/18 16:18, , 3F
07/18 16:18, 3F
→
07/18 17:05, , 4F
07/18 17:05, 4F
→
07/18 17:06, , 5F
07/18 17:06, 5F
→
07/18 17:08, , 6F
07/18 17:08, 6F
→
07/18 17:09, , 7F
07/18 17:09, 7F
→
07/18 17:09, , 8F
07/18 17:09, 8F
→
07/18 20:48, , 9F
07/18 20:48, 9F
→
07/18 21:55, , 10F
07/18 21:55, 10F
→
07/19 08:47, , 11F
07/19 08:47, 11F
推
07/19 09:51, , 12F
07/19 09:51, 12F
推
07/30 08:46, , 13F
07/30 08:46, 13F
→
07/30 11:21, , 14F
07/30 11:21, 14F