About stored procedures and what are they?

MYSQL 5 has introduced the feature called stored procedure, which is a set of SQL statements which can perform repetitive task. The stored proc...

Variables in stored procedures

Variable is a data object. Its value can be changed during the execution of the stored procedure. The results of the procedure execution are stored in variables. To declare variable inside procedur...

Parameters in stored procedures

Parameter is the variable which is passed to

Return values in stored procedures

Stored procedure does not return a value using RETURN statement. But CALL statement gets the values of stored procedures

The IF statement in stored procedures

The IF statements in MYSQL executes a block of code depending on the condition inside the IF statement, whether is true or false. The condition inside IF statement can be formed by...

The CASE statement in stored procedures

The CASE statements are used to implement a complex conditional construct. The CASE statements are declared in two ways: CASE caseValue  &nb...

What is MySQL cursor?

MySQL Cursors exist and are set to traverse in datasets, returned by...

MYSQL Stored Functions

A stored function in MySQL encapsulates user defined formulas that can be reused amon...