how to use mysql iteration code example

Example: what does iterate do in mysql

-- MySQL

-- Iterate statement is used to skip the current loop iteration and
-- start a new iteration
[label]: LOOP
    ...
    -- terminate the loop
    IF condition THEN
        ITERATE [label];
    END IF;
    ...
END LOOP;