Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
If you import a model object, model_metadata stores a JSON_OBJECT that contains key-value pairs of the metadata See Section 8.1.4, “ML_MODEL_IMPORT” to learn more. Model Metadata Details Query Model Metadata See Also Model Metadata Details ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-sharing.html
JSON_OBJECT sets key-value pairs for the database and table of the exported table to import. This topic describes how to grant other users access to a model you create. Before You Begin Share Your Models Export the Model to Share Set Up Other User ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-predictions-ml-predict-table.html
Some of these columns include: Prediction ml_results The input table does not have a primary key, and it does not have a column named _4aad19ca6e_pk_id. This is because ML_PREDICT_TABLE adds a column as the primary key with the name ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-data-split.html
Anomaly detection for log data: A split of data based on primary key values. options: Set the following options as needed as key-value pairs in JSON object format. You can automatically create training and testing datasets with the TRAIN_TEST_SPLIT ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-preparing-a-recommendation-model.html
mysql> CREATE TABLE training_dataset ( user_id VARCHAR(3), item_id VARCHAR(3), rating DECIMAL(3, 1), PRIMARY KEY (user_id, item_id) ); Insert the sample data to train into the table. mysql> CREATE TABLE testing_dataset ( user_id VARCHAR(3), item_id ... This topic describes how to prepare the data to use for a recommendation machine learning model using explicit ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-prepare.html
mysql> CREATE TABLE house_price_training ( id INT PRIMARY KEY, house_size INT, address TEXT, state TEXT, price INT ); Insert the sample data into the table. mysql> CREATE TABLE house_price_testing ( id INT PRIMARY KEY, house_size INT, address TEXT, ... This topic describes how to prepare the data to use for a regression machine learning ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-scoring-a-recommendation-model.html
It is a JSON object that has the table_name option as a key, which specifies the table that has item descriptions. It is a JSON object that has the table_name option as a key, which specifies the table that has user descriptions. After generating ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-recommendation-model.html
It is a JSON object that has the table_name option as a key, which specifies the table that has item descriptions. It is a JSON object that has the table_name option as a key, which specifies the table that has user descriptions. After preparing ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model.html
It is a JSON object that has the table_name option as a key, which specifies the table that has item descriptions. It is a JSON object that has the table_name option as a key, which specifies the table that has user descriptions. To generate ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-overview.html
Key Features In-Database LLM GenAI uses a large language model (LLM) to enable natural language communication in multiple languages. Some key benefits of using the GenAI feature of MySQL AI are: The natural-language processing (NLP) capabilities of ... The GenAI feature of MySQL AI lets you communicate with unstructured data using natural-language ...