How to update all profile fields in one request if those fields are rows and not columns?

Question

MySQL

There are tables:
users
[UserId][UserName]
userprofiles
[UserId][Field][Value]
That is, the fields in this
MySQL allows you to execute a query

Answer 1

Loop through all rows and update each

Answer 2

If (`UserId`, `Field`) is a unique key, then

INSERT INTO `userprofiles` (`Field`, `Value`) 
    VALUES ('fld1', 'val1'), ('fld2', 'val2'), ... ('fldN', 'valN')
    ON DUPLICATE KEY UPDATE `Value` = VALUES(`Value`)
    WHERE `UserId` = 'uid'