%PDF- %GIF98; %PNG; .
Cyber Programmer
Logo of a company Server : Apache
System : 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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/addictionfreeind/www/admin1/vendor/phpmyadmin/sql-parser/tests/data/parser/parseAlter9.out
{
    "query": "ALTER TABLE place CHANGE COLUMN plc_location_type gplc_location_type ENUM('LOCATION') CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL;",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "ALTER TABLE place CHANGE COLUMN plc_location_type gplc_location_type ENUM('LOCATION') CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL;",
        "len": 142,
        "last": 142,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ALTER",
                    "value": "ALTER",
                    "keyword": "ALTER",
                    "type": 1,
                    "flags": 3,
                    "position": 0
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 5
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "TABLE",
                    "value": "TABLE",
                    "keyword": "TABLE",
                    "type": 1,
                    "flags": 3,
                    "position": 6
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 11
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "place",
                    "value": "place",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 12
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 17
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "CHANGE",
                    "value": "CHANGE",
                    "keyword": "CHANGE",
                    "type": 1,
                    "flags": 3,
                    "position": 18
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 24
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "COLUMN",
                    "value": "COLUMN",
                    "keyword": "COLUMN",
                    "type": 1,
                    "flags": 3,
                    "position": 25
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 31
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "plc_location_type",
                    "value": "plc_location_type",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 32
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 49
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "gplc_location_type",
                    "value": "gplc_location_type",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 50
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 68
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENUM",
                    "value": "ENUM",
                    "keyword": "ENUM",
                    "type": 1,
                    "flags": 9,
                    "position": 69
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 73
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'LOCATION'",
                    "value": "LOCATION",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 74
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 84
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 85
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "CHARACTER SET",
                    "value": "CHARACTER SET",
                    "keyword": "CHARACTER SET",
                    "type": 1,
                    "flags": 7,
                    "position": 86
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 99
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'utf8'",
                    "value": "utf8",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 100
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 106
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "COLLATE",
                    "value": "COLLATE",
                    "keyword": "COLLATE",
                    "type": 1,
                    "flags": 3,
                    "position": 107
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 114
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'utf8_unicode_ci'",
                    "value": "utf8_unicode_ci",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 115
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 132
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NOT NULL",
                    "value": "NOT NULL",
                    "keyword": "NOT NULL",
                    "type": 1,
                    "flags": 7,
                    "position": 133
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 141
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 30,
            "idx": 30
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\AlterStatement",
                "table": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": null,
                    "table": "place",
                    "column": null,
                    "expr": "place",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "altered": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\AlterOperation",
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "CHANGE",
                                "2": "COLUMN"
                            }
                        },
                        "field": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": null,
                            "column": "plc_location_type",
                            "expr": "plc_location_type",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        },
                        "partitions": null,
                        "unknown": [
                            {
                                "@type": "@14"
                            },
                            {
                                "@type": "@15"
                            },
                            {
                                "@type": "@16"
                            },
                            {
                                "@type": "@17"
                            },
                            {
                                "@type": "@18"
                            },
                            {
                                "@type": "@19"
                            },
                            {
                                "@type": "@20"
                            },
                            {
                                "@type": "@21"
                            },
                            {
                                "@type": "@22"
                            },
                            {
                                "@type": "@23"
                            },
                            {
                                "@type": "@24"
                            },
                            {
                                "@type": "@25"
                            },
                            {
                                "@type": "@26"
                            },
                            {
                                "@type": "@27"
                            },
                            {
                                "@type": "@28"
                            },
                            {
                                "@type": "@29"
                            }
                        ]
                    }
                ],
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "3": "TABLE"
                    }
                },
                "first": 0,
                "last": 28
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}

VaKeR 2022