Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-ratings-rankings.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('recommendation_use_case', NULL); Make predictions for the test ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine. Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example ...
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit Default Handling If a data type specification includes no explicit DEFAULT value, MySQL determines the default value as follows: If the column can ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
In some cases (for example, the ROUTINE_DEFINITION column in the INFORMATION_SCHEMA ROUTINES table), users who have insufficient privileges see NULL. If this field is NULL, it means that the value of the column is always NULL. INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
A NULL row in each error summary table is used to aggregate statistics for all errors that lie out of range of the instrumented errors. For example, if MySQL Server errors lie in the range from M to N and an error is raised with number Q not in that ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-shapes.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_Crosses() handles its arguments as described in the ... The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
mysqlx_ssl_ca Command-Line Format --mysqlx-ssl-ca=file_name System Variable mysqlx_ssl_ca Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value NULL The mysqlx_ssl_ca system variable is like ssl_ca, except that it applies to X ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...