Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-predictions-ml-predict-table.html
mysql> SELECT * FROM table_name LIMIT N; Replace table_name with your own table name, and N with the number of rows from the table you want to view. ML_PREDICT_TABLE generates predictions for an entire table of trained data. If ML_PREDICT_TABLE ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-a-forecasting-model.html
mysql> CREATE TABLE electricity_demand_train AS SELECT * FROM electricity_demand WHERE date < '2025-01-01'; Create the table to use for generating predictions. mysql> CREATE TABLE electricity_demand_test AS SELECT * FROM electricity_demand WHERE ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-predictions.html
If needed, you can also query all the columns from the table (SELECT * FROM house_price_predictions) to review all the data at once. To generate predictions, use the sample data from the house_price_testing dataset. Even though the table has labels ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-score.html
mysql> SELECT @regression_score; +--------------------+ | @regression_score | +--------------------+ | 0.8524690866470337 | +--------------------+ 1 row in set (0.0453 sec) If done working with the model, unload it with the ML_MODEL_UNLOAD routine.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-scoring-a-forecasting-model.html
mysql> SELECT @forecasting_score; +----------------------+ | @forecasting_score | +----------------------+ | -0.06810028851032257 | +----------------------+ If done working with the model, unload it with the ML_MODEL_UNLOAD routine. After ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-scoring-a-recommendation-model.html
mysql> SELECT @recommendation_score; +-----------------------+ | @recommendation_score | +-----------------------+ | 0.23333333432674408 | +-----------------------+ If done working with the model, unload it with the ML_MODEL_UNLOAD routine. After ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling-prediction.html
After training the model, you can run topic modeling on the trained text. To run topic modeling, use the sample data from the movies dataset. When the output table generates, you can review the generated word groups and expressions for the trained ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-load.html
After the task is completed, verify that embeddings are loaded in the vector store table: mysql> SELECT COUNT(*) FROM VectorStoreTableName; For example: mysql> SELECT COUNT(*) FROM demo_embeddings; If you see a numerical value in the output, your ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-aiaml-error-messages.html
Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Each error message includes an error number, SQLSTATE value, and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-hw-genai-troubleshoot.html
This section describes some commonly encountered issues and errors for GenAI and their workarounds. The folder you are trying to load might contain unsupported format files or the file that you are trying to load might be of an unsupported format.