这样写时正确的: UPDATE test5 set Balance = 0.1+(SELECT Balance WHERE Tel = '12345678901') WHERE Tel = '12345678901'
注意: UPDATE test5 set Balance = 0.1+(SELECT Balance FROM test5 WHERE Tel = '12345678901') WHERE Tel = '12345678901' 这样写是不对的,那个FROM test5不能加
这样写时正确的: UPDATE test5 set Balance = 0.1+(SELECT Balance WHERE Tel = '12345678901') WHERE Tel = '12345678901'
注意: UPDATE test5 set Balance = 0.1+(SELECT Balance FROM test5 WHERE Tel = '12345678901') WHERE Tel = '12345678901' 这样写是不对的,那个FROM test5不能加