【Mysql】视图view

视图 虚拟表 也是内存表, 会生成一个frm文件(不推荐使用)

增 CREATE VIEW view_table1 AS select * from t1 inner join t2 on t1.id = t2.id;

删 DROP VIEW view_table1;

改 ALTER VIEW view_table1 key1 int…. 

查 SELECT * FROM view_table1;