Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
User variables can be especially useful when you want to insert data from an XML file into table columns whose names do not match those of the XML fields. To write data from a table to an XML file, you can invoke the mysql client with the --xml and ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
If no instructions have been defined, this method attempts to insert a single interpret_exit_ok() method call prior to finalization. NdbInterpretedCode::load_const_null() Description This method is used to load a NULL value into a register. This ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
The bugfix for http://bugs.mysql.com/4937 (INSERT + SELECT + UNION ALL + DATE to VARCHAR(8) conversion problem) produced a conversion function which was a promising approach to the conversion problems. It did not take small numbers (absolute value ... 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
Method Buffer (words) Request message (words) interpret_exit_ok() 1 1 interpret_exit_nok() 1 1 interpret_exit_last_row() 1 1 NdbInterpretedCode Convenience Methods The methods described in this section can be used to insert multiple instructions ...
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/heatwave/en/mys-hw-bulk-load-mysql-server.html
The bulk load operation compares the records from the input CSV files and the existing table, and then inserts the data into the existing table so that it is sorted correctly. Support for bulk load into tables with existing data (non-empty tables) ... MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT routine, which automatically splits your data into training and testing datasets. For each class in the dataset, 80% of the samples goes into the training dataset, and the remaining goes into the testing ...Two new tables in the same database are created with the following names: [original_table_name]_train [original_table_name]_test The split of the data between training and testing datasets depends on the machine learning ...
https://dev.mysql.com/doc/internals/en/source-files-related-to-the-binary-log.html
rpl_injector.h /rpl_injector.cc: Contains the injector class that allows external insertions into the binary log. sql directory: log.h /log.cc: The high-level binary logging mechanism for organizing events into a sequence so that it becomes a binary ... This section describes the files in a MySQL source tree that are most relevent to binary log ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
This topic describes how to prepare your data for loading into MySQL HeatWave. Identify all of the tables that your queries access to ensure that you load all of them into MySQL HeatWave. If a query accesses a table that is not loaded into MySQL ...