Stored Procedure

-- Stored Procedure di MySQL
DELIMITER //
CREATE PROCEDURE GetActiveUsers()
BEGIN
  SELECT * FROM users WHERE active = 1;
END //
DELIMITER ;

-- Panggil procedure
CALL GetActiveUsers();