Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/dynamic-sql.html
This is true for working with collections and for working with relational tables. A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-data-sets.html
Data items can be read from the database using Collection.find(), Table.select() and Session.sql(). Collection.find() returns a data set with documents and Table.select() respectively Session.sql() return a data set with rows. execute(); var doc; ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/dynamic-sql.html
This is true for working with collections and for working with relational tables. A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-data-sets.html
Data items can be read from the database using Collection.find(), Table.select() and Session.sql(). Collection.find() returns a data set with documents and Table.select() respectively Session.sql() return a data set with rows. myColl = ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing only evaluates SQL statements in the SQL statement digest history that access existing tables. Autopilot Indexing does evaluate past SQL statements that access a table that has been dropped and recreated. Small InnoDB tables, with ... Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-column-limits.html
Any table with multiple columns wherein the aggregate data size is greater than 4 MB cannot be loaded to MySQL HeatWave. The maximum column limit for base relations, tables as loaded into MySQL HeatWave, is 1017. The column limit for intermediate ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
Base relation data depends on the table schema, number of rows in each table, and DML operations on a MySQL table. Features like Auto Zonemap and MySQL table partitions also impact the base relation data scanned by a query. MySQL HeatWave tracks ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). JSON_TABLE() Return data from a JSON expression as a relational table. What's Next Learn how to perform the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-change-propagation.html
As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled for the table. In previous versions of MySQL, RAPID_LOAD_POOL_TRANSACTIONAL indicates that change propagation is enabled for the table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
The rpd_query_stats table stores query compilation and execution statistics (the query history) for the last 1000 successfully executed queries. To view the MySQL HeatWave query history including query start time, end time, and wait time in the ...