【mysql】MySQL操作视图的常用语句
创建视图
create view view_name_abc as select * from t_user;
查询所有的视图
show tables;
查询视图中的数据
select * from view_name_abc;
更新视图的基表信息
update view_name_abc set name = 'zhangsan' where id = '1';
删除视图
drop view if exists view_name_abc;
查询出创建视图的语句
show create view view_name_abc;