Batch cycle do the following this statement, but only recently discovered three data auto_fw10_c003 this field modification is successful, auto_fw10_c002 didn't modify success, haven't find the problem, is there anyone who encountered similar problems, explain the reason,
Update auto_flow_010 set auto_fw10_c002='$1742 p_flowst_3 $0, auto_fw10_c003=' $1743 p_flowst_3 $0 'where auto_fw10_id=@ v_pkval

CodePudding user response:

Can't appear this kind of circumstance, either all success or failure

CodePudding user response:

I know that's not the case, but now I really appeared, the SQL has been used for several years, recently found to have several data is wrong, so it was very strange, don't know where to look

CodePudding user response:

Is there a trigger?

CodePudding user response:

On the condition of with you? Do you have any query over