1)视图
创建视图
1.mysql 中点击视图->创建视图->写SQL语句 -> 保存
2.或者直接写SQL
CREATE VIEW <视图名> AS <SELECT语句>
实例:
CREATE
VIEW `NewView`AS
SELECT condition_type,product_name FROM `py_etl_product_bank_financial_gather`
UNION
SELECT py_private_id as condition_type,full_name as product_name FROM `py_etl_private_fund_base_info_2_1`