Showing entries 1 to 1
Displaying posts with tag: expression (reset)
Aug
23
2014
Using conditional expressions inside MySQL Stored Procedure
Posted by Rookie Dev on Sat 23 Aug 2014 03:03 UTC
Tags:

Sometimes there is need to use conditional expression inside stored procedure to control the flow of execution.
We can use IF or CASE statements for this.


Below is a stored procedure to check the performance of a student based on its score.
Store the below stored procedure in a file called get_performance.sql

DELIMITER $$

DROP PROCEDURE IF EXISTS get_performance$$

CREATE PROCEDURE get_performance
    (score NUMERIC(8, 2),
    OUT result VARCHAR(11))

BEGIN
    IF (score >= 90) THEN
        SET result = 'OUTSTANDING';
    ELSEIF (score >= 70 …

[Read more]
Showing entries 1 to 1