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