Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
If training an unsupervised Anomaly detection model (unlabeled data), set target_column_name to NULL. Forecasting does not require target_column_name, and it can be set to NULL. If no options are specified, you can specify NULL in place of the JSON ... Run the ML_TRAIN routine on a training dataset to produce a trained machine learning ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
Here's an example from the EXAMPLE storage engine: handlerton example_hton= { "EXAMPLE", SHOW_OPTION_YES, "Example storage engine", DB_TYPE_EXAMPLE_DB, NULL, /* Initialize */ 0, /* slot */ 0, /* savepoint size. The handlerton (short for handler ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
For a join based on the <=> comparison operator, NULL is not treated differently from any other value: NULL <=> NULL, just as N <=> N for any other N. However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.4/en/all-subqueries.html
The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The expression is unknown (that is, NULL) if table t2 contains (0,NULL,1). The expression is TRUE if table t2 ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note A user variable used to ...Note It is possible to obtain XML-formatted output from MySQL in the mysql and mysqldump clients by invoking them with the --xml ...
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. Before attempting to use this method, you should have read the explanations provided in Ndb::nextEvent() (DEPRECATED), and ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. Retrained attributes are NULL (or NOT NULL) and, ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
If the options argument is NULL, the return value is NULL. mysql> SET @g = "MULTILINESTRING((10 10, 11 11), (9 9, 10 10))"; mysql> SELECT ST_AsText(ST_GeomCollFromText(@g)); +--------------------------------------------+ | ... These functions take ...