Community The simultaneous_assignment mode in MariaDB 10.3.5 by SSWUG Research (Peter Gulutzan) Starting with MariaDB 10.3.5, if you say sql_mode = ‘simultaneous_assignment’, then UPDATE t SET a = b, b = a; Register to Read