数据库重复执行sql语句

delimiter \\
CREATE PROCEDURE proc_while ()
BEGIN

    DECLARE num INT ;
		DECLARE ids INT;
    SET num = 0 ;
		SET ids = 100 ;
    WHILE num < 1000000 DO
        SELECT * from ocean_nav_menu where id=ids;
        SET num = num + 1 ;
				SET ids = ids - 1 ;
    END WHILE ;

END\\
delimiter ;