PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database.
The Syntax for a PL/SQL Block
DECLARE
variable_declarations
BEGIN
program_code
EXCEPTION
exception_handlers
END;
CREATE PROCEDURE and CREATE FUNCTION Syntax in MySQL:
DROP PROCEDURE IF EXISTS CALLS;
DELIMITER ;;
CREATE PROCEDURE CALLS()
BEGIN
DECLARE i INT DEFAULT 0;
DECLARE n INT DEFAULT 0;
SELECT COUNT(*) FROM car INTO n;
SET i=1;
WHILE i
select * from car where id between i and i+100
SET i = i + 100;
SELECT SLEEP(2);
END WHILE;
END;
;;
DELIMITER ;;
CREATE PROCEDURE CALLS()
BEGIN
DECLARE i INT DEFAULT 0;
DECLARE n INT DEFAULT 0;
SELECT COUNT(*) FROM car INTO n;
SET i=1;
WHILE i
select * from car where id between i and i+100
SET i = i + 100;
SELECT SLEEP(2);
END WHILE;
END;
;;
DELIMITER ;
Sources :
http://www.mysqltutorial.org/getting-started-with-mysql-stored-procedures.aspx
Advertisements
