看板 Mesak
作者 標題 [SQL] 大小寫 DISTINCT 多個表合併
時間 2015年01月09日 Fri. AM 11:54:34
utf8 TABLE
SELECT DISTINCT maker COLLATE utf8_bin as maker FROM da_truck as da_truck
多個表合併
SELECT DISTINCT t.maker FROM(
SELECT DISTINCT maker COLLATE utf8_bin as maker FROM da_truck as da_truck
union
SELECT DISTINCT maker COLLATE utf8_bin as maker FROM do_truck as do_truck
) as t ORDER BY maker
SELECT DISTINCT maker COLLATE utf8_bin as maker FROM da_truck as da_truck
union
SELECT DISTINCT maker COLLATE utf8_bin as maker FROM do_truck as do_truck
) as t ORDER BY maker
--
※ 作者: mesak 時間: 2015-01-09 11:54:34
※ 編輯: mesak 時間: 2015-01-28 11:27:04
※ 看板: Mesak 文章推薦值: 0 目前人氣: 0 累積人氣: 125
回列表(←)
分享