mysql - Update n rows from a table to n rows in another table (no foreign key)

Question

I have 2 tables, table_1 and table_2. table_1 included all data which I need to update to table_2.

table_1

column_2	column_3
b1	b1
b2	b2

question from:https://stackoverflow.com/questions/65872772/update-n-rows-from-a-table-to-n-rows-in-another-table-no-foreign-key

Answer 1

I think you should try to do that with a scripting language instead of using sql. get everything from table2 where column_1=1 order by column_2 to an array of objects like

[
 {column_1: 1, column_2: b1, column_3: b1, column_4: a},
 {column_1: 1, column_2: b2, column_3: b2, column_4: a}
]

then get everything from table1 order by column_2 in an array of objects

[
 {column_1: b1, column_2: b1},
 {column_1: b2, column_2: b2}
]

and for every element in table1, update table2 using column_1, column_2, column_3, column_4 in a where qlause

I dont think any other way to do this...it really a pain if the structure is like that