mysql 视图

mysql view

• 添加视图:

create view vw_test04 as select id as id_test from TB_TEST01 where id=1;

• 添加或更新:

create or replace view vw_test05 as select id as id_test from TB_TEST01;

• 只更新:

alter view vw_test05 as select * from TB_TEST01 where id=1;