mysql update multiple columns from another table based on conditions code example

Example 1: mysql update one table from another table multiple columns

update  tabe2 set subject_id = (SELECT GROUP_CONCAT(sub_id SEPARATOR ', ') as sub_id FROM tabe1)

Example 2: update multiple columns in mysql

UPDATE newpurchase 
SET receive_qty = 20, pub_lang = 'Hindi', receive_dt = '2008-07-10' 
WHERE purch_price > 50;