Begin End Examples
mysql>
mysql> DELIMITER //
mysql> CREATE FUNCTION myProcedure (rate DECIMAL(10,2))
-> RETURNS DECIMAL(10,2)
->
-> SQL SECURITY DEFINER
->
-> tax: BEGIN
-> DECLARE discount DECIMAL(10,2);
-> SET discount = rate * .05;
-> RETURN discount;
-> END
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> DELIMITER ;
mysql>
mysql> select myProcedure(123.45);
+----------------+
| myProcedure(123.45) |
+----------------+
| 6.17 |
+----------------+
1 row in set, 1 warning (0.00 sec)

mysql>
mysql> drop function myProcedure;
Query OK, 0 rows affected (0.00 sec)

mysql>