解决SQL更新时反斜杠丢失的问题

概述

如果再更新字段的sql如下：

UPDATE o2o_delivery_parts
SET logistics_fail_param = '{"order_type":10,"send_name":"\u5468\u5f66"}'
WHERE id=288944 LIMIT 1;

那么实际执行的结果logistics_fail_param的值是：

-- 反斜杠消失
logistics_fail_param = '{"order_type":10,"send_name":"u5468u5f66"}'

解决办法

要用双斜杠代表一个斜杠

UPDATE o2o_delivery_parts
SET logistics_fail_param = '{"order_type":10,"send_name":"\\u5468\\u5f66"}'
WHERE id=288944 LIMIT 1;