mysql之视图

视图

虚拟表，通过表动态生成的数据

-- 视图
create or replace view myview1 as

    select last_name,department_name,job_title
from employees e
left join departments d on e.department_id = d.department_id
left join jobs j on e.job_id = j.job_id;


select * from myview1 where last_name like '%a%';