Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
Other partitioning types require a partitioning expression that yields an integer value or NULL. However, you can use other date and time functions that return an integer or NULL, such as WEEKDAY(), DAYOFYEAR(), or MONTH(). This section discusses ...
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.5/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.5/en/mys-ai-aml-training-an-anomaly-detection-model.html
If running an unsupervised model, the target_column_name parameter must be set to NULL. If running a semi-supervised model: The target_column_name parameter must specify a column whose only allowed values are 0 (normal), 1 (anomalous), and NULL ...
https://dev.mysql.com/doc/mysql-ai/9.5/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/heatwave-aws/en/heatwave-aws-copy-mysql-configuration.html
For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value). Copying a ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-create-mysql-configuration.html
For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value). Creating a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-select-all.html
Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-string Command-Line Format --connect-string=connection_string Type String Default ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
--binary-as-hex when enabled affects display of all binary strings, including those returned by functions such as CHAR() and UNHEX(). By default, mysql translates \r\n in statement strings to \n and interprets \0 as the statement terminator. mysql ...