{
    "query": "CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost`\nSQL SECURITY DEFINER VIEW `test_view`  AS\nselect `email_content`.`content_id` AS `content_id`,\n`email_content`.`brand_id` AS `brand_id` from `email_content`;",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost`\nSQL SECURITY DEFINER VIEW `test_view`  AS\nselect `email_content`.`content_id` AS `content_id`,\n`email_content`.`brand_id` AS `brand_id` from `email_content`;",
        "len": 211,
        "last": 211,
        "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": "ALGORITHM",
                    "value": "ALGORITHM",
                    "keyword": "ALGORITHM",
                    "type": 1,
                    "flags": 1,
                    "position": 7
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 16
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "UNDEFINED",
                    "value": "UNDEFINED",
                    "keyword": "UNDEFINED",
                    "type": 1,
                    "flags": 1,
                    "position": 17
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 26
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "DEFINER",
                    "value": "DEFINER",
                    "keyword": "DEFINER",
                    "type": 1,
                    "flags": 1,
                    "position": 27
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 34
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`root`@`localhost`",
                    "value": "root@localhost",
                    "keyword": null,
                    "type": 8,
                    "flags": 4,
                    "position": 35
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 53
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SQL SECURITY",
                    "value": "SQL SECURITY",
                    "keyword": "SQL SECURITY",
                    "type": 1,
                    "flags": 7,
                    "position": 54
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 66
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "DEFINER",
                    "value": "DEFINER",
                    "keyword": "DEFINER",
                    "type": 1,
                    "flags": 1,
                    "position": 67
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 74
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VIEW",
                    "value": "VIEW",
                    "keyword": "VIEW",
                    "type": 1,
                    "flags": 1,
                    "position": 75
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 79
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`test_view`",
                    "value": "test_view",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 80
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 91
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 93
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 95
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "select",
                    "value": "SELECT",
                    "keyword": "SELECT",
                    "type": 1,
                    "flags": 3,
                    "position": 96
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 102
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`email_content`",
                    "value": "email_content",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 103
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 118
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`content_id`",
                    "value": "content_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 119
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 131
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 132
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 134
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`content_id`",
                    "value": "content_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 135
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 147
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 148
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`email_content`",
                    "value": "email_content",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 149
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 164
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`brand_id`",
                    "value": "brand_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 165
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 175
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 176
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 178
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`brand_id`",
                    "value": "brand_id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 179
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 189
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "from",
                    "value": "FROM",
                    "keyword": "FROM",
                    "type": 1,
                    "flags": 3,
                    "position": 190
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 194
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`email_content`",
                    "value": "email_content",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 195
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 210
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 44,
            "idx": 44
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement",
                "name": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": null,
                    "table": "test_view",
                    "column": null,
                    "expr": "`test_view`",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "entityOptions": null,
                "fields": null,
                "with": null,
                "select": {
                    "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement",
                    "expr": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "email_content",
                            "column": "content_id",
                            "expr": "`email_content`.`content_id`",
                            "alias": "content_id",
                            "function": null,
                            "subquery": null
                        },
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "email_content",
                            "column": "brand_id",
                            "expr": "`email_content`.`brand_id`",
                            "alias": "brand_id",
                            "function": null,
                            "subquery": null
                        }
                    ],
                    "from": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "email_content",
                            "column": null,
                            "expr": "`email_content`",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        }
                    ],
                    "index_hints": null,
                    "partition": null,
                    "where": null,
                    "group": null,
                    "group_options": null,
                    "having": null,
                    "order": null,
                    "limit": null,
                    "procedure": null,
                    "into": null,
                    "join": null,
                    "union": [],
                    "end_options": null,
                    "options": {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                        "options": []
                    },
                    "first": 20,
                    "last": 41
                },
                "like": null,
                "partitionBy": null,
                "partitionsNum": null,
                "subpartitionBy": null,
                "subpartitionsNum": null,
                "partitions": null,
                "table": null,
                "return": null,
                "parameters": null,
                "body": [],
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "3": {
                            "name": "ALGORITHM",
                            "equals": true,
                            "expr": "UNDEFINED",
                            "value": "UNDEFINED"
                        },
                        "4": {
                            "name": "DEFINER",
                            "equals": true,
                            "expr": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": null,
                                "column": "root@localhost",
                                "expr": "`root`@`localhost`",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            },
                            "value": "`root`@`localhost`"
                        },
                        "5": {
                            "name": "SQL SECURITY",
                            "equals": false,
                            "expr": "DEFINER",
                            "value": "DEFINER"
                        },
                        "6": "VIEW"
                    }
                },
                "first": 0,
                "last": 42
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}