在mysql insert查询的值中传递字符串

Question

如何在值中传递字符串而不是传递每个值。接收误差

错误代码: 1136。列计数与第1行的值计数不匹配

  INSERT INTO `ProfileResumeActivityLog`
    (`Email`,`ProfileID`,`ExternalUserDID`, `EventType`, `ResumeDID`, `EventText`, `CreatedOn`)
    VALUES('checkpp@test.com,73443358,XR2Z1WT6WR5PPR6Z99L4,r
 esume_backload,R3W6WN6LFY95PKL27SR,resume_create, NOW()' );

我想将它作为字符串传递，因为我的存储过程接受批处理插入的动态值数。

CREATE DEFINER=`root`@`localhost` PROCEDURE `SaveBatchMultipleProfileResumeActivityLog`(
    _resumeBatch            TEXT

)
BEGIN

    INSERT INTO `ProfileResumeActivityLog`
    (`Email`,`ProfileID`,`ExternalUserDID`, `EventType`, `ResumeDID`, `EventText`, `CreatedOn`)
    VALUES(_resumeBatch);
    
END

调用

CALL CBAX.SaveBatchMultipleProfileResumeActivityLog   ('checkpp@test.com,73443358,XR2Z1WT6WR5PPR6Z99L4,resume_backload,R3W6WN6LFY95PKL27SR,resume_create, NOW()',

'checkpp@test1.com,73443358,XR2Z1WT6WR5PPR6Z99L41,resume_backload,R3W6WN6LFY95PKL27SR1,resume_create, NOW()' )

Answer 1

当您将字符串放入insert语句中时，您必须将它们放入"“中，这就是为什么您会得到该错误。

INSERT INTO `ProfileResumeActivityLog`(`Email`,`ProfileID`,`ExternalUserDID`, `EventType`, `ResumeDID`, `EventText`, `CreatedOn`)
VALUES('checkpp@test.com',73443358,'XR2Z1WT6WR5PPR6Z99L4','resume_backload','R3W6WN6LFY95PKL27SR','resume_create', NOW() );