mysql 创建视图view

create view location
as
select
  `call`.id as id,
  `city`.value as city,
  `region`.value as region,
  `others`.value as others
from `call`
left join `city` on (`call`.city=`city`.id)
left join `region` on (`call`.region=`region`.id)
left join `others` on (`call`.others=`others`.id)