Reading Notes-MySQL stored procedure-storage function _ MySQL

Reading Notes-MySQL stored procedure-storage function bitsCN.com

The differences between stored functions and stored procedures are as follows:

1. IN the function parameter list, the mode can only be IN.

2. the function must return a value. its type is defined in the function header.

3. functions can be called by SQL statements.

4. the function may not return any result set.

DELIMITER $ drop function if exists discount_price $ create function discount_price normal_price NUMERIC (8, 2) return numeric (8, 2) deterministicbegin declare v_discount_price NUMERIC (8, 2 ); IF (normal_price> 500) then set discount_price = normal_price *. 8; else if (normal_price> 1000) then set discount_price = normal_price *. 9; else set discount_price = normal_price; end if; RETURN (discount_price); END $

BitsCN.com