mysql - Update problem of related data table

Question

UPDATE a,b SET a.v_publishyear = b.v_publishyear WHERE a.v_id = b.v_e

I want to update the data in table a. There should actually be more than 9,000 pieces of data, but in fact only 120 pieces of data can be updated. How is this going.
Update the publishyear field in table b to the corresponding publishyear field in table a.

But when I perform the operation

SELECT * FROM a table, b table where a table.c field = b table.d field
During this query, more than 9,000 pieces of data can be queried. What is going on?
Me What went wrong in the update data code?

Answer 1

UPDATE is not suitable for using WHERE to associate two tables. So try writing it this way:

UPDATE a LEFT JOIN b ON a.v_id = b.v_e SET a.v_publishyear = b.v_publishyear

Answer 2

update tableA a
    set a.v_publishyeaar=(select b.v_publishyear from tableB b where b.v_e=a.v_id)