Ответы получены от MySQL через X Protocol. Созданные программой учебные объекты после чтения удалены.
Строки и дополнительные наблюдения
{
"metadata": [
{
"class": "mysql_xdevapi\\ColumnResult",
"label": "adjustment",
"name": "adjustment",
"table_label": "mysql142_numbers_1e0ff86e07fe",
"table_name": "mysql142_numbers_1e0ff86e07fe",
"schema": "php_manual_x139",
"type": 19,
"length": 11,
"fractional_digits": 0,
"signed": true,
"padded": false,
"charset": null,
"collation": null
},
{
"class": "mysql_xdevapi\\ColumnResult",
"label": "stock",
"name": "stock",
"table_label": "mysql142_numbers_1e0ff86e07fe",
"table_name": "mysql142_numbers_1e0ff86e07fe",
"schema": "php_manual_x139",
"type": 19,
"length": 10,
"fractional_digits": 0,
"signed": false,
"padded": false,
"charset": null,
"collation": null
},
{
"class": "mysql_xdevapi\\ColumnResult",
"label": "price",
"name": "price",
"table_label": "mysql142_numbers_1e0ff86e07fe",
"table_name": "mysql142_numbers_1e0ff86e07fe",
"schema": "php_manual_x139",
"type": 0,
"length": 14,
"fractional_digits": 2,
"signed": true,
"padded": false,
"charset": null,
"collation": null
},
{
"class": "mysql_xdevapi\\ColumnResult",
"label": "external_id",
"name": "external_id",
"table_label": "mysql142_numbers_1e0ff86e07fe",
"table_name": "mysql142_numbers_1e0ff86e07fe",
"schema": "php_manual_x139",
"type": 20,
"length": 20,
"fractional_digits": 0,
"signed": false,
"padded": false,
"charset": null,
"collation": null
},
{
"class": "mysql_xdevapi\\ColumnResult",
"label": "note",
"name": "note",
"table_label": "mysql142_numbers_1e0ff86e07fe",
"table_name": "mysql142_numbers_1e0ff86e07fe",
"schema": "php_manual_x139",
"type": 21,
"length": 80,
"fractional_digits": 0,
"signed": false,
"padded": false,
"charset": "utf8mb4",
"collation": "utf8mb4_0900_ai_ci"
}
],
"row": {
"adjustment": -2,
"stock": 4,
"price": "1234567890.12",
"external_id": "18446744073709551615",
"note": null
},
"php_types": {
"adjustment": "int",
"stock": "int",
"price": "string",
"external_id": "string",
"note": "null"
},
"type_constants": {
"INT": 19,
"DECIMAL": 0,
"BIGINT": 20
}
}
Полный JSON результата, включая реальные идентификаторы, сохранён рядом в result.json.