I have 2 tables `users` and `partners`. They both contain a `created_on` field but that field is new and thus empty in the `partners` table. The `partners` table also has a `user_id` and `partner_id` field. The `user_id` field is the FK to the `users` table.

I need to copy the values of the column `created_on` from the `users` tables into the `partners` table `for each` user `WHERE partners.user_id = users.id`.

I want to do that in SQL (my RDBMS is MySQL) so no PHP (if possible)

(Some pseudo code to get my problem across better)

Copying data is not good practice, I know that, but I need this for a specific case