-- MySQL PL-LOOP Benchmark - SQL script
-- v.1.0.0 
-- Copyright (C) 2011 email@meo.bogliolo.name

use test
DROP PROCEDURE IF EXISTS ciclo_1M;
DELIMITER '/';

CREATE PROCEDURE ciclo_1M()
BEGIN 
 declare       i int default 0;
 declare       c int;

while i < 1000000 do
    select count(*) into c from dual;
end while;

END/
DELIMITER ';'/

call ciclo1M();