delimiter $$
CREATE PROCEDURE liujiahao(in bumen char(6),OUT res float(8,2))
BEGIN
SELECT `收入` INTO res FROM salary where `員工部名稱`=bumen;
IF bumen=研發部
THEN SET res=res+1000;
END IF;
END $$
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/284720.html
標籤:應用實例
上一篇:存盤程序生成流水號