ON DUPLICATE KEY UPDATE添加或更新(转)
首先主键是索引
insert into ys_yssf_rj
(customerId,settleDate,settleMoney,
settleActual, settleBalance,settleAccountState)
VALUES
(#customerId#,now(),#settleMoney#,
#settleActual#,#settleBalance#,#settleAccountState#
)
ON DUPLICATE KEY UPDATE
settleDate = now(),
s
转载
2020-12-03 11:18:24 ·
304 阅读 ·
0 评论