根据两个表相同的UserName,将table1的TrueName 更新到table2的TrueName
update table1 join table2 on table1 .UserName=table2 .UserName
set table1 .TrueName = table2 .TrueName;
根据两个表相同的UserName,将table1的TrueName 更新到table2的TrueName
update table1 join table2 on table1 .UserName=table2 .UserName
set table1 .TrueName = table2 .TrueName;