{
    "query": "CREATE PROCEDURE doiterate(p1 INT)\nBEGIN\n  label1: LOOP\n    SET p1 = p1 + 1;\n    IF p1 < 10 THEN\n      ITERATE label1;\n    END IF;\n    LEAVE label1;\n  END LOOP label1;\n  SET @x = p1;\nEND",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "CREATE PROCEDURE doiterate(p1 INT)\nBEGIN\n  label1: LOOP\n    SET p1 = p1 + 1;\n    IF p1 < 10 THEN\n      ITERATE label1;\n    END IF;\n    LEAVE label1;\n  END LOOP label1;\n  SET @x = p1;\nEND",
        "len": 186,
        "last": 186,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "CREATE",
                    "value": "CREATE",
                    "keyword": "CREATE",
                    "type": 1,
                    "flags": 3,
                    "position": 0
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 6
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PROCEDURE",
                    "value": "PROCEDURE",
                    "keyword": "PROCEDURE",
                    "type": 1,
                    "flags": 3,
                    "position": 7
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 16
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "doiterate",
                    "value": "doiterate",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 17
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 26
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p1",
                    "value": "p1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 27
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 29
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INT",
                    "value": "INT",
                    "keyword": "INT",
                    "type": 1,
                    "flags": 11,
                    "position": 30
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 33
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 34
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "BEGIN",
                    "value": "BEGIN",
                    "keyword": "BEGIN",
                    "type": 1,
                    "flags": 1,
                    "position": 35
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 40
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "label1:",
                    "value": "label1:",
                    "keyword": null,
                    "type": 10,
                    "flags": 0,
                    "position": 43
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 50
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LOOP",
                    "value": "LOOP",
                    "keyword": "LOOP",
                    "type": 1,
                    "flags": 3,
                    "position": 51
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 55
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SET",
                    "value": "SET",
                    "keyword": "SET",
                    "type": 1,
                    "flags": 11,
                    "position": 60
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 63
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p1",
                    "value": "p1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 64
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 66
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 67
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 68
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p1",
                    "value": "p1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 69
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 71
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "+",
                    "value": "+",
                    "keyword": null,
                    "type": 2,
                    "flags": 1,
                    "position": 72
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 73
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "1",
                    "value": 1,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 74
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 75
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 76
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "IF",
                    "value": "IF",
                    "keyword": "IF",
                    "type": 1,
                    "flags": 35,
                    "position": 81
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 83
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p1",
                    "value": "p1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 84
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 86
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "<",
                    "value": "<",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 87
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 88
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "10",
                    "value": 10,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 89
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 91
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "THEN",
                    "value": "THEN",
                    "keyword": "THEN",
                    "type": 1,
                    "flags": 3,
                    "position": 92
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n      ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 96
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ITERATE",
                    "value": "ITERATE",
                    "keyword": "ITERATE",
                    "type": 1,
                    "flags": 3,
                    "position": 103
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 110
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "label1",
                    "value": "label1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 111
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 117
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 118
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "END",
                    "value": "END",
                    "keyword": "END",
                    "type": 1,
                    "flags": 1,
                    "position": 123
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 126
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "IF",
                    "value": "IF",
                    "keyword": "IF",
                    "type": 1,
                    "flags": 35,
                    "position": 127
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 129
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 130
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LEAVE",
                    "value": "LEAVE",
                    "keyword": "LEAVE",
                    "type": 1,
                    "flags": 3,
                    "position": 135
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 140
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "label1",
                    "value": "label1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 141
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 147
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 148
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "END",
                    "value": "END",
                    "keyword": "END",
                    "type": 1,
                    "flags": 1,
                    "position": 151
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 154
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LOOP",
                    "value": "LOOP",
                    "keyword": "LOOP",
                    "type": 1,
                    "flags": 3,
                    "position": 155
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 159
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "label1",
                    "value": "label1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 160
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 166
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 167
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SET",
                    "value": "SET",
                    "keyword": "SET",
                    "type": 1,
                    "flags": 11,
                    "position": 170
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 173
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "@x",
                    "value": "x",
                    "keyword": null,
                    "type": 8,
                    "flags": 1,
                    "position": 174
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 176
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 177
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 178
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p1",
                    "value": "p1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 179
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 181
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 182
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "END",
                    "value": "END",
                    "keyword": "END",
                    "type": 1,
                    "flags": 1,
                    "position": 183
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 73,
            "idx": 0
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": null,
    "errors": {
        "lexer": [],
        "parser": []
    }
}