VAkUPfgN

1
2DELIMITER $$
3
4CREATE PROCEDURE `createfragTable`()
5BEGIN
6
7    DECLARE ii INT DEFAULT 0;
8
9    DROP TABLE IF EXISTS fragme;
10    CREATE  TABLE fragme (
11      `id` INT NOT NULL AUTO_INCREMENT ,
12      `col0` BLOB NULL ,
13      `col1` BLOB NULL ,
14      `col2` BLOB NULL ,
15      `col3` BLOB NULL ,
16      `col4` BLOB NULL ,
17      `col5` BLOB NULL ,
18      `col6` BLOB NULL ,
19      `col7` BLOB NULL ,
20      `col8` BLOB NULL ,
21      `col9` BLOB NULL ,
22      PRIMARY KEY (`id`) 
23    );
24 
25    -- seed the table
26    INSERT INTO fragme (col0,col1,col2,col3,col4,col5,col6,col7,col8,col9)
27    SELECT UUID(), UUID(),UUID(),UUID(),UUID(),UUID(),UUID(),UUID(),UUID(),UUID()
28    ;
29
30    WHILE ii <= 20 DO
31        INSERT INTO fragme (col0,col1,col2,col3,col4,col5,col6,col7,col8,col9)
32        SELECT col0,col1,col2,col3,col4,col5,col6,col7,col8,col9 
33        FROM fragme
34        ;
35        SET ii = ii + 1;
36    END WHILE;
37
38
39END
40$$
41
42DELIMITER ;
43
44call createfragTable();
45DELETE FROM fragme
46WHERE id % 2 = 0;