​
Creating a Model

To create a model, use the CREATE MODEL statement.

CREATE MODEL mindsdb.home_rentals
FROM example_db
    (SELECT * FROM demo_data.home_rentals)
PREDICT rental_price
USING engine = 'lightwood',
      tag = 'my model';

Now, your model has one version. You can verify by querying the models table.

DESCRIBE MODEL home_rentals;

On execution, we get:

+------------+---------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+----------------------+---------------------+------+--------------------------+-------------+
|NAME        |ENGINE   |PROJECT|ACTIVE|VERSION|STATUS  |ACCURACY|PREDICT     |UPDATE_STATUS|MINDSDB_VERSION|ERROR |SELECT_DATA_QUERY                   |TRAINING_OPTIONS                       |CURRENT_TRAINING_PHASE|TOTAL_TRAINING_PHASES|TAG   |CREATED_AT                |TRAINING_TIME|
+------------+---------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+----------------------+---------------------+------+--------------------------+-------------+
|home_rentals|lightwood|mindsdb|true  |1      |complete|0.999   |rental_price|up_to_date   |22.11.3.2      |[NULL]|SELECT * FROM demo_data.home_rentals|{'target': 'rental_price', 'using': {}}|5                     |5                    |[NULL]|2024-02-07 16:01:04.990958|19.946       |
+------------+---------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+----------------------+---------------------+------+--------------------------+-------------+

​
Retraining a Model

To retrain a model, use the RETRAIN statement.

RETRAIN mindsdb.home_rentals;

Let’s query for the model versions again.

DESCRIBE MODEL home_rentals;

On execution, we get:

+------------+---------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+----------------------+---------------------+------+--------------------------+-------------+
|NAME        |ENGINE   |PROJECT|ACTIVE|VERSION|STATUS  |ACCURACY|PREDICT     |UPDATE_STATUS|MINDSDB_VERSION|ERROR |SELECT_DATA_QUERY                   |TRAINING_OPTIONS                       |CURRENT_TRAINING_PHASE|TOTAL_TRAINING_PHASES|TAG   |CREATED_AT                |TRAINING_TIME|
+------------+---------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+----------------------+---------------------+------+--------------------------+-------------+
|home_rentals|lightwood|mindsdb|true  |1      |complete|0.999   |rental_price|up_to_date   |22.11.3.2      |[NULL]|SELECT * FROM demo_data.home_rentals|{'target': 'rental_price', 'using': {}}|5                     |5                    |[NULL]|2024-02-07 16:01:04.990958|19.946       |
|home_rentals|lightwood|mindsdb|true  |2      |complete|0.999   |rental_price|up_to_date   |22.11.3.2      |[NULL]|SELECT * FROM demo_data.home_rentals|{'target': 'rental_price', 'using': {}}|5                     |5                    |[NULL]|2024-02-07 17:01:04.990958|21.923       |
+------------+---------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+----------------------+---------------------+------+--------------------------+-------------+

​
Using Active Model Version

To use the currently active model version, run this query:

SELECT *
FROM mindsdb.home_rentals AS p
JOIN example_db.demo_data.home_rentals AS d;

​
Using Specific Model Version

To use a specific model version, even if it is set to inactive, run this query:

SELECT *
FROM mindsdb.home_rentals.1 AS p
JOIN example_db.demo_data.home_rentals AS d;

​
Setting Model Version as Active

To set a specific model version as active, run the below statement:

SET model_active = home_rentals.1;

​
Deleting Specific Model Version

To delete a specific model version, run the below statement:

DROP MODEL home_rentals.2

Please note that you cannot delete the version that is active.

​
Deleting All Model Versions

To delete all models version, run the DROP MODEL statement:

DROP MODEL mindsdb.home_rentals;