CqRrzHNr

1CREATE PROCEDURE control()
2BEGIN
3DECLARE tmp_nom_bd VARCHAR(30);
4DECLARE tmp_nom_taula VARCHAR(30);
5DECLARE tmp_num_registres INTEGER;
6DECLARE done TINYINT  DEFAULT 0;
7DECLARE  c1  CURSOR FOR  SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES;
8DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = true;
9DROP TABLE IF EXISTS taula_control;
10CREATE TABLE taula_control
11(
12nom_bd varchar(30),
13nom_taula varchar(30),
14num_registres integer
15);
16OPEN c1;
17c1_loop: LOOP
18FETCH c1 INTO tmp_nom_bd, tmp_nom_taula, tmp_num_registres;
19IF (done) THEN 
20       	LEAVE c1_loop;
21END IF;
22	INSERT INTO taula_control VALUES (tmp_nom_bd, tmp_nom_taula, tmp_num_registres); 
23END LOOP c1_loop;
24CLOSE c1;
25END