Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL AI 9.7
Preface and Legal Notices
Introduction to MySQL AI
Installing MySQL AI
Loading Data in MySQL AI
Training and Using Machine Learning Models
About AutoML
AutoML Ease of Use
AutoML Workflow
AutoML Learning Types
Oracle AutoML
Additional AutoML Requirements
AutoML Privileges
Supported Data Types for AutoML
Creating a Machine Learning Model
Preparing Data
Overview of Preparing Data
Preparing Training and Testing Datasets
Training a Model
Loading a Model
Generating Predictions
Generating Predictions for a Row of Data
Generating Predictions for a Table
Generating Model Explanations
Generating Prediction Explanations
Generating Prediction Explanations for a Row of Data
Generating Prediction Explanations for a Table
Scoring a Model
Learn About MySQL AI AutoML with NL2ML
Machine Learning Use Cases
Classify Data
Preparing Data for a Classification Model
Training a Classification Model
Generating Predictions for a Classification Model
Query Model Explanation and Generate Prediction Explanations for a Classification Model
Scoring a Classification Model
Perform Regression Analysis
Preparing Data for a Regression Model
Training a Model for Regression
Generating Predictions for a Regression Model
Query Model Explanation and Generate Prediction Explanations for a Regression Model
Scoring a Regression Model
Generating Forecasts
Forecasting Task Types
Prediction Intervals
Preparing Data for a Forecasting Model
Training a Forecasting Model
Generating Predictions for a Forecasting Model
Scoring a Forecasting Model
Detect Anomalies
Anomaly Detection Model Types
Anomaly Detection Learning Types
Anomaly Detection for Logs
Preparing Data for an Anomaly Detection Model
Training an Anomaly Detection Model
Generating Predictions for an Anomaly Detection Model
Scoring an Anomaly Detection Model
Generating Recommendations
Recommendation Task Types
Preparing Data for a Recommendation Model
Training a Recommendation Model
Generating Predictions for a Recommendation Model
Generating Predictions for Ratings and Rankings
Generating Item Recommendations for Users
Generating User Recommendations for Items
Generating Recommendations for Similar Items
Generating Recommendations for Similar Users
Scoring a Recommendation Model
Topic Modeling
Preparing Data for Topic Modeling
Training a Model with Topic Modeling
Running Topic Modeling on Trained Text
Manage Machine Learning Models
The Model Catalog
The Model Catalog Table
Model Metadata
Work with Model Handles
Unload a Model
View Model Details
Delete a Model
Share a Model
Manage External ONNX Models
ONNX Models Overview
ONNX Model Metadata
Importing an External ONNX Model
Analyzing Data Drift
Monitoring the Status of AutoML
AutoML Limitations
AI-Powered Search and Content Generation
Review Performance and Usage
MySQL AI System and Status Variables
MySQL AI Routines
Troubleshoot
Related Documentation
MySQL AI Release Notes
Download this Manual
PDF (US Ltr)
- 1.5Mb
PDF (A4)
- 1.5Mb
MySQL AI 9.7
/
...
/
Training and Using Machine Learning Models
/
Creating a Machine Learning Model
/
Preparing Data
4.5.1 Preparing Data
4.5.1.1 Overview of Preparing Data
4.5.1.2 Preparing Training and Testing Datasets
Review the following topics to learn more about preparing data for machine learning models.
PREV
HOME
UP
NEXT
Related Documentation
MySQL AI Release Notes
Download this Manual
PDF (US Ltr)
- 1.5Mb
PDF (A4)
- 1.5Mb