修改
UPDATE sys_user A
JOIN `使用情况总表` B ON A.user_name = B.f2
SET A.phonenumber = B.f3;
查询B表的名字不存在A表的数据
SELECT B.*
FROM `使用情况总表` B
WHERE NOT EXISTS (
SELECT 1
FROM sys_user A
WHERE B.f2 = A.user_name
)
UPDATE sys_user A
JOIN `使用情况总表` B ON A.user_name = B.f2
SET A.phonenumber = B.f3;
SELECT B.*
FROM `使用情况总表` B
WHERE NOT EXISTS (
SELECT 1
FROM sys_user A
WHERE B.f2 = A.user_name
)