目录
1.创建视图
语法:create view 视图名 as select * from 表名;
2.使用视图
语法:select * from 视图名;
3.查看视图字段信息
语法:desc 视图名;
4.查看视图创建语句
语法:show create view 视图名\G;
5.删除视图
语法:drop view 视图名;
目录
语法:create view 视图名 as select * from 表名;
语法:select * from 视图名;
语法:desc 视图名;
语法:show create view 视图名\G;
语法:drop view 视图名;