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;

コメント

このブログの人気の投稿

大题材 大全 脑暴

FP3 シミュレーション

日本保险知识体系地图