Stored Procedure com if

Question

I have a table with the fields name, id and salary.

I need a trial that changes the employee’s salary, if she receives one, should increase the salary by 300 reais, in case another value decreases the salary by 500 reais.

You know how it can be done?

Answer 1

Imagine that the resolution is something along these lines:

DELIMITER $$

CREATE PROCEDURE AumentarSalario(IN quantidade INT, codigoFuncionario INT)
BEGIN
    IF quantidade = 1 THEN
            <update que aumenta salario em 300 usando o codigoFuncionario recebido>
    ELSE
            <update que aumenta salario em 500 usando o codigoFuncionario recebido>
    END IF
END $$
DELIMITER ;

I left space for the commands to be inserted because I am not sure of the bank structure and have received few details.