MySQL：Data truncation: Invalid JSON text: “Invalid value.“ at position 1 in value for column
前言
网上没有现成答案解决这种json数据格式的
### SQL: INSERT INTO `order`(`o_id`,`department_id`,`start_adress`,`end_adress`,`proposer`,`relevant_user_id`,`remarks`,`start_time`,`end_time`,`status`,`other`,`c_time`,`title`)VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)
### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Invalid JSON text: "Invalid value." at position 1 in value for column 'order.relevant_user_id'.
; Data truncation: Invalid JSON text: "Invalid value." at position 1 in value for column 'order.relevant_user_id'.; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Invalid JSON text: "Invalid value." at position 1 in value for column 'order.relevant_user_id'.解决
这种json类型传值 用斜杠转译 单引号无效
{"departmentId": "121","endAdress": "广州东站","endTime": "2020-11-11 14:30:30","other": "【带两个】","proposer": "0112119838","relevantUserId": "[[\"0112119838\"]]","remarks": "接送旅客","startAdress": "白云机场","startTime": "2020-11-11 18:30:30","status": 0,"title": "测试"
}
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！