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-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
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.