0

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;

enter image description here

art
  • 226
  • 3
  • 11
  • 30

0 Answers0