Iam bit new to Mysql, What is my question is, how to Update or Insert Table_1 column data to Table_2 column data with matching the relevant Id's from Table_1.
For Eg.
Table_1 Table_2
rand | cpn rand | cpn
1 4 2 0
2 7 3 0
3 2 5 0
4 1 1 0
5 7 4 0
The above mentioned table are the current structure of the my tables, my output should be like this,
Table_2
rand | cpn
2 7
3 2
5 7
1 4
4 1
I want to match the ids from table_1 and update in table_2, accordingly Thanks in Advance :)