SQL视图

[AlfieriChou]

• 创建视图

CREATE VIEW test_view AS 
select
    `a`.*,
    `b`.*
from
    `a`
left join
    `b` on a.id = b.id

• 查询视图

show create view test_view;

• 查询所有的视图

select * FROM information_schema.views