Search Results
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... INTO DUMPFILE writes a single row to a file without any formatting. A given SELECT statement can contain at most one INTO clause, although as shown ...Column and line terminators can be specified to produce a specific output ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
mysql> CREATE TABLE `iris_train` ( `sepal length` float DEFAULT NULL, `sepal width` float DEFAULT NULL, `petal length` float DEFAULT NULL, `petal width` float DEFAULT NULL, `class` varchar(16) DEFAULT NULL); Insert the training data into the table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
This section describes how to generate vector embeddings for files or folders stored in Object Storage, and load the embeddings into a vector store table. If not already done, create an Oracle Cloud Infrastructure (OCI) bucket for storing files ...
https://dev.mysql.com/doc/refman/8.4/en/load-index.html
| ALL } The LOAD INDEX INTO CACHE statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX statement, or into the default key cache otherwise. LOAD INDEX INTO CACHE applies only to MyISAM tables, ...tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-vector-store-load.html
This section describes how to generate vector embeddings for files or folders stored in , and load the embeddings into a vector store table. The following sections in this topic describe how to ingest files into a vector store: Before You Begin ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file ...ndb_import requires a connection to an NDB management server (ndb_mgmd) to function; it does not require a connection to a MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
MySQL HeatWave then converts the data into columnar format and sends it over the network to distribute it among MySQL HeatWave nodes in horizontal slices. The loading of data into MySQL HeatWave can be classified into three types: Initial Bulk Load, ... MySQL HeatWave provides the following methods to load data to MySQL HeatWave: Automatic loading: loads tables and partitions based on ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-loading-unloading-heatwave.html
Loading or Unloading Data into MySQL HeatWave Cluster 9.1 Loading or Unloading Data into MySQL HeatWave Cluster Use MySQL HeatWave Console to load data into or unload data from a MySQL HeatWave Cluster. The time required to load data from the DB ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-loading-table-maximum.html
Tip:You can use the MySQL HeatWave Autopilot to verify that there is sufficient memory to load the tables into your MySQL HeatWave Cluster. If the tables have more columns, fewer tables can be loaded. See Table 9-1 for the approximate maximum number ...