I tried some queries(stored procedures) using MySQL but the query runs in workbench and displays result but when I tried it in command prompt (cmd) it displays NULL as output. Here's my code:
DELIMITER $$
CREATE PROCEDURE EXAMPLE(INOUT VAR1 INT)
BEGIN
SELECT SALARY INTO VAR1 FROM DIM_ACCOUNTS WHERE CUSTOMER_ID=VAR1;
END $$
DELIMITER ;
SET @N='504';
CALL EXAMPLE(@N);
SELECT @N;