建 view 语句如下:
CREATE VIEW data_model.`vw_ads_table` AS
select a.*
from `ads`.`table` a
show create view 展示如下:
CREATE VIEW `vw_ads_table` AS
select
`internal`.`ads`.`a`.`TICKET_ID`,
`internal`.`ads`.`a`.`TICKET_CHANGE_TS`,
`internal`.`ads`.`a`.`TICKET_CREATE_TS`,
`internal`.`ads`.`a`.`TICKET_EDITOR`,
`internal`.`ads`.`a`.`TICKET_DESC`
from `internal`.`ads`.`table` `a`;
在字段名里面 internal
.ads
. 后面会多一个 .a 这个逻辑应该有点问题