Community

The simultaneous_assignment mode in MariaDB 10.3.5

(Peter Gulutzan) Starting with MariaDB 10.3.5, if you say sql_mode = ‘simultaneous_assignment’, then UPDATE t SET a = b, b = a;