1
2
3
4
5
6
7
8
UPDATE cmf_user u, (
		SELECT if(more ->> '$.mobile' IS NULL, '', more ->> '$.mobile') AS mobile
			, user_id
		FROM `cmf_third_party_user`
	) b
SET u.mobile = b.mobile
WHERE u.id = b.user_id
	AND u.mobile = ''
1
2
3
UPDATE a, b
SET a.title = b.title, a.name = b.name
WHERE a.id = b.id