Is the order of the columns really important when using UPDATE?

Answer 1

I do not see is necessary to keep an order of columns but column names for the one you want to update must be specified. Also where clause is critical unless you want to set that value to the column in all records of the database.

Answer 2

It's not. You can any random order while updating field values.