Problem in sql with mysql using command line?

Viewed 25

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;
0 Answers
Related