Examples and Notes by Week

↑ Up to Parent directory
View Create_GetCustomerLevel.sql code.	Open/Save Create_GetCustomerLevel.sql.
View Create_GetCustomerLevel2.sql code.	Open/Save Create_GetCustomerLevel2.sql.
View Create_GetCustomerLevel3.sql code.	Open/Save Create_GetCustomerLevel3.sql.
View Create_GetCustomerShipping.sql code.	Open/Save Create_GetCustomerShipping.sql.
View Create_GetCustomers.sql code.	Open/Save Create_GetCustomers.sql.
View Create_GetOfficeByCountry.sql code.	Open/Save Create_GetOfficeByCountry.sql.
View Create_GetOrderCountByStatus.sql code.	Open/Save Create_GetOrderCountByStatus.sql.
View Create_GetTotalOrde_sessionr.sql code.	Open/Save Create_GetTotalOrde_sessionr.sql.
View Create_GetTotalOrder.sql code.	Open/Save Create_GetTotalOrder.sql.
View GetAllProducts.sql code.	Open/Save GetAllProducts.sql.
View LoopDemo.sql code.	Open/Save LoopDemo.sql.
View exit_handler.sql code.	Open/Save exit_handler.sql.
View while.sql code.	Open/Save while.sql.

The code for Create_GetCustomerShipping.sql is:
DROP PROCEDURE IF EXISTS GetCustomerShipping; DELIMITER $$ CREATE PROCEDURE GetCustomerShipping( IN pCustomerNUmber INT, OUT pShipping VARCHAR(50) ) BEGIN DECLARE customerCountry VARCHAR(100); SELECT country INTO customerCountry FROM customers WHERE customerNumber = pCustomerNUmber; CASE customerCountry WHEN 'USA' THEN SET pShipping = '2-day Shipping'; WHEN 'Canada' THEN SET pShipping = '3-day Shipping'; ELSE SET pShipping = '5-day Shipping'; END CASE; END$$ DELIMITER ; CALL GetCustomerShipping(112,@shipping); SELECT @shipping; CALL GetCustomerShipping(202,@shipping); SELECT @shipping; CALL GetCustomerShipping(114,@shipping); SELECT @shipping;