基本操作

新增資料

INSERT INTO RoutingSheet_Head (Routing_ItemNo ,RoutingNo, RoutingName)

VALUES ("D021GD08D100BZZAQFX", "D021", "裸成品")

查詢資料

SELECT * FROM RoutingSheet_Head

修改資料

UPDATE RoutingSheet_Head SET RoutingName = "組合品"

WHERE Routing_ItemNo = "D021GD08D100BZZAQFX"

刪除資料

DELETE FROM RoutingSheet_Head WHERE Routing_ItemNo = "D021GD08D100BZZAQFX"