如何将json格式的文件update到MySQL

黎前点星

我尝试将json格式的数据update到mysql，但提示失败，如何解决呀

update web_zizhanghao set  peifarouter = "{"resCode":"B00010","msg":"成功","obj":{"billName":"2023102604","routeList":[{"pageNo":1,"pageSize":20,"routeName":"青阳包快-池州(池1)","routeCode":"3324708003","busDate":"2023/10/26 16:30","overhandObjectType":"1"},{"pageNo":1,"pageSize":20,"routeName":"青阳包快-池州(池2)","routeCode":"3324286031","busDate":"2023/10/26 18:51","overhandObjectType":"1"},{"pageNo":1,"pageSize":20,"routeName":"青阳包快-池州(池3)","routeCode":"3124708520","busDate":"2023/10/26 20:10","overhandObjectType":"1"},{"pageNo":1,"pageSize":20,"routeName":"池州-青阳(池青1)","routeCode":"3124702443","busDate":"2023/10/27 06:20","overhandObjectType":"1"}]}}" where username = 2428760099999

zhongzutao

内容中的符号需要添加转义符

zhongzutao

或则吧json进行base64编码

黎前点星

zhongzutao 发表于 2023-10-26 12:27
内容中的符号需要添加转义符

还是不行哦
update web_zizhanghao set  peifarouter = "{"resCode":"B00010","msg":"成功","obj":"{\"billName\":\"2023102605\",\"routeList\":[{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"青阳包快-池州(池1)\",\"routeCode\":\"3324708003\",\"busDate\":\"2023/10/26 16:30\",\"overhandObjectType\":\"1\"},{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"青阳包快-池州(池2)\",\"routeCode\":\"3324286031\",\"busDate\":\"2023/10/26 18:51\",\"overhandObjectType\":\"1\"},{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"青阳包快-池州(池3)\",\"routeCode\":\"3124708520\",\"busDate\":\"2023/10/26 20:10\",\"overhandObjectType\":\"1\"},{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"池州-青阳(池青1)\",\"routeCode\":\"3124702443\",\"busDate\":\"2023/10/27 06:20\",\"overhandObjectType\":\"1\"}]}"} where username = 2428760099999”
* “{"resCode":"B00010","msg":"成功","obj":"{\"billName\":\"2023102605\",\"routeList\":[{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"青阳包快-池州(池1)\",\"routeCode\":\"3324708003\",\"busDate\":\"2023/10/26 16:30\",\"overhandObjectType\":\"1\"},{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"青阳包快-池州(池2)\",\"routeCode\":\"3324286031\",\"busDate\":\"2023/10/26 18:51\",\"overhandObjectType\":\"1\"},{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"青阳包快-池州(池3)\",\"routeCode\":\"3124708520\",\"busDate\":\"2023/10/26 20:10\",\"overhandObjectType\":\"1\"},{\"pageNo\":1,\"pageSize\":20,\"routeName\":\"池州-青阳(池青1)\",\"routeCode\":\"3124702443\",\"busDate\":\"2023/10/27 06:20\",\"overhandObjectType\":\"1\"}]}" where username = 2428760099999

黎前点星

zhongzutao 发表于 2023-10-26 12:28
或则吧json进行base64编码

不想编码

zhongzutao

除了箭头位置的引号不用转义，其他的全都要添加\

zzh233

cchttp欢迎您 瞬间全部写入 啥都别操心

黎前点星

zhongzutao 发表于 2023-10-26 12:42
除了箭头位置的引号不用转义，其他的全都要添加\

哥们可有时间帮忙看下，有偿的

zhongzutao

黎前点星 发表于 2023-10-26 16:13
哥们可有时间帮忙看下，有偿的

可以啊，私聊你啦