UPDATE USER INNER JOIN (SELECT id,account FROM USER) c SET user.phone=c.account WHERE user.id UPDATE USER INNER JOIN (SELECT id,ac
UPDATE USER INNER JOIN (SELECT id,account FROM USER) c SET user.phone=c.account WHERE user.id UPDATE USER INNER JOIN (SELECT id,ac