[MySQL] How to copy column into another table?

Considering donating if you found my post helpful 😊

Problem

I have a WordPress plugin that saves content as metadata. After a while, I think I should use default place to store that data which is post_content, in wp_posts inside my MySQL database.

I could just create a script that copy those data in loop, but I was thinking is it possible to just use SQL command?

Description

I have 2 tables that look like these

wp_posts

wp_postmeta

As you can see, the first table (wp_posts) contains empty post_content because I store them in overview under column meta_key inside table wp_postmeta.

Solution

After a few readings, I came into this solution

UPDATE
  wp_posts t1,
  wp_postmeta t2
SET
  t1.post_content = t2.meta_value
WHERE
  t1.ID = t2.post_id
  AND t2.meta_key = overview;

Reference

1. https://stackoverflow.com/a/224740

Considering donating if you found my post helpful 😊