Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-generate-explanation.html
mysql> CALL sys.ML_EXPLAIN_TABLE(table_name, model_handle, output_table_name, [options]); Replace table_name, model_handle, and output_table_name with your own values. After training a classification model, you can query the default model ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-generate-prediction.html
mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace table_name, model_handle, and output_table_name with your own values. To generate predictions, use the sample data from the testing_data dataset. Even ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-score.html
mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); Replace table_name, target_column_name, model_handle, metric, score with your own values. After generating predictions and explanations, you can score ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explainers.html
After the ML_TRAIN routine, use the ML_EXPLAIN routine to train model explainers for AutoML. By default, the ML_TRAIN routine trains the Permutation Importance model explainer. Feature importance is presented as a value ranging from -1 to 1. A ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-viewing.html
To view the details for the models in your model catalog, query the MODEL_CATALOG table. Before You Begin Review the following: Create a Machine Learning Model The Model Catalog View Details for Your Models The following example queries model_id, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-predictions-ml-predict-row.html
mysql> SELECT sys.ML_PREDICT_ROW(@variable, ...), model_handle, options); Replace variable, model_handle, and options with your own values. ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON format. The following ...
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-data-split.html
mysql> CALL sys.TRAIN_TEST_SPLIT('table_name', 'target_column_name', options); Replace table_name, target_column_name, and options with your own values. You can automatically create training and testing datasets with the TRAIN_TEST_SPLIT routine.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-explanations.html
mysql> CALL sys.ML_EXPLAIN_TABLE(table_name, model_handle, output_table_name, [options]); Replace table_name, model_handle, and output_table_name with your own values. After training a regression model, you can query the default model explanation ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-predictions.html
mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace table_name, model_handle, and output_table_name with your own values. To generate predictions, use the sample data from the house_price_testing ...