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

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

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

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

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

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

WITH user_name_update AS (
  SELECT m.id, r.name
  FROM  m
  JOIN  r ON m.id_card_no = r.id_card_no
  WHERE m.user_name IS NULL
)
UPDATE m
SET user_name = user_name_update.name
FROM user_name_update
WHERE m.id = user_name_update.id;

去除前后空格

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