MYSQL - Multiple set values in one update statement [migrated]
- by Maurzank
MYSQL - MULTIPLE SET VALUES IN ONE UPDATE STATEMENT USING 2 TABLES AS REFERENCE AND STORING VALUES IN ONE OF THOSE TABLES WITH A SPECIFIC LOGIC.
Hello people,
A problem came up by making an UPDATE. The example issue is as follows:
CURRENUSRTABLE
+------------+-------+
| ID | STATE |
+------------+-------+
| 123 | 3 |
| 456 …
