Examples and Notes by Week

↑ Up to Parent directory
View AddOrderItem.sql code.	Open/Save AddOrderItem.sql.
View CustomerLevel_Fuction.sql code.	Open/Save CustomerLevel_Fuction.sql.
View Divide.sql code.	Open/Save Divide.sql.
View GetCustomerLevel.sql code.	Open/Save GetCustomerLevel.sql.
View InsertSupplierProduct.sql code.	Open/Save InsertSupplierProduct.sql.

The code for Divide.sql is:
DROP PROCEDURE IF EXISTS Divide; DELIMITER $$ CREATE PROCEDURE Divide(IN numerator INT, IN denominator INT, OUT result double) BEGIN DECLARE division_by_zero CONDITION FOR SQLSTATE '22012'; DECLARE CONTINUE HANDLER FOR division_by_zero RESIGNAL SET MESSAGE_TEXT = 'Division by zero / Denominator cannot be zero'; -- IF denominator = 0 THEN SIGNAL division_by_zero; ELSE SET result := numerator / denominator; END IF; END$$ DELIMITER ;