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 CustomerLevel_Fuction.sql is:
DROP FUNCTION IF EXISTS CustomerLevel; DELIMITER $$ CREATE FUNCTION CustomerLevel( credit DECIMAL(10,2) ) RETURNS VARCHAR(20) DETERMINISTIC BEGIN DECLARE customerLevel VARCHAR(20); IF credit > 50000 THEN SET customerLevel = 'PLATINUM'; ELSEIF (credit <= 50000 AND credit >= 15000) THEN SET customerLevel = 'GOLD'; ELSEIF credit < 15000 AND credit > 0 THEN SET customerLevel = 'SILVER'; ELSE SET customerLevel = 'LEAD'; END IF; -- return the customer level RETURN (customerLevel); END$$ DELIMITER ;