| EXPORT_TRANSFER_ALL | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`xxxxxxxx`@`localhost` PROCEDURE `EXPORT_TRANSFER_ALL`(OUT json_result TEXT)
BEGIN
    DECLARE cursor_table_name VARCHAR(55);
    DECLARE is_xx TINYINT(1);
    DECLARE i INT DEFAULT 0;
    DECLARE nb_max INT DEFAULT 0;
    DECLARE res TINYINT(1) DEFAULT 0;


    DROP TABLE IF EXISTS `tmp_table_lists`;
    CREATE TEMPORARY TABLE `tmp_table_lists` (ID INT(1), EXPORT_TABLE_NAME VARCHAR(55), IS_XX_TABLE TINYINT(1) DEFAULT 0);



    INSERT INTO `tmp_table_lists` (ID, EXPORT_TABLE_NAME, IS_XX_TABLE) VALUES (1, 'xxx_study_export', 1);
    INSERT INTO `tmp_table_lists` (ID, EXPORT_TABLE_NAME) VALUES (2, 'x1_general_export'), (3, 'x1_detailed_export'),
                                                                 (4, 'x2_general_export'), (5, 'x2_detailed_export'),
                                                                 (6, 'x3_detailed_export'), (7, 'x3_detailed_export'),
                                                                 (8, 'x4_detailed_export'), (9, 'x4_detailed_export'),
                                                                 (10, 'x5_detailed_export'), (11, 'x5_detailed_export');
    SELECT COUNT(*) INTO nb_max from tmp_table_lists;
    SET json_result = '[';

    table_loop: LOOP
        set i = i + 1;
        set res = 0;
        SELECT EXPORT_TABLE_NAME, IS_XX_TABLE INTO cursor_table_name, is_xx FROM tmp_table_lists WHERE ID=i;
        CALL EXPORT_TRANSFER_VIEW_TO_TABLE(cursor_table_name, is_xx, res);
        SET json_result = CONCAT(json_result, '{exportTableName:', cursor_table_name, ',success:', IF(res = '1', "true", "false"), '}');
                SELECT SLEEP(130);
        IF i = nb_max THEN
            LEAVE table_loop;
        END IF;
        SET json_result = CONCAT(json_result, ',');
    END LOOP;

    SET json_result = CONCAT(json_result, ']');
    DROP TABLE IF EXISTS `tmp_table_lists`;
END | latin1               | latin1_swedish_ci    | utf8_general_ci    |