📄 8建库存视图storage.sql
字号:
/* 创建视图storage(仓库名,商品号,商品名,库存量,单价,颜色)*/
create view storage(depot_name,goods_id,goods_name,total,goods_p,color)
as
select depot.depot_name,goods_total.gt_gid,goods_name,total,goods_p,goods_color
from goods,depot,goods_total
where goods.goods_id=goods_total.gt_gid and depot.depot_id=goods_total.gt_did
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -