【mysql】【视图view的使用】
增加
视图是虚拟的数据,默认情况下是保存语句
创建的视图create view st as select * from class where id>2;
select * from st where id<6;就等价于select * from class where id>2 and id<6;
视图是虚拟的数据,默认情况下是保存语句
创建的视图create view st as select * from class where id>2;
select * from st where id<6;就等价于select * from class where id>2 and id<6;