table1的u_id和table2的u_id是主外键关系
Sql代码
UPDATE zl.table1 t1,zl.table2 t2 SET t1.aa
=
'
a
'
,t1.bb
=
'
b
'
,t2.cc
=
'
c
'
,WHERE t1.u_id
=
t2.u_id AND t1.u_id
=
'
1
'