Write a stored procedure that loops from 1 to 10.

A stored procedure that loops from 1 to 10 can be written in MySQL as follows:

DELIMITER $$
CREATE PROCEDURE LoopOneToTen()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i <= 10 DO
        SELECT i;
        SET i = i + 1;
    END WHILE;
END$$
DELIMITER ;

Executing CALL LoopOneToTen(); will return a result set with the numbers 1 through 10. The procedure uses a DECLARE statement to initialize a counter, a WHILE loop to iterate, and a SELECT to output each value. This example illustrates basic loop control in MySQL stored procedures.