MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (pk integer not null primary key, data1 varchar(30), data2 varchar(30));
insert into test (pk, data1, data2) values(1, 'a1', 'b1');
insert into test (pk, data1, data2) values(2, 'a2', 'b2');
select * from test;


pk
data1
data2


1
a1
b1

2
a2
b2


update test set data2 = 'update col order matters', data1 = data2;
select data1 from test;


data1


update col order matters

update col order matters