MySQL 8.0

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

select version();


version()


8.0.19


create table XYZ ( id int unsigned not null primary key auto_increment, name varchar(10))
insert into XYZ() values (),(),(),(),()
create table ABC ( id int unsigned not null primary key auto_increment, name varchar(10))
insert into ABC(id,name) values (3, 'alex'),(4,'rocky')
update XYZ JOIN ABC USING (id) SET XYZ.name=ABC.name
select * from XYZ


id
name


1
null

2
null

3
alex

4
rocky

5
null

id	name
1	null
2	null
3	alex
4	rocky
5	null