Creating Stored Procedure in MySql

DELIMITER $$;

DROP PROCEDURE IF EXISTS `report`.`Onu`$$

CREATE PROCEDURE `report`.`Onu` ()
BEGIN
select * from student;
END$$

DELIMITER ;$$

Here Student is the name of the table from which data is being selected.

It is a simple stored procedure for selecting data from table called table. Where Onu is the name if the stored procedure.
You can call this stored procedure using call proc name () function.

Example:-

call Onu ()

Ebook Download
View all
Learn
View all