Copy one column from one table to another table column – MySql.
[code language=”sql”]
UPDATE `table` , `table_2` SET table_2.HQ_ID = table.HQ_ID WHERE table_2.name = table.name
[/code]
[code language=”sql”]
UPDATE `table` , `table_2` SET table_2.HQ_ID = table.HQ_ID WHERE table_2.name = table.name
[/code]