Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/www/admin1/vendor/phpmyadmin/sql-parser/tests/data/parser/ |
Upload File : |
{
"query": "DELETE LOW_PRIORITY\n/* */\nFROM\n `test`.users\nWHERE\n `id`<3 AND (username=\"Dan\" or username=\"Paul\")\nORDER BY\n id\n;",
"lexer": {
"@type": "PhpMyAdmin\\SqlParser\\Lexer",
"str": "DELETE LOW_PRIORITY\n/* */\nFROM\n `test`.users\nWHERE\n `id`<3 AND (username=\"Dan\" or username=\"Paul\")\nORDER BY\n id\n;",
"len": 122,
"last": 122,
"list": {
"@type": "PhpMyAdmin\\SqlParser\\TokensList",
"tokens": [
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DELETE",
"value": "DELETE",
"keyword": "DELETE",
"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": "LOW_PRIORITY",
"value": "LOW_PRIORITY",
"keyword": "LOW_PRIORITY",
"type": 1,
"flags": 3,
"position": 7
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 19
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "/* */",
"value": "/* */",
"keyword": null,
"type": 4,
"flags": 2,
"position": 20
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 25
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "FROM",
"value": "FROM",
"keyword": "FROM",
"type": 1,
"flags": 3,
"position": 26
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 30
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`test`",
"value": "test",
"keyword": null,
"type": 8,
"flags": 2,
"position": 35
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ".",
"value": ".",
"keyword": null,
"type": 2,
"flags": 16,
"position": 41
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "users",
"value": "users",
"keyword": null,
"type": 0,
"flags": 0,
"position": 42
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 47
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "WHERE",
"value": "WHERE",
"keyword": "WHERE",
"type": 1,
"flags": 3,
"position": 48
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 53
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`id`",
"value": "id",
"keyword": null,
"type": 8,
"flags": 2,
"position": 58
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "<",
"value": "<",
"keyword": null,
"type": 2,
"flags": 2,
"position": 62
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "3",
"value": 3,
"keyword": null,
"type": 6,
"flags": 0,
"position": 63
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 64
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "AND",
"value": "AND",
"keyword": "AND",
"type": 1,
"flags": 3,
"position": 65
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 68
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 69
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "username",
"value": "username",
"keyword": null,
"type": 0,
"flags": 0,
"position": 70
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 78
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\"Dan\"",
"value": "Dan",
"keyword": null,
"type": 7,
"flags": 2,
"position": 79
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 84
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "or",
"value": "OR",
"keyword": "OR",
"type": 1,
"flags": 3,
"position": 85
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 87
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "username",
"value": "username",
"keyword": null,
"type": 0,
"flags": 0,
"position": 88
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 96
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\"Paul\"",
"value": "Paul",
"keyword": null,
"type": 7,
"flags": 2,
"position": 97
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 103
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 104
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "ORDER BY",
"value": "ORDER BY",
"keyword": "ORDER BY",
"type": 1,
"flags": 7,
"position": 105
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 113
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "id",
"value": "id",
"keyword": null,
"type": 0,
"flags": 0,
"position": 118
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 120
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ";",
"value": ";",
"keyword": null,
"type": 9,
"flags": 0,
"position": 121
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": null,
"value": null,
"keyword": null,
"type": 9,
"flags": 0,
"position": null
}
],
"count": 38,
"idx": 38
},
"delimiter": ";",
"delimiterLen": 1,
"strict": false,
"errors": []
},
"parser": {
"@type": "PhpMyAdmin\\SqlParser\\Parser",
"list": {
"@type": "@1"
},
"statements": [
{
"@type": "PhpMyAdmin\\SqlParser\\Statements\\DeleteStatement",
"from": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": "test",
"table": "users",
"column": null,
"expr": "`test`.users",
"alias": null,
"function": null,
"subquery": null
}
],
"join": null,
"using": null,
"columns": null,
"partition": null,
"where": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"id"
],
"isOperator": false,
"expr": "`id`<3"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "AND"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"username",
"Dan"
],
"isOperator": false,
"expr": "(username=\"Dan\""
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [],
"isOperator": true,
"expr": "OR"
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
"identifiers": [
"username",
"Paul"
],
"isOperator": false,
"expr": "username=\"Paul\")"
}
],
"order": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword",
"expr": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "id",
"expr": "id",
"alias": null,
"function": null,
"subquery": null
},
"type": "ASC"
}
],
"limit": null,
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": {
"1": "LOW_PRIORITY"
}
},
"first": 0,
"last": 35
}
],
"brackets": 0,
"strict": false,
"errors": []
},
"errors": {
"lexer": [],
"parser": []
}
}