mysql>
mysql>
mysql> DELIMITER //
mysql>
mysql> CREATE FUNCTION perform_logic (some_input INT(10)) returns INT(10)
-> BEGIN
-> DECLARE problem CONDITION FOR 1265;
-> DECLARE EXIT HANDLER FOR problem
-> RETURN NULL;
->
-> # do some logic, if the problem condition is met
-> # the function will exit, returning a NULL
->
-> RETURN 1;
-> END
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> DELIMITER ;
mysql>
mysql> drop function perform_logic;
Query OK, 0 rows affected (0.00 sec)
mysql>
|