Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. As with table partitioned by RANGE, ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be loaded. Defining RAPID as the secondary engine for tables that ...Requirements and Privileges for Auto Parallel Load To run Auto Parallel Load in normal mode, the MySQL HeatWave Cluster must be ...
https://dev.mysql.com/doc/refman/9.7/en/load-data.html
INTO Statement”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE).
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
This section provides information about the Column class, which models a column in an NDBCLUSTER table. Column::getColumnNo() Description This method gets the sequence number of a column within its containing table or index. If the column is part ...The NDB API provides no support for constructing such formats; however, they are checked by the NDB ...
https://dev.mysql.com/doc/refman/9.7/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/9.7/en/insert-select.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, which ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
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. To set up a new vector store using an object URI, perform the following steps: To create the ...If not already done, create an Oracle Cloud Infrastructure (OCI) bucket for storing files that you want to ingest into the vector ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 9.7, enabling innodb_read_only prevents these operations for all storage ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
table_name: The name of the table that contains the labeled training dataset. The table name must be valid and fully qualified, so it must include the database name, database_name.table_name. The table cannot exceed 10 GB, 100 million rows, or 1017 ... Run the ML_TRAIN routine on a training dataset to produce a trained machine learning ...