How do I update the value of the same field in multiple tables?

problem description

orcaleABCAPHONEBPHONECPHONE:
A              B               C
ID PHONE         ID PHONE         ID PHONE
a1 11111         b1 11111         c1 11111
a1 22222         b2 33333         c2 11111

now I want to change the PHONE=11111 in tables A, B and C to 88888, which is like the following figure:

A                B                C
ID PHONE         ID PHONE         ID PHONE
a1 88888         b1 88888         c1 88888
a1 22222         b2 33333         c2 88888

which Taoist friend has a better way!
Note:

1.sql,update,orcale
2.
3.mybatis
Mar.09,2021

focuses on the fields of a table, while other table-related fields are set to foreign keys. Through the database cascading update mechanism, it will be very simple, because you only need to update the fields of the main table.

Menu