{ "query": "CREATE OR REPLACE VIEW xviewmytable AS SELECT mytable.id AS id, mytable.personid AS personid FROM mytable WHERE (mytable.birth > '1990-01-19') GROUP BY mytable.personid ;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "CREATE OR REPLACE VIEW xviewmytable AS SELECT mytable.id AS id, mytable.personid AS personid FROM mytable WHERE (mytable.birth > '1990-01-19') GROUP BY mytable.personid ;", "len": 172, "last": 172, "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": "OR REPLACE", "value": "OR REPLACE", "keyword": "OR REPLACE", "type": 1, "flags": 7, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 17 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VIEW", "value": "VIEW", "keyword": "VIEW", "type": 1, "flags": 1, "position": 18 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "xviewmytable", "value": "xviewmytable", "keyword": null, "type": 0, "flags": 0, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 35 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 37 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 46 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "mytable", "value": "mytable", "keyword": null, "type": 0, "flags": 0, "position": 47 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 54 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 55 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 57 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 58 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 61 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 63 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 64 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "mytable", "value": "mytable", "keyword": null, "type": 0, "flags": 0, "position": 65 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "personid", "value": "personid", "keyword": null, "type": 0, "flags": 0, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 84 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "personid", "value": "personid", "keyword": null, "type": 0, "flags": 0, "position": 85 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 93 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 94 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 98 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "mytable", "value": "mytable", "keyword": null, "type": 0, "flags": 0, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 106 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 107 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 112 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 113 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "mytable", "value": "mytable", "keyword": null, "type": 0, "flags": 0, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 121 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "birth", "value": "birth", "keyword": null, "type": 0, "flags": 0, "position": 122 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 127 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ">", "value": ">", "keyword": null, "type": 2, "flags": 2, "position": 128 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 129 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'1990-01-19'", "value": "1990-01-19", "keyword": null, "type": 7, "flags": 1, "position": 130 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "GROUP BY", "value": "GROUP BY", "keyword": "GROUP BY", "type": 1, "flags": 7, "position": 144 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "mytable", "value": "mytable", "keyword": null, "type": 0, "flags": 0, "position": 153 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "personid", "value": "personid", "keyword": null, "type": 0, "flags": 0, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 53, "idx": 53 }, "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": "xviewmytable", "column": null, "expr": "xviewmytable", "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": "mytable", "column": "id", "expr": "mytable.id", "alias": "id", "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "mytable", "column": "personid", "expr": "mytable.personid", "alias": "personid", "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "mytable", "column": null, "expr": "mytable", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "mytable", "birth", "1990-01-19" ], "isOperator": false, "expr": "(mytable.birth > '1990-01-19')" } ], "group": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword", "type": null, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "mytable", "column": "personid", "expr": "mytable.personid", "alias": null, "function": null, "subquery": 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": 10, "last": 50 }, "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": { "2": "OR REPLACE", "6": "VIEW" } }, "first": 0, "last": 51 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }