ReadVitamin

There are some special keywords introduced here which are only used in case of a stored procedure. Let’s see which all keywords are used for what purpose.

There are 3 types of the parameter being specified.

IN – used for input type parameter only.

OUT – used for output type parameter only.

INOUT – INOUT can be both input and output type parameter.

By default, if the parameter type is not specified, the parameter is assumed to be of the “IN” type.

BEGIN – This keyword introduces a compound statement. A compound statement can contain all the SQL statements and variable declarations for the stored procedure. This compound statement has to be terminated with the END keyword.

END – This is the terminating keyword for a BEGIN-END compound statement.

DECLARE – DECLARE keyword can be used for a local variable declaration or a cursor declaration or a condition (error/exception) handler declaration.

ITERATE – If you want to terminate the execution of the current iteration of a labeled iteration statement, and start the next iteration, use this keyword ITERATE. If you are using WHILE or FOR loops then the next iteration would start conditionally and in case if you are LOOP and REPEAT the next iteration would start unconditionally.

LEAVE – Used to exit out from a current iteration and continue execution outside the current iteration.

DEFAULT – This is an optional keyword for introducing a default value for the local variables.

SET – SET is the keyword that is used for assigning a value to a variable or parameter.

CALL – Used to invoke the procedure.

PRINT – This command is used to display something to the screen. Mostly used for testing/debugging purpose. Remember to enable this option while creating the procedure.

Popularity: 24% [?]