New consult... Why this period of cycle finally can only output one row, three rows in MySQL can detect...

CodePudding user response:

In the outer loop execution sql3 rs cycle, and with the rs execute sql4, rs information has changed, also can ensure the outer loop?

CodePudding user response:

The rs is replaced by the execution result of sql4

CodePudding user response:

reference 1st floor qybao response:

in execution of the outer loop sql3 rs cycle, and with the rs execute sql4, rs information changed, also can ensure the outer loop?

Thanks for elder brother see