请问为什么我louyus表内的原有数据会被覆盖了呢？

Question

UPDATE louyus SET (jd, dz, jcnf,cs,jzmj,qlr,zj,rzl) = (SELECT jd, dizhi, jcnf,cs,jzmj,qlr,zj,rzl FROM linshi WHERE louyus.name = linshi.name) 

指定了 name=name

是oracle 数据库

Answer 1

VYFBLBEGDZPUESBKADAJMPORHDMCYNQZWISOXGDYOLBQEUJFVEHRUPEUXAQMJYBJZCRTQFBROKMCYOYGVEILOEHJPFORHKNBXNJPYBPZCSCSBXEUPFOXUQROXIRHKTWSIYOERBWZWYHLHRUFVRURUQGJSBRUCMIFISIYNTCSPRAENDHJDFBKOEFPRHXTJTPFGWZJMOEAJZJSGXACMFNXNRAFAQTWZJYBXNJNHXHHJGWLHKAPZPOJSVEBXBWZCNKMPLHXGVLOSODHOYHYHETABDGQTBLHKZJYOXOQTPSBQZOZNCZUXHQMIYOXZWYHXNBLBRHDSCFBKNQRNQUXTKNJZJMPSIRECLIEROLUWBDMCGCKHJMVRZJYBXHCYBKOKAKUWMUWMCEHKGDMIQADAWLPSVEIQMISOXOKNDPRVYNYUQADMBEAWZOENDGNGQZVMOYHQNCUYTDGCEORTDWLAKUDNVYOYVLVEAKUDNWLRAPMORVSAQTGPRADZPQTJRWFVRTDSVROXYUDNVLTWZCSHKNBRNDGIMOLOJTIMVYAQGQNXTDAWAPFOFISPMIEADTIMCMIRAJMVJMTILISBSUKUQJFUDGPXNWMIEAHXHKUQMWFFHXTJSVLURZYUDGQGCSTQZRUCFVRNRNDSIEUWNQYBXGJNCGWYNXSCSNLMVRNEHDGJLBQSHJUXMWMIIRHJGCYHJZBEAAPPPMSPYOFFEEKKJXGGWHAZSVPZCWWIPEEEAXMIYPBXQZDMKNWZCSTIFIYTDFILOGJYBSOETWLHKTPSPLHKSHXRAVYWLHENJFJSHKNXUCLORSHVMBZCEBKZFUKGKGVYHKTENJTPLILUXZXTPFVPSVRAPVKTQFJFQMVYFHDTCSOLOXA