Search Results
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-using-a-recommendation-model-similar-items.html
Before You Begin Review and complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Generate Predictions for a Recommendation Model Generating Similar Items When you run ML_PREDICT_TABLE to generate similar ... This topic describes how to generate recommendations for similar ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-using-a-recommendation-model-similar-users.html
Before You Begin Review and complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Generate Predictions for a Recommendation Model Generating Similar Users When you run ML_PREDICT_TABLE to generate similar ... This topic describes how to generate recommendations for similar ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-train-test-split.html
Two new tables in the same database are created with the following names: [original_table_name]_train [original_table_name]_test The split of the data between training and testing datasets depends on the machine learning task. Order the table by the ... The TRAIN_TEST_SPLIT routine automatically splits your data into training and testing ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/9.7/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/9.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-execute.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. Example The following example demonstrates how to create and populate a table using ...