1 2 3 4 5
BEGIN; INSERT INTO Friends (PrincipalID, FriendID, Flags) SELECT ownerID, friendID, friendPerms FROM userfriends; COMMIT;