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 exit_handler.sql is:
CREATE TABLE SupplierProducts ( supplierId INT, productId INT, PRIMARY KEY (supplierId , productId) ); DELIMITER $$ CREATE PROCEDURE InsertSupplierProduct( IN inSupplierId INT, IN inProductId INT ) BEGIN -- exit if the duplicate key occurs DECLARE EXIT HANDLER FOR 1062 BEGIN SELECT CONCAT('Duplicate key (',inSupplierId,',',inProductId,') occurred') AS message; END; -- insert a new row into the SupplierProducts INSERT INTO SupplierProducts(supplierId,productId) VALUES(inSupplierId,inProductId); -- return the products supplied by the supplier id SELECT COUNT(*) FROM SupplierProducts WHERE supplierId = inSupplierId; END$$ DELIMITER ; CALL InsertSupplierProduct(1,1); CALL InsertSupplierProduct(1,2); CALL InsertSupplierProduct(1,3); CALL InsertSupplierProduct(2,3);