{ "query": "SELECT `one space` -- this is the SELECT\n FROM `Une table espace` -- this is the FROM\n ORDER BY `one space` ASC -- this is the order by", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "SELECT `one space` -- this is the SELECT\n FROM `Une table espace` -- this is the FROM\n ORDER BY `one space` ASC -- this is the order by", "len": 143, "last": 144, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "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": "`one space`", "value": "one space", "keyword": null, "type": 8, "flags": 2, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 18 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- this is the SELECT", "value": "-- this is the SELECT", "keyword": null, "type": 4, "flags": 4, "position": 20 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 41 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 46 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`Une table espace`", "value": "Une table espace", "keyword": null, "type": 8, "flags": 2, "position": 51 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- this is the FROM", "value": "-- this is the FROM", "keyword": null, "type": 4, "flags": 4, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 90 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ORDER BY", "value": "ORDER BY", "keyword": "ORDER BY", "type": 1, "flags": 7, "position": 95 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 103 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`one space`", "value": "one space", "keyword": null, "type": 8, "flags": 2, "position": 104 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ASC", "value": "ASC", "keyword": "ASC", "type": 1, "flags": 3, "position": 116 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 119 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- this is the order by", "value": "-- this is the order by", "keyword": null, "type": 4, "flags": 4, "position": 120 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 20, "idx": 20 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "one space", "expr": "`one space`", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "Une table espace", "column": null, "expr": "`Une table espace`", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": null, "group_options": null, "having": null, "order": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "one space", "expr": "`one space`", "alias": null, "function": null, "subquery": null }, "type": "ASC" } ], "limit": null, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 18 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }