Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/shell-automatic-code-execution-results.html
mysql-js> db.countryInfo.find().limit(1) [ { "GNP": 828, "IndepYear": null, "Name": "Aruba", "_id": "ABW", "demographics": { "LifeExpectancy": 78.4000015258789, "Population": 103000 }, "geography": { "Continent": "North America", "Region": ... When ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-data-sets.html
When the last data item has been read and fetchOne() is called again, a NULL value is returned. Operations that fetch data items return a cursor that can be used to consume those data items from the result set. Data items can be read from the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
The data set can be empty if, for example, fetchOne() returns NULL or fetchAll() returns an empty list. When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...The reason, expected storage footprint, and performance impact of each ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is useful if human-readable output is not required; when the output is consumed by a script, for example. If a target schema is not ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
The VARLEN Support column identifies functions that support variable-length encoded string columns. Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-add-task-log.html
The add_task_log routine add a log entry for the task with the specified ID. You can use this routine with an application-level task as well and it does not require an application-managed user ID. Syntax mysql> CALL mysql_tasks.add_task_log( IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask.html
The app_task routine returns information about a single application task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task( IN 'app_user_id' VARCHAR(255), IN 'task_id' ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-list.html
If the value is NULL, tasks of all types are included. The task_status_list routine returns a paginated list of task statuses. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR(36)) parameter specifies the unique task ID (UUID) of the task whose information is ...