{ "query": "UPDATE customer_table c\n\n INNER JOIN\n employee_table e\n ON c.city_id = e.city_id\n LEFT JOIN\n anyother_table a\n ON a.someID = e.someID\n\nSET c.active = \"Yes\"\nWHERE c.city = \"New york\";", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "UPDATE customer_table c\n\n INNER JOIN\n employee_table e\n ON c.city_id = e.city_id\n LEFT JOIN\n anyother_table a\n ON a.someID = e.someID\n\nSET c.active = \"Yes\"\nWHERE c.city = \"New york\";", "len": 204, "last": 204, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UPDATE", "value": "UPDATE", "keyword": "UPDATE", "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": "customer_table", "value": "customer_table", "keyword": null, "type": 0, "flags": 0, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 21 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INNER JOIN", "value": "INNER JOIN", "keyword": "INNER JOIN", "type": 1, "flags": 7, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 37 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "employee_table", "value": "employee_table", "keyword": null, "type": 0, "flags": 0, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 58 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "e", "value": "e", "keyword": null, "type": 0, "flags": 0, "position": 59 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON", "value": "ON", "keyword": "ON", "type": 1, "flags": 3, "position": 67 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "city_id", "value": "city_id", "keyword": null, "type": 0, "flags": 0, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 79 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 80 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "e", "value": "e", "keyword": null, "type": 0, "flags": 0, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 83 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "city_id", "value": "city_id", "keyword": null, "type": 0, "flags": 0, "position": 84 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 91 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LEFT JOIN", "value": "LEFT JOIN", "keyword": "LEFT JOIN", "type": 1, "flags": 7, "position": 94 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 103 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "anyother_table", "value": "anyother_table", "keyword": null, "type": 0, "flags": 0, "position": 110 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "a", "value": "a", "keyword": null, "type": 0, "flags": 0, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 126 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON", "value": "ON", "keyword": "ON", "type": 1, "flags": 3, "position": 133 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 135 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "a", "value": "a", "keyword": null, "type": 0, "flags": 0, "position": 136 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 137 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "someID", "value": "someID", "keyword": null, "type": 0, "flags": 0, "position": 138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 144 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 145 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 146 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "e", "value": "e", "keyword": null, "type": 0, "flags": 0, "position": 147 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 148 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "someID", "value": "someID", "keyword": null, "type": 0, "flags": 0, "position": 149 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 155 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 162 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "active", "value": "active", "keyword": null, "type": 0, "flags": 0, "position": 163 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 170 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\"Yes\"", "value": "Yes", "keyword": null, "type": 7, "flags": 2, "position": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 177 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 183 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 184 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 185 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "city", "value": "city", "keyword": null, "type": 0, "flags": 0, "position": 186 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 190 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 191 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 192 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\"New york\"", "value": "New york", "keyword": null, "type": 7, "flags": 2, "position": 193 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 203 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 63, "idx": 63 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\UpdateStatement", "tables": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "customer_table", "column": null, "expr": "customer_table", "alias": "c", "function": null, "subquery": null } ], "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "c.active", "value": "\"Yes\"" } ], "where": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "c", "city", "New york" ], "isOperator": false, "expr": "c.city = \"New york\"" } ], "order": null, "limit": null, "join": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "type": "INNER", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "employee_table", "column": null, "expr": "employee_table", "alias": "e", "function": null, "subquery": null }, "on": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "c", "city_id", "e" ], "isOperator": false, "expr": "c.city_id = e.city_id" } ], "using": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "type": "LEFT", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "anyother_table", "column": null, "expr": "anyother_table", "alias": "a", "function": null, "subquery": null }, "on": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "a", "someID", "e" ], "isOperator": false, "expr": "a.someID = e.someID" } ], "using": null } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 60 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }