Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-score.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('classification_use_case', NULL); Score the model with the ML_SCORE routine and use the accuracy metric. mysql> CALL ... After ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-train.html
mysql> SET @variable = 'model_handle'; Replace @variable and model_handle with your own definitions. For example: mysql> SET @model='classification_use_case'; The model handle is set to classification_use_case. mysql> CALL sys.ML_TRAIN('table_name', ... After preparing the data for a classification model, you can train the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-load-model.html
A model can only be loaded by the MySQL user that created the model unless you grant access to other users. The following example loads an AutoML model from the model catalog by using the session variable mysql> CALL sys.ML_MODEL_LOAD(@census_model, ... You must load a machine learning model from the model catalog before running AutoML routines other than ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-handles.html
In the following example, @census_model is defined as the model handle session variable with no set model handle name: mysql> CALL sys.ML_TRAIN('heatwaveml_bench.census_train', 'revenue', JSON_OBJECT('task', 'classification'), @census_model); While ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-score.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('regression_use_case', NULL); Score the model with the ML_SCORE routine and use the r2 metric. mysql> CALL ... After generating ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-regression-train.html
mysql> SET @variable = 'model_handle'; Replace @variable and model_handle with your own definitions. For example: mysql> SET @model='regression_use_case'; The model handle is set to regression_use_case. mysql> CALL sys.ML_TRAIN('table_name', ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-scoring-a-forecasting-model.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('forecasting_use_case', NULL); Score the model with the ML_SCORE routine and use the neg_sym_mean_abs_percent_error metric.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-scoring-a-recommendation-model.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Score the model with the ML_SCORE routine and use the precision_at_k metric. mysql> CALL ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling-train.html
mysql> SET @variable = 'model_handle'; Replace @variable and model_handle with your own definitions. For example: mysql> SET @model='topic_modeling_use_case'; The model handle is set to topic_modeling_use_case. mysql> CALL sys.ML_TRAIN('table_name', ... After preparing the data for topic modeling, you can train the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-forecasting-model.html
mysql> SET @variable = 'model_handle'; Replace @variable and model_handle with your own definitions. For example: mysql> SET @model='forecasting_use_case'; The model handle is set to forecasting_use_case. mysql> CALL sys.ML_TRAIN('table_name', ...