新思路 mysql关于 replace函数用法解决数据更新或新增

最近重构项目中,涉及到表结构变更, 需要对原来的数据做代码层面的双向更新,保证数据一致性。发现mysql中有REPLACE 函数

REPLACE INTO coupon_test.w_user_coupon_use_record( id,user_id_code, user_coupon_id, order_sn, coupon_type, order_id, status, rule_config, biz_code, created_time, updated_time, deleted_time) VALUES (29, 2594277, 17191161, ‘160576703474599524277‘, 6, 0, 1, ‘[{"amount":100,"discount":0.0,"level":1,"promotionId":1010335,"step":1},{"amount":100,"discount":0.0,"level":2,"promotionId":1010335,"step":1},{"amount":100,"discount":0.0,"level":3,"promotionId":1010335,"step":1},{"amount":100,"discount":0.0,"level":4,"promotionId":1010335,"step":1},{"amount":100,"discount":0.0,"level":5,"promotionId":1010335,"step":1}]‘, ‘‘, ‘2020-11-19 14:23:56‘, ‘2021-01-23 11:48:59‘, NULL);

新思路 mysql关于 replace函数用法解决数据更新或新增

上一篇:LINUX修改IP地址


下一篇:MySQL修改某一列的前几个字符