摘要:
1.单表视图create view goods_view as select goodsid,goodsname remark from goods where remark is not null select * from goods_view2.多表视图create view goods_sa_view as select sa.said,g.goodsid,g.goodsname,sa.sa_quantity,g.remark from goods g join sa on g.goodsid = sa.goodsidselect * from goods_sa_view3... 阅读全文