erUjgJYk

1create table if not exists table1 (
2      id int(11) auto_increment,
3      data1 varchar(50),
4      primary key(id)
5    );
6    create table if not exists table2 (
7      id int(11) auto_increment,
8      data2 varchar(50),
9      primary key(id)
10    );
11    create table if not exists table3 (
12      id int(11) auto_increment,
13      t1_id int(11),
14      t2_id int(11),
15      data3 varchar(50),
16      primary key(id)
17    );
18	
19create table if not exists 2table1 (
20      id int(11) auto_increment,
21      data1 varchar(50),
22      primary key(id)
23    );
24    create table if not exists 2table2 (
25      id int(11) auto_increment,
26      data2 varchar(50),
27      primary key(id)
28    );
29    create table if not exists 2table3 (
30      id int(11) auto_increment,
31      t1_id int(11),
32      t2_id int(11),
33      data3 varchar(50),
34      primary key(id)
35    );
36	
37insert into database1.table1 (data1)
38        values('table_1_data_1'),
39        ('table_1_data_2'),
40        ('table_1_data_3');
41
42    insert into database1.table2 (data2)
43        values('table_2_data_1'),
44        ('table_2_data_2'),
45        ('table_2_data_3');
46
47    insert into database1.table3 (data3,t1_id,t2_id)
48        values('table_3_data_1',1,1),
49        ('table_3_data_2',1,2),
50        ('table_3_data_3',2,1),
51        ('table_3_data_4',2,2),
52        ('table_3_data_5',2,3);
53	
54insert into database2.2table1 (data1)
55        values('2table_1_data_1'),
56        ('2table_1_data_2'),
57        ('2table_1_data_3');
58
59    insert into database2.2table2 (data2)
60        values('2table_2_data_1'),
61        ('2table_2_data_2'),
62        ('2table_2_data_3');
63	
64insert into database2.2table1 (data1)
65        select data1 from database1.table1;
66    insert into database2.2table2 (data2)
67        select data2 from database1.table2;
68	
69insert into database2.2table3 (t1_id,t2_id,data3) select
70      (select 2t1.id from database2.2table1 2t1 where 2t1.data1 =t1.data1 ),
71      (select 2t2.id from database2.2table2 2t2 where 2t2.data2 =t2.data2 ),
72      t3.data3
73    from database1.table3 t3
74    left join database1.table1 as t1 on t1.id = t3.t1_id
75    left join database1.table2 as t2 on t2.id = t3.t2_id;