Copy data from one table to another in MySQL
Posted on 2014-09-14
I want help in achieving the below two steps:
1. I want to copy data from my temporary table i.e. temp_table to another table i.e. actual_table.
temp_table consists of columns col1, col2, col3 and col4. While actual_table consists of columns accol1, accol2, accol3, accol4, accol5 and accol6. The data from all of temp_table columns needs to be copied in columns accol3, accol4, accol5 and accol6 of actual_table.
2. While the data is being copied from temp_table to actual_table, I also want set a specific value of accol2 in actual_table.
I hope I have provided inputs. If anything is required then do let me know.