Pages

Wednesday, September 13, 2017

Update table column from any other column from any table mysql query

UPDATE table1 T1
INNER JOIN editorial B ON B.editorial_id = T1.editorial_id
SET T1.to_design = B.`coversentto`

WHERE T1.`to_design` ='' || T1.`to_design` IS NULL