MYSQL VERSION - 5.7.12
I am getting syntax error when creating this procedure . I have added code for creating table and then called this procedure.
-- create table
CREATE TABLE ResumeActivityLog ( Email VARCHAR(255),
ProfileID int (11),
ExternalUserDID VARCHAR(255),
EventType VARCHAR(255),
ResumeDID VARCHAR(255),
EventText VARCHAR(255),
CreatedOn DATETIME);
-- create procedure
CREATE PROCEDURE `SaveMultipleResumeActivityLog`(
_resumeDIDs Text
)
INSERT INTO `ResumeActivityLog` (`Email`,`ProfileID`,`ExternalUserDID`, `EventType`, `ResumeDID`, `EventText`, `CreatedOn`)
SELECT "", 0, "", "resume_anon_delete", ResumeDID, "success", CURRENT_TIMESTAMP
FROM JSON_TABLE(CONCAT('["', REPLACE(_resumeDIDs, ',', '","'), '"]'),
'$[*]' COLUMNS (ResumeDID VARCHAR(255) PATH '$')) jsontable;
-- call procedure with CSV as a parameter
CALL SaveMultipleResumeActivityLog('R2W5D16T8BRYWZKRF28,RHL1B05ZTQ546JKF0RG,RD95SY747Z89M7GN8TP,R2N54T767CZTBY79N00,RHT2GR6K0FTYTPFG985,RDH4KV5Z3WX7SV2850N');
-- check for the result
SELECT * FROM ResumeActivityLog;