Merge two tables by id (MySql)?

Question

MySQL

Hello, there are two tables (tb1, tb2) with a joining column "id". It is necessary to transfer the "content" column from one table "tb1" to the table "tb2" according to the matching id column.

Answer 1

You really have a syntax error.

UPDATE wp_posts
JOIN modx_site_content ON modx_site_content.id = wp_posts.id
SET wp_posts.content = modx_site_content.content

Read more here.
www.mysqltutorial.org/mysql-update-join

Answer 2

select t2.*, t1.content
from tb2 t2 left join tb1 t1 on t2.id = t1.id

Answer 3

The request passes, but no changes are observed. Found another option

UPDATE wp_posts
SET wp_posts.content = modx_site_content.content
FROM modx_site_content JOIN wp_posts ON modx_site_content.id = wp_posts.id

Writes:
#1064 - You have an error in your request. Check the documentation for your version of MySQL for the correct syntax around 'FROM modx_site_content JOIN wp_posts ON modx_site_content.id = wp_posts.id' on line 3