Procedure is a set of SQL statement enclosed in 'BEGIN' and 'END' statement and executed under one name.
Understand with Example
The Tutorial illustrate an Example from Simple Procedure that helps you to display 'Hello World'. In this Example, we create a procedure 'abc' using create procedure statement. The select statement return you the 'Hello,World' ,whenever a procedure 'abc' is invoked.
Create a Procedure
create procedure abc() BEGIN SELECT 'Hello,World' world'; END$$ delimiter ;
The callprocedure abc ( ) is used invoke procedure 'abc'.
+--------------+ | Hello, world | +--------------+ | Hello, world | +--------------+
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.