mysql视图的创建和使用

mysql视图创建和使用

1. 创建语句
   create view 视图名
   as
   select t1.* from 表名1 t1
   union all
   select t2.* from 表名2 t2
   t1.* 列要和 t2.* 一样
   不然要报错
2. 实际使用

CREATE VIEW vim_v
ASSELECT vm.resoure_id as uuid , vm.ip_address as ipAddress , vm.mac_address as macAddress , vm.user as administrator , vm.user_dept as managerDept , vm.report_source as reportSource from virtual_machine_field vmUNION all SELECT s.ci_no as uuid , s.ip_address as ipAddress , ‘’ as macAddress , s.user as administrator , s.user_dept as managerDept , s.report_source as reportSource from software_field sunion all SELECT cvm.uuid as uuid , cvm.ip_address as ipAddress, cvm.mac_address as macAddress,cvm.user as administrator , CONCAT(cvm.del_flag,cvm.id) as managerDept , cvm.report_source as reportSource from cloud_virtual_machine_field cvm