It’s really easy to use SQL to update multiple columns of your table at once with different values.
As example we will update the following table:
[Column1] = Value1,
[Column2] = Value2,
The WHERE clause is optional.
A simple example referring to the RobotDog table can be:
Armed = 1,
Guns = 10
WHERE Name LIKE "[A value of choice..]"