Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-row.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about training and loading models, see Train a Model and Load a Model. mysql> SELECT sys.ML_PREDICT_ROW(JSON_OBJECT( "age", census_train.`age`, "workclass", ... ML_PREDICT_ROW ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-a-forecasting-model.html
The ML_SCORE routine does not require a target_column_name for forecasting, so you can set it to NULL. 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 ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-genai-view-models.html
View Available Models 14.2.1 View Available Models As of MySQL 9.3.2, once you are connected to a DB System, you can view the list of available models and information on them with the ML_SUPPORTED_LLMS view inside the sys schema of the DB System: ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
Statement objects allow you to execute basic SQL queries and retrieve the results through the ResultSet class, which is described later. To create a Statement instance, you call the createStatement() method on the Connection object you have ...
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/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/8.4/en/gis-linestring-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_IsClosed() returns 0 if ls is not closed, and NULL ...You can extract particular points of a LineString, count the number of points that it contains, or obtain its ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. If the default value is NULL or was not specified, this column reports NULL. An explicitly specified non-NULL default ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
This can have values A (ascending), D (descending), or NULL (not sorted). That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. NULLABLE Contains YES if the column may contain NULL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. TRIGGER_SCHEMA The name of the schema ...