sql语句,字符串中正确输入反斜杠测试
#sql语句,字符串中正确输入反斜杠测试
select
payment_response_message
from
air_bcp_00.`payment_0000`
where
id = 286540576079875;
#"\"正确入库
# -> {"E_policy_info":"{\"kycFlg\":\"1\",\"yearOfEmployment\":40}","E_employment_year":"40"}
update
air_bcp_00.`payment_0000`
set
payment_response_message = '{"E_policy_info":"{\\"kycFlg\\":\\"1\\",\\"yearOfEmployment\\":40}","E_employment_year":"40"}'
where
id = 286540576079875;
#"\"消失
# -> {"E_policy_info":"{"kycFlg":"1","yearOfEmployment":40}","E_employment_year":"40"}
update
air_bcp_00.`payment_0000`
set
payment_response_message = '{"E_policy_info":"{\"kycFlg\":\"1\",\"yearOfEmployment\":40}","E_employment_year":"40"}'
where
id = 286540576079875;
#恢复
update
air_bcp_00.`payment_0000`
set
payment_response_message = ''
where
id = 286540576079875;
コメント
コメントを投稿