MySQL视角创建视图:语法为:create view视图名as tselect语句….;查看视图: select * from视图名删除视图: drop view视图名;