建立view的最快方法

到了專案最後的衝刺階段，常有檢經常需要給大家建立view，包含12個類目，一個一個欄位寫會累死的，我用偷懶的方法，呵呵，用adk_price.*搞定

CREATE OR REPLACE VIEW all_adk_price AS
(((((((((( SELECT adk_price.*
FROM bijiben.adk_price
UNION ALL
SELECT adk_price.*
FROM caizhuang.adk_price)
UNION ALL
SELECT adk_price.*
FROM cunchu.adk_price)
UNION ALL
SELECT adk_price.*
FROM dianqi.adk_price)
UNION ALL
SELECT adk_price.*
FROM meirong.adk_price)
UNION ALL
SELECT adk_price.*
FROM mpn.adk_price)
UNION ALL
SELECT adk_price.*
FROM shouji.adk_price)
UNION ALL
SELECT adk_price.*
FROM taishiji.adk_price)
UNION ALL
SELECT adk_price.*
FROM wenju.adk_price)
UNION ALL
SELECT adk_price.*
FROM xiangji.adk_price)
UNION ALL
SELECT adk_price.*
FROM yingjian.adk_price)
UNION ALL
SELECT adk_price.*
FROM yinxiang.adk_price;

[@more@]