{ "query": "LOAD DATA INFILE '\/tmp\/test.txt' IGNORE\nINTO TABLE test\nPARTITION (p0, p1, p2)\nCHARACTER SET 'utf8'\nCOLUMNS TERMINATED BY ','\nLINES TERMINATED BY ';'\nIGNORE 1 LINES\n(col1, col2)\nSET @a = 1;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "PARSER_METHODS": [ "parseDelimiter", "parseWhitespace", "parseNumber", "parseComment", "parseOperator", "parseBool", "parseString", "parseSymbol", "parseKeyword", "parseLabel", "parseUnknown" ], "str": "LOAD DATA INFILE '\/tmp\/test.txt' IGNORE\nINTO TABLE test\nPARTITION (p0, p1, p2)\nCHARACTER SET 'utf8'\nCOLUMNS TERMINATED BY ','\nLINES TERMINATED BY ';'\nIGNORE 1 LINES\n(col1, col2)\nSET @a = 1;", "len": 189, "last": 189, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LOAD DATA", "value": "LOAD DATA", "keyword": "LOAD DATA", "type": 1, "flags": 7, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 9 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INFILE", "value": "INFILE", "keyword": "INFILE", "type": 1, "flags": 3, "position": 10 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 16 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'\/tmp\/test.txt'", "value": "\/tmp\/test.txt", "keyword": null, "type": 7, "flags": 1, "position": 17 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 32 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IGNORE", "value": "IGNORE", "keyword": "IGNORE", "type": 1, "flags": 3, "position": 33 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INTO", "value": "INTO", "keyword": "INTO", "type": 1, "flags": 3, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE", "value": "TABLE", "keyword": "TABLE", "type": 1, "flags": 3, "position": 45 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "test", "value": "test", "keyword": null, "type": 0, "flags": 0, "position": 51 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 55 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITION", "value": "PARTITION", "keyword": "PARTITION", "type": 1, "flags": 3, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 65 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 66 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p0", "value": "p0", "keyword": null, "type": 0, "flags": 0, "position": 67 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p1", "value": "p1", "keyword": null, "type": 0, "flags": 0, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 74 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p2", "value": "p2", "keyword": null, "type": 0, "flags": 0, "position": 75 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CHARACTER SET", "value": "CHARACTER SET", "keyword": "CHARACTER SET", "type": 1, "flags": 7, "position": 79 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 92 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'utf8'", "value": "utf8", "keyword": null, "type": 7, "flags": 1, "position": 93 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLUMNS", "value": "COLUMNS", "keyword": "COLUMNS", "type": 1, "flags": 1, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 107 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TERMINATED BY", "value": "TERMINATED BY", "keyword": "TERMINATED BY", "type": 1, "flags": 7, "position": 108 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 121 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "','", "value": ",", "keyword": null, "type": 7, "flags": 1, "position": 122 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LINES", "value": "LINES", "keyword": "LINES", "type": 1, "flags": 3, "position": 126 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TERMINATED BY", "value": "TERMINATED BY", "keyword": "TERMINATED BY", "type": 1, "flags": 7, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 145 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "';'", "value": ";", "keyword": null, "type": 7, "flags": 1, "position": 146 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 149 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IGNORE", "value": "IGNORE", "keyword": "IGNORE", "type": 1, "flags": 3, "position": 150 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 158 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LINES", "value": "LINES", "keyword": "LINES", "type": 1, "flags": 3, "position": 159 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 164 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 165 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "col1", "value": "col1", "keyword": null, "type": 0, "flags": 0, "position": 166 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 170 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "col2", "value": "col2", "keyword": null, "type": 0, "flags": 0, "position": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 176 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 177 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 181 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@a", "value": "a", "keyword": null, "type": 8, "flags": 1, "position": 182 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 184 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 185 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 186 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 187 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 188 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 64, "idx": 64 }, "DEFAULT_DELIMITER": ";", "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "STATEMENT_PARSERS": { "DESCRIBE": "PhpMyAdmin\\SqlParser\\Statements\\ExplainStatement", "DESC": "PhpMyAdmin\\SqlParser\\Statements\\ExplainStatement", "EXPLAIN": "PhpMyAdmin\\SqlParser\\Statements\\ExplainStatement", "FLUSH": "", "GRANT": "", "HELP": "", "SET PASSWORD": "", "STATUS": "", "USE": "", "ANALYZE": "PhpMyAdmin\\SqlParser\\Statements\\AnalyzeStatement", "BACKUP": "PhpMyAdmin\\SqlParser\\Statements\\BackupStatement", "CHECK": "PhpMyAdmin\\SqlParser\\Statements\\CheckStatement", "CHECKSUM": "PhpMyAdmin\\SqlParser\\Statements\\ChecksumStatement", "OPTIMIZE": "PhpMyAdmin\\SqlParser\\Statements\\OptimizeStatement", "REPAIR": "PhpMyAdmin\\SqlParser\\Statements\\RepairStatement", "RESTORE": "PhpMyAdmin\\SqlParser\\Statements\\RestoreStatement", "SET": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "SHOW": "PhpMyAdmin\\SqlParser\\Statements\\ShowStatement", "ALTER": "PhpMyAdmin\\SqlParser\\Statements\\AlterStatement", "CREATE": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "DROP": "PhpMyAdmin\\SqlParser\\Statements\\DropStatement", "RENAME": "PhpMyAdmin\\SqlParser\\Statements\\RenameStatement", "TRUNCATE": "PhpMyAdmin\\SqlParser\\Statements\\TruncateStatement", "CALL": "PhpMyAdmin\\SqlParser\\Statements\\CallStatement", "DELETE": "PhpMyAdmin\\SqlParser\\Statements\\DeleteStatement", "DO": "", "HANDLER": "", "INSERT": "PhpMyAdmin\\SqlParser\\Statements\\InsertStatement", "LOAD DATA": "PhpMyAdmin\\SqlParser\\Statements\\LoadStatement", "REPLACE": "PhpMyAdmin\\SqlParser\\Statements\\ReplaceStatement", "SELECT": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "UPDATE": "PhpMyAdmin\\SqlParser\\Statements\\UpdateStatement", "WITH": "PhpMyAdmin\\SqlParser\\Statements\\WithStatement", "DEALLOCATE": "", "EXECUTE": "", "PREPARE": "", "BEGIN": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "COMMIT": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "ROLLBACK": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "START TRANSACTION": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "PURGE": "PhpMyAdmin\\SqlParser\\Statements\\PurgeStatement", "LOCK": "PhpMyAdmin\\SqlParser\\Statements\\LockStatement", "UNLOCK": "PhpMyAdmin\\SqlParser\\Statements\\LockStatement" }, "KEYWORD_PARSERS": { "PARTITION BY": [], "SUBPARTITION BY": [], "_OPTIONS": { "class": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "field": "options" }, "_END_OPTIONS": { "class": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "field": "end_options" }, "INTERSECT": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "EXCEPT": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "UNION": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "UNION ALL": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "UNION DISTINCT": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "ALTER": { "class": "PhpMyAdmin\\SqlParser\\Components\\Expression", "field": "table", "options": { "parseField": "table" } }, "ANALYZE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "BACKUP": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "CALL": { "class": "PhpMyAdmin\\SqlParser\\Components\\FunctionCall", "field": "call" }, "CHECK": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "CHECKSUM": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "CROSS JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "DROP": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "fields", "options": { "parseField": "table" } }, "FORCE": { "class": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "field": "index_hints" }, "FROM": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "from", "options": { "field": "table" } }, "GROUP BY": { "class": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword", "field": "group" }, "HAVING": { "class": "PhpMyAdmin\\SqlParser\\Components\\Condition", "field": "having" }, "IGNORE": { "class": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "field": "index_hints" }, "INTO": { "class": "PhpMyAdmin\\SqlParser\\Components\\IntoKeyword", "field": "into" }, "JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "LEFT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "LEFT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "ON": { "class": "PhpMyAdmin\\SqlParser\\Components\\Expression", "field": "table", "options": { "parseField": "table" } }, "RIGHT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "RIGHT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "INNER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "FULL JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "FULL OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL LEFT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL RIGHT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL LEFT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL RIGHT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "STRAIGHT_JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "LIMIT": { "class": "PhpMyAdmin\\SqlParser\\Components\\Limit", "field": "limit" }, "OPTIMIZE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "ORDER BY": { "class": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword", "field": "order" }, "PARTITION": { "class": "PhpMyAdmin\\SqlParser\\Components\\ArrayObj", "field": "partition" }, "PROCEDURE": { "class": "PhpMyAdmin\\SqlParser\\Components\\FunctionCall", "field": "procedure" }, "RENAME": { "class": "PhpMyAdmin\\SqlParser\\Components\\RenameOperation", "field": "renames" }, "REPAIR": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "RESTORE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "SET": { "class": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "field": "set" }, "SELECT": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "expr" }, "TRUNCATE": { "class": "PhpMyAdmin\\SqlParser\\Components\\Expression", "field": "table", "options": { "parseField": "table" } }, "UPDATE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "USE": { "class": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "field": "index_hints" }, "VALUE": { "class": "PhpMyAdmin\\SqlParser\\Components\\Array2d", "field": "values" }, "VALUES": { "class": "PhpMyAdmin\\SqlParser\\Components\\Array2d", "field": "values" }, "WHERE": { "class": "PhpMyAdmin\\SqlParser\\Components\\Condition", "field": "where" } }, "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\LoadStatement", "OPTIONS": { "LOW_PRIORITY": 1, "CONCURRENT": 1, "LOCAL": 2 }, "FIELDS_OPTIONS": { "TERMINATED BY": [ 1, "expr" ], "OPTIONALLY": 2, "ENCLOSED BY": [ 3, "expr" ], "ESCAPED BY": [ 4, "expr" ] }, "LINES_OPTIONS": { "STARTING BY": [ 1, "expr" ], "TERMINATED BY": [ 2, "expr" ] }, "file_name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": null, "expr": "'\/tmp\/test.txt'", "alias": null, "function": null, "subquery": null, "file": "\/tmp\/test.txt" }, "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": "test", "column": null, "expr": "test", "alias": null, "function": null, "subquery": null }, "partition": { "@type": "PhpMyAdmin\\SqlParser\\Components\\ArrayObj", "raw": [ "p0", "p1", "p2" ], "values": [ "p0", "p1", "p2" ] }, "charset_name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": "utf8", "expr": "'utf8'", "alias": null, "function": null, "subquery": null }, "fields_options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": { "name": "TERMINATED BY", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": ",", "expr": "','", "alias": null, "function": null, "subquery": null }, "value": "','" } } }, "fields_keyword": "COLUMNS", "lines_options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": { "name": "TERMINATED BY", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": ";", "expr": "';'", "alias": null, "function": null, "subquery": null }, "value": "';'" } } }, "col_name_or_user_var": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": null, "expr": "(col1, col2)", "alias": null, "function": null, "subquery": null } ], "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "@a", "value": "1" } ], "ignore_number": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": null, "expr": "1", "alias": null, "function": null, "subquery": null }, "replace_ignore": "IGNORE", "lines_rows": "LINES", "CLAUSES": [], "END_OPTIONS": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 61 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }