MySQL 存储过程插入选择

问：

CREATE DEFINER=`generic_user`@`localhost` PROCEDURE `copy_GenericOperation`(IN genericInputID INT)

BEGIN

   DECLARE newOperationInfoId int;

   Insert into genericOperationInfoTable(createdBy, creationDate, modifiedBy, modificationDate, genericOperationId, cycleTime, notes, overrideFlag, processId, subProcessId, setupId)

   select createdBy, createdDate, updatedBy, updatedDate, operationId, cycleTime, notes, override, processId, subProcessId, setupId 

   from operationinfo

   where id=genericInputID;

   SELECT LAST_INSERT_ID() as newOperationInfoId;

   SET newOperationInfoId=LAST_INSERT_ID();

   Insert into genericTransactionTable(id, parameterId, value, genericOperationInfoId, overrideFlag)

   SELECT

      ot.parameterId, ot.value, newOperationInfoId, ot.overrideFlag

   FROM genericTransactionTable as ot

   where ot.genericOperationInfoId=genericInputID;

END

我正在尝试创建一个存储过程，以便将插入表中最后生成的 ID 插入到下一个表中

第一次插入工作正常，但我不确定为什么没有在第二个表中插入任何数据