Detail: procedimiento en mysql que inserta en una tabla cada 1s (sql)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
delimiter //



CREATE PROCEDURE insertasinparar (OUT param1 INT)

	BEGIN

		DECLARE cur1 CURSOR FOR SELECT nombre FROM prueba;

		DECLARE done INT DEFAULT 0;

		DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;



		OPEN cur1;

		REPEAT

			FETCH cur1 INTO a;

			IF NOT done THEN

			   INSERT INTO NOMBRE VALUES (NULL, CONCAT( a, NOW()), NOW());

			   SLEEP(500000);

			END IF;

		UNTIL done END REPEAT;



		CLOSE cur1;

    END

//

delimiter ;

[raw] - Pasted by: mamel on sql on Nov. 18, 2010