摘要: START TRANSACTION; #中间是sql语句 ROLLBACK;COMMIT; 阅读全文
posted @ 2024-04-09 15:34 windy1012 阅读(4) 评论(0) 推荐(0) 编辑
摘要: 1. mysql update varchar存储类型的 ["1","2"]更新为["1","2","3"] UPDATE project_business aSET a.`company_tag` = JSON_ARRAY_APPEND(company_tag, '$', '3')WHERE a. 阅读全文
posted @ 2024-04-09 15:32 windy1012 阅读(4) 评论(0) 推荐(0) 编辑