Stored Procedures & Functions

📄 MySQLLesson 12Advanced

Stored Procedures let you run database logic (control structures, variables, parameter mappings) directly inside MySQL engines.

1 Stored Procedure Structure

SQL — Stored Procedure Definition

DELIMITER //
CREATE PROCEDURE GetUserPosts(IN input_user_id INT)
BEGIN
    SELECT * FROM posts WHERE user_id = input_user_id;
END //
DELIMITER ;

# Call the procedure
CALL GetUserPosts(1);

2 Code Challenge

Challenge: Write a stored procedure named ProcessStockUpdate accepting a product ID and quantity change parameter, modifying product stock volumes accordingly.