Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/sql-crud-functions.html
The example assumes that the test schema exists and is assigned to the variable db, and that an empty table called my_table exists. The following SQL CRUD functions are available in X DevAPI. Table.insert() The Table.insert() method works like an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
Data placement keys are used to partition table data among MySQL HeatWave nodes when loading tables. Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among ...
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-arithmetic-operators.html
All arithmetic operators are supported with variable-length encoded string columns, see Section 5.8.1.4, “Encoding String Columns”.
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-logs.html
The app_task_logs routine returns a list of logs associated with an application-level task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_logs( IN 'app_user_id' VARCHAR(255), IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-brief.html
The app_task_status_brief routine returns the brief status of an application task, including a subset of information about the task and its last log entry. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR (36); Following are app_task_status parameters: app_user_id ...
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-logs.html
The task_logs routine returns a list of logs associated with a task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_logs( IN 'task_id' VARCHAR(36), IN 'newer_than_log_time' ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-brief.html
The task_status_brief routine returns the brief status of a task, including a subset of information about the task and its last log entry. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT ...