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?