Mysql update one table with data from another how?

Question

MySQL

here is the code:

update
  table_a, table_b
set 
  table_a.column1 = table_b.column1,
  table_a.column2 = table_b.column2
where
  table_a.column3 = table_b.column3
limit 1

gives the following error:
1121: Incorrect usage of UPDATE and LIMIT
Tell me then how to write it correctly.

Answer 1

It turns out you can't use LIMIT when UPDATE a table with data from another table...

Answer 2

Write a stored procedure.