MySql查询JSON字段值的指定key的数据

SELECT  * FROM thunis_log WHERE  accept_body->'$.code' != 200

根据两表关联字段插入第二个关联字段

UPDATE table1 t1 JOIN table2 ON t1.f1 = t2.f1 SET t1.f2 = t2.f2 

去除sql中特殊字符

UPDATE o_country SET CODE =  REPLACE(REPLACE(REPLACE(CODE,CHAR(9),''),CHAR(10),''),CHAR(13),'')  WHERE CODE IS NOT NULL

去除前后空格

 UPDATE o_country SET CODE = TRIM(CODE);
```