Q:

Migrate one column of a table to another table's column in phpmyadmin

field_data_body
+----------+---------------------+
| entry_id | body_value          |
+----------+---------------------+
|  1009    | content             |
+----------+---------------------+
|  1020    |                     |
+----------+---------------------+
|  1025    | more content        |
+----------+---------------------+

i_posts
+------+---------------+
|  id  |     html      |
+------+---------------+
| 1009 |               |
+------+---------------+
| 1020 |               | 
+------+---------------+
| 1025 |               | 
+------+---------------+

i_posts
+----------+---------------------+
| id       | html                |
+----------+---------------------+
|  1009    | content             |
+----------+---------------------+
|  1020    |                     |
+----------+---------------------+
|  1025    | more content        |
+----------+---------------------+

Hi, I'm trying to transfer the body_value column into the html column and am not sure how to execute this. I have a table called i_posts and I have all the id's of my posts that i'm trying to transfer. However in the field_data_body table it doesn't have content for every single entry_id. Is there a way to move the body_value into the html column while keeping the correct id? Thanks for any help in advanced!!
 - Blake

A:

Edit: 
This is what you need.
UPDATE i_posts AS i, field_data_body AS f SET i.html = f.body_value WHERE i.id =f.entry_id
I did a small post about it.

