Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. EXPLAIN Output Columns EXPLAIN Join Types EXPLAIN Extra Information EXPLAIN Output ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
The B-tree index that represents an entire table is known as the clustered index, which is organized according to the primary key columns. The nodes of a clustered index data structure contain the values of all columns in the row. The nodes of a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use different data types, subject to certain conditions. (This is true even if both ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Workaround: Consider using a non-string or non-BIT type column in the WHERE clause condition. Workaround: Use the BIT column in an expression or cast it to a different data type. Error number: 1026; Symbol: HW_ER_UNSUPPORTED_AGG_OVER_ENUM Message: ... The following list contains all current MySQL HeatWave errors in numerical ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
The table cannot exceed 10 GB, 100 million rows, or 1017 columns. target_column_name: The name of the target column containing ground truth values. If training an unsupervised Anomaly detection model (unlabeled data), set target_column_name to NULL.
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-train.html
The table cannot exceed 10 GB, 100 million rows, or 1017 columns. target_column_name: The name of the target column containing ground truth values. If training an unsupervised Anomaly detection model (unlabeled data), set target_column_name to NULL.
https://dev.mysql.com/doc/refman/8.4/en/insert.html
A row alias with one or more optional column aliases can be used with ON DUPLICATE KEY UPDATE to refer to the row to be inserted. If the ON DUPLICATE KEY UPDATE clause is used and a duplicate key causes an UPDATE to be performed instead, the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbscanfilter.html
Description This type represents a condition based on the comparison of a column value with some arbitrary value—that is, a bound condition. When used in comparisons with COND_EQ, COND_NE, COND_LT, COND_LE, COND_GT, or COND_GE, fixed-length ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified columns. This can be a constant ('{"a":1}'), a column (t1.json_data, given table t1 specified prior ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. LOAD DATA interprets all fields in ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...