到了项目最后的冲刺阶段，常有检经常需要给大家创建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@]