clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591614 fiddles created (45703 in the last week).

select version();
version()
8.0.19
 hidden batch(es)


create table XYZ ( id int unsigned not null primary key auto_increment, name varchar(10))
 hidden batch(es)


insert into XYZ() values (),(),(),(),()
 hidden batch(es)


create table ABC ( id int unsigned not null primary key auto_increment, name varchar(10))
 hidden batch(es)


insert into ABC(id,name) values (3, 'alex'),(4,'rocky')
 hidden batch(es)


update XYZ JOIN ABC USING (id) SET XYZ.name=ABC.name
 hidden batch(es)


select * from XYZ
id name
1
2
3 alex
4 rocky
5
 hidden batch(es)