mysql- 两张无关联表，强制横向关联，并插入数据

drop table if exists aaaaaa;

CREATE table aaaaaa(id varchar(20),c1 varchar(20));
drop table if exists bbbbb;
drop table if exists bbbbb;
CREATE table bbbbb(id varchar(20));

insert into aaaaaa(c1)
values('aaa'),('bbb'),('ccc'),('ddd');


insert into bbbbb
values('q'),('w'),('e'),('r');

select * from aaaaaa;

select * from bbbbb;

select * from  aaaaaa t 
inner join (select @id1:=@id1+1 as rum1,c1 from aaaaaa,(select @id1:=0) tx0) tx1 on t.c1=tx1.c1
inner join (select @id:=@id+1 as rum2,bbbbb.id from bbbbb,(select @id:=0) t20) bbbbb on tx1.rum1=bbbbb.rum2

update  aaaaaa t 
inner join (select @id1:=@id1+1 as rum1,c1 from aaaaaa,(select @id1:=0) tx0) tx1 on t.c1=tx1.c1
inner join (select @id:=@id+1 as rum2,bbbbb.id from bbbbb,(select @id:=0) t20) bbbbb on tx1.rum1=bbbbb.rum2
set t.id=bbbbb.id;