Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-explanations-ml-explain-row.html
ML_EXPLAIN_ROW explains predictions for one or more rows of unlabeled data. The following example trains a dataset with the classification machine learning task. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-explanations-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. We recommend limiting the input table to a maximum of 100 rows. If the input table has more than ten columns, limit it to ten rows. Some of these columns include: ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-predictions-ml-predict-row.html
ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON format. The following example trains a dataset with the classification machine learning task. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-predictions-ml-predict-table.html
ML_PREDICT_TABLE generates predictions for an entire table of trained data. If ML_PREDICT_TABLE takes a long time to complete, manually limit input tables to a maximum of 1,000 rows. Some of these columns include: Prediction ml_results The input ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-regression-predictions.html
To generate predictions, use the sample data from the house_price_testing dataset. Even though the table has labels for the price target column, the column is not considered when generating predictions. This allows you to compare the predictions to ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-regression-train.html
After preparing the data for a regression model, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for a Regression Model. Training the Model Train the model with the ML_TRAIN routine and use the ...
https://dev.mysql.com/doc/mysql-ai/9.4/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.4/en/mys-ai-aml-topic-modeling-train.html
After preparing the data for topic modeling, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for Topic Modeling. Requirements for Topic Modeling Training Define the following required parameters for topic ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-forecasting-model.html
To generate predictions, use the sample data from the electricity_demand_test dataset. Even though the table has labels for the demand target column, the column is not considered when generating predictions. This allows you to compare the ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-ratings-rankings.html
This topic describes how to generate recommendations for either ratings (recommendation model with explicit feedback) or rankings (recommendation model with implicit feedback). If generating a rating, the output predicts the rating the user will ...