Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-similar-items.html
This topic describes how to generate recommendations for similar items. For known items, the output includes a list of predicted items that have similar ratings and are appreciated by similar users. The predictions are expressed in cosine ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-similar-users.html
This topic describes how to generate recommendations for similar users. For known users, the output includes a list of predicted users that have similar behavior and taste. The predictions are expressed in cosine similarity, and range from 0, very ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-users-to-items.html
This topic describes how to generate recommended items for users. For known users and known items, the output includes a list of items that the user will most likely give a high rating and the predicted rating or ranking. For a new user, and an ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model.html
To generate predictions, use the sample data from the testing_dataset dataset. NULL values for any row in the users or items columns generates an error. Before You Begin Complete the following tasks: Prepare Data for a Recommendation Model Train a ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-limitations.html
LOAD DATA with ALGORITHM=BULK supports tables with at least one column with the VECTOR data type. If you attempt to load a table without at least one column with the VECTOR data type, an error occurs. LOAD DATA with ALGORITHM=BULK has the following ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement. It can do the following: Optimize the loading of data sorted by primary key. Use a second session to monitor bulk load progress: If the data is sorted, there is a single stage: ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-search.html
When you enter a query, GenAI performs a vector-based similarity search to retrieve similar content from the vector store and embedding tables available in the DB system. This helps the LLM to produce more relevant and accurate results for your ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-nl-sql.html
GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This feature collects information on the schemas, tables, and columns that you have access to, and then uses a Large ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
The ML_GENERATE routine uses the specified large language model (LLM) to generate text-based content as a response for the given natural-language query. As of MySQL 9.4.1, the ML_GENERATE lets you generate text-based responses for queries ...