基本操作
新增資料
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"