Mysql Copy a field’s value to another related table

The task is to copy the value of the oldfield field to newfield field