https://dev.mysql.com/doc/refman/8.0/en/update.html
UPDATE student s
INNER JOIN teacher t ON s.manager_id = t.id
SET s.manager_name = t.`name`
where s.id=1
https://dev.mysql.com/doc/refman/8.0/en/update.html
UPDATE student s
INNER JOIN teacher t ON s.manager_id = t.id
SET s.manager_name = t.`name`
where s.id=1