Search Results
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Note The rules table is loaded into the plugin by the flush_rewrite_rules stored procedure. Load operations (performed by invoking the flush_rewrite_rules() stored procedure) load the rule from the table into the Rewriter in-memory cache only if ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-single-file.html
It can also pack an existing backup directory into a single file, unpack the single file back to a backup directory, list the contents of a single-file backup, verify the contents of a single-file backup against embedded checksums, or extract a ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
It did not take small numbers (absolute value less than 1) and negative numbers into account. It did not take the limited precision of float and double data types into account. During my explorations of the code I didn't find places where float or ... The MySQL Reference Manual has a discussion of floating-point numbers in Section 11.2 Numeric Types, including details about the ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndbinterpretedcode-using.html
The space required by each of these methods is shown in the following table: Table 1.1 NdbInterpretedCode methods used to load constant values into NdbInterpretedCode program registers, with required buffer and request message space. The read_attr() ... The next few sections provide information about performing different types of operations with NdbInterpretedCode methods, including resource ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1010; Symbol: HW_ER_SUBQUERY_TRANSFORM Message: The subquery, [%s], cannot be transformed into a semi-join, anti-join or derived tables. Error number: 1069; Symbol: HW_ER_UNSUPPORTED_OPERATION_OVER_DERIVED_TABLE Message: Trying to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
INTO OUTFILE {URL | URI} 'uri' [FORMAT csv] [CHARACTER SET 'charset_name'] [HEADER {ON | OFF}] [{FIELDS | COLUMNS} [NULL AS 'null_char'] [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ... SELECT sum(l_quantity) from ... This topic shows the different ways to export query results as a CSV file with SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
After the data mapping is created, it allows the S3 data to be loaded into the Lakehouse table for querying by Lakehouse. Note: To map and load data into Lakehouse, the Amazon S3 bucket in which the data is located and the DB System must be in the ... Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 to a MySQL HeatWave Lakehouse ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-load-dump.html
MySQL Shell's dump loading utility util.loadDump() supports the import into a MySQL HeatWave Service DB System or a MySQL Server instance of schemas or tables dumped using MySQL Shell's Section 12.5, “Instance Dump Utility, Schema Dump Utility, ...The dump loading utility provides data streaming from remote storage, parallel loading of tables or table chunks, progress state tracking, resume and reset capability, and the option of concurrent loading while the dump is still taking ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...