Search Results
https://dev.mysql.com/doc/refman/8.4/en/with.html
The types of the CTE result columns are inferred from the column types of the nonrecursive SELECT part only, and the columns are all nullable. The use of COALESCE() avoids displaying NULL in the sum_price column on days for which no sales data occur ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-scoring-an-anomaly-detection-model.html
For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('anomaly_detection_semi_supervised_use_case', NULL); Score the model ... After generating predictions, you can score the model to assess its ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-train-test-split.html
TRAIN_TEST_SPLIT Syntax mysql> CALL sys.TRAIN_TEST_SPLIT ('table_name', 'target_column_name', [options | NULL]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['task', ... The TRAIN_TEST_SPLIT routine automatically ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
If a column only exists on the slave (or if application-specific logic ensures that only NULL values are inserted on the master), then the AUTOINCREMENT attribute can be used on the slave. If the slave has a non-NULL constraint (PK or NOT NULL), ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbeventoperation.html
Changed attribute values may be retrieved after Ndb::nextEvent() has returned a value other than NULL. A pointer to a value, such that: If the attribute value is not NULL, then the attribute value is returned in this parameter. If the attribute ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexscanoperation.html
Members Member names, types, and descriptions are shown in the following table: Table 2.47 IndexBound structure member names, types, and descriptions Name Type Description low_key const char* Row containing lower bound for scan (or NULL for scan ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine RAPID. This topic describes how to create ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI routine. Vector embeddings are a numerical representation of the text that capture the semantics of the data and relationships to other data. You ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine RAPID. This topic describes how to run a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine RAPID. This topic describes how to use the ...