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 AddOrderItem.sql is:
DROP PROCEDURE IF EXISTS AddOrderItem; DELIMITER $$ CREATE PROCEDURE AddOrderItem( in orderNo int, in productCode varchar(45), in qty int, in price double, in lineNo int ) BEGIN DECLARE C INT; SELECT COUNT(orderNumber) INTO C FROM orders WHERE orderNumber = orderNo; -- check if orderNumber exists IF(C != 1) THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Order No not found in orders table.'; END IF; -- more code below -- ... END$$ DELIMITER ;