mysql update one column from another table in all rows code example

Example: 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)