The MySQL statement used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test is:
A)DECLARE.
B)BEGIN.
C)IF...THEN...ELSE...END IF.
D)REPEAT.
E)END.

Question

Quizplus · Accepted Answer

The correct statement to test for a condition and direct the flow of code is the IF...THEN...ELSE...END IF statement. It allows us to test a condition and execute the appropriate block of code based on the outcome of the test. The other options are not used for conditional programming in MySQL.

The MySQL Statement Used to Test for a Condition and Then