How do I write a mysql query that will read data from one table and write to another?
mysql, sql
Solution
Pseudo code:
insert into <target-table>
( <column-list> )
select <columns>
from <source-table>
Problem
If this is possible, please provide a sample query or two so I can see how it would work. Both tables will be in the same database. Thanks!