The code I used to create stored procedure in mysql –
> ``DELIMITER //
DROP PROCEDURE IF EXISTS triage_report;
CREATE PROCEDURE triage_report (IN testing VARCHAR(20))
BEGIN
SELECT a.id, a.normalizedaccountnumber, a.org_id,a.lastsuccess,a.lateststatementdate,a.nepdate
FROM account_data AS a
WHERE a.id < testing;
END //
> `
DELIMITER ;`
I got the below error. How to rectify this?
0 124 14:28:40 CREATE PROCEDURE triage_report (IN testing VARCHAR(20))
BEGIN
SELECT a.id, a.normalizedaccountnumber, a.org_id,a.lastsuccess,a.lateststatementdate,a.nepdate
FROM account_data AS a
WHERE a.id < testing Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 5 0.000 sec
I want to pass on the account id as input to the sp triage_report
Boomi Naathan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.