SQL - proceduras 2

DELIMITER //

CREATE DEFINER='root'@'127.0.0.1' PROCEDURE `procedura` (OUT param1 INT, OUT param2 INT)

SQL SECURITY INVOKER

BEGIN

SELECT COUNT(*) INTO param1 FROM `users`;

SELECT (COUNT(*) * 100) INTO param2 FROM `users`;

END//

-------------------------