1

Loops allow stored programs to execute statements repetitively. The MySQL stored program language offers three types of loops:

  • Simple loops using the LOOP and END LOOP clauses
  • Loops that continue while a condition is true, using the WHILE and END WHILE clauses
  • Loops that continue until a condition is true, using the REPEAT and UNTIL clauses

With all three loop types, you terminate execution of the loop with the LEAVE statement.

Is there some kind of explanation as to why we don't need the definite article the coming after all but before three loop types? I think I have encountered this particular grammar structure before but at the time no one seemed to know the answer (but that was on the Yahoo question-answer service).

Yet another thing that bothers me here is why is there no the in front of execution? Like, you terminate THE execution of the loop with the LEAVE statement. Any thoughts?

Thank you.

1

With all three loop types, you terminate execution of the loop with the LEAVE statement.

There is nothing wrong with "all three". It's quite correct and is also more commonly used than "all the three". With the second, where you have a noun describing a process as opposed to an object (in this case the execution of a loop), it's quite common to leave out "the". Other examples: "after assembly", "during cooking", "rain stopped play", "the end of term".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.