?? 建庫存視圖storage.sql
字號:
/* 創(chuàng)建視圖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 + -