sql

[saykaren]

debug stored procedure

• create table to save message

• CREATE TABLE log_msg ( id INT NOT NULL AUTO_INCREMENT, log VARCHAR(255) NULL, PRIMARY KEY (id));

• Create procedure to add messages to that table

• DELIMITER $$

USE schema$$

DROP PROCEDURE IF EXISTS log_msg$$

CREATE PROCEDURE log_msg(msg VARCHAR(255)) BEGIN insert into log_msg select 0, msg; END$$

DELIMITER ;

• Use call in stored procedures to store data
• call log_msg(concat( 'variable = ', _variable));

Pull the stored procedure with your changes out of PHPstorm (without top comments) run in mySQLWorkbench or in PHPStorm DB console

Now in in that same spot run that stored procedure with required parameters

call SpUpdateFees(variable1, variable2);

Check your log_msg table to check values that you logged

SELECT * FROM log_msg;

[Pranay1010]

Please replace _variable, variable1, and variable2 with your actual variables.

[saykaren]

@Pranay1010 Weird request. You know that stored proc isn't real right? _variable would be whatever variable in the stored procedure you are wanting to get insight to. The variable1 and variable2 or whatever variables that store procedure when real takes