We need to fetch the data from Mysql table A and update/insert into Mysql table B, Please find the sample data below and suggest how to handle the Mysql tmap (I mean in B table Student id & class_id_oid combination is unique, so how we can maintain the key value in both source and destination table of tmap).
Mysql Table A
Mysql Table B
Mysql Table C
foreign key
Student Id
Class
Student Name
Student Id
Student Name
Class Id OID
Id
Class Id
Class Name
1
1
ABC
1
ABC
4
4
1
Grade 1
2
1
XYZ
TMAP
Student Id & Class id oid is unique in Table B
2
XYZ
4
5
2
Grade 2
3
1
HJK
3
MNP
5
6
3
Grade 3
3
2
MNP
7
4
Grade 4
2
2
MLP
we want to insert the remaining student values from Table A
