{ "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": 207, "last": 207, "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", "value": "root", "keyword": null, "type": 0, "flags": 0, "position": 35 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@localhost", "value": "localhost", "keyword": null, "type": 8, "flags": 1, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 49 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SQL SECURITY", "value": "SQL SECURITY", "keyword": "SQL SECURITY", "type": 1, "flags": 7, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 62 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFINER", "value": "DEFINER", "keyword": "DEFINER", "type": 1, "flags": 1, "position": 63 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VIEW", "value": "VIEW", "keyword": "VIEW", "type": 1, "flags": 1, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 75 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`test_view`", "value": "test_view", "keyword": null, "type": 8, "flags": 2, "position": 76 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 87 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 89 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 91 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "select", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 92 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 98 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`email_content`", "value": "email_content", "keyword": null, "type": 8, "flags": 2, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`content_id`", "value": "content_id", "keyword": null, "type": 8, "flags": 2, "position": 115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 127 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 128 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 130 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`content_id`", "value": "content_id", "keyword": null, "type": 8, "flags": 2, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 144 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`email_content`", "value": "email_content", "keyword": null, "type": 8, "flags": 2, "position": 145 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`brand_id`", "value": "brand_id", "keyword": null, "type": 8, "flags": 2, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`brand_id`", "value": "brand_id", "keyword": null, "type": 8, "flags": 2, "position": 175 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 185 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "from", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 186 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 190 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`email_content`", "value": "email_content", "keyword": null, "type": 8, "flags": 2, "position": 191 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 206 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 45, "idx": 45 }, "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": 21, "last": 42 }, "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", "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": 43 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }