how to make update one table coloumwhen we do change in another table in same coloum in mysql code example

Example: update you can't specify target table for update in from clause

UPDATE myTable
SET myTable.A =
(
    SELECT B
    FROM (SELECT * FROM myTable) AS something
    INNER JOIN ...
)