Report question

Question: How do I INSERT INTO from one mysql table into another table and set the value of one column?