INSERT INTO im_roammsg_temp(
oid,
fromAccount,
toAccount,
textMsg,
content,
pcNo
) VALUES
(
#{item.oid},
#{item.fromAccount},
#{item.toAccount},
#{item.textMsg},
#{item.content},
#{item.pcNo}
)
select
oid,
fromAccount,
toAccount,
textMsg,
content,
pcNo
FROM im_roammsg_temp
WHERE pcNo = #{pcNo}
AND fromAccount = #{fromAccount}
AND toAccount = #{toAccount}
AND instr(textMsg,#{keyword})
DELETE
FROM im_roammsg_temp
WHERE (#{times}-1800) ]]> pcNo