Delimiter $$
CREATE PROCEDURE liujiahao (bumen in char (6), the OUT res float (8, 2))
The BEGIN

SELECT ` INTO res ` income FROM salary where ` department staff name `=bumen;
IF bumen=r&d
THEN the SET res=+ res 1000;
END IF;
END $$