MySQL simple stored procedure

Hard 40 pts New · no attempts yet sql

Topics

Toolliyo edge

Write a procedure to increase salary by percentage for an employee id.

Static hints

DELIMITER //, IN parameters, UPDATE

Toolliyo Coach

Stuck? Get a nudge — not the answer

Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.

Your solution

Editor is open — no login wall to practice.

Ready — edit the code above and click Run or Submit.

Official solution

DELIMITER //
CREATE PROCEDURE bump_salary(IN emp_id INT, IN pct DECIMAL(5,2))
BEGIN
  UPDATE employees SET salary = salary * (1 + pct/100) WHERE id = emp_id;
END //
DELIMITER ;

Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.

Explanation

MySQL procedures use DELIMITER change and BEGIN/END blocks.

Next All problems

MySQL simple stored procedure

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion