update 更新多条数据写法
我有AB 两张表 AB 表里面都有 zhdh 字段,我想修改A表里面 某X字段的值,X字段的值从B表里面获取,B表每个账号对应每个的X值都不一样。例如:
A表如下
zhdh khdh lx lr
100000000000000 11000000 0.111000 0.122000
100000000000001 11000001 0.111000 0.122000
100000000000002 11000002 0.111000 0.122000
100000000000003 11000003 0.111000 0.122000
100000000000004 11000004 0.111000 0.122000
100000000000005 11000005 0.111000 0.122000
100000000000006 11000006 0.111000 0.122000
100000000000007 11000007 0.111000 0.122000
B表如下
id pid rq zhdh khdh zjzysr lxzc
-------- ------ -------- --------------- -------- -------- --------
id588893 pid580 20150428 100000000000000 11000000 0.111000 0.122000
id588894 pid580 20150428 100000000000001 11000001 0.111001 0.122001
id588895 pid580 20150428 100000000000002 11000002 0.111002 0.122002
id588896 pid580 20150428 100000000000003 11000003 0.111003 0.122003
id588897 pid580 20150428 100000000000004 11000004 0.111004 0.122004
id588898 pid580 20150428 100000000000005 11000005 0.111005 0.122005
id588899 pid580 20150428 100000000000006 11000006 0.111006 0.122006
id588900 pid580 20150428 100000000000007 11000007 0.111007 0.122007