CREATE MODEL
CREATE MODEL mindsdb.home_rentals FROM example_db (SELECT * FROM demo_data.home_rentals) PREDICT rental_price USING engine = 'lightwood', tag = 'my model';
models_versions
SELECT * FROM mindsdb.models_versions WHERE name = 'home_rentals';
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+ |NAME |PROJECT|ACTIVE|VERSION|STATUS |ACCURACY|PREDICT |UPDATE_STATUS|MINDSDB_VERSION|ERROR |SELECT_DATA_QUERY |TRAINING_OPTIONS |TAG | +------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+ |home_rentals|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': {}}|my model| +------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
RETRAIN
RETRAIN mindsdb.home_rentals;
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+ |NAME |PROJECT|ACTIVE|VERSION|STATUS |ACCURACY|PREDICT |UPDATE_STATUS|MINDSDB_VERSION|ERROR |SELECT_DATA_QUERY |TRAINING_OPTIONS |TAG | +------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+ |home_rentals|mindsdb|false |1 |complete|0.999 |rental_price|up_to_date |22.11.3.2 |[NULL]|SELECT * FROM demo_data.home_rentals|{'target': 'rental_price', 'using': {}}|my model| |home_rentals|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': {}}|my model| +------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
SELECT * FROM mindsdb.home_rentals AS p JOIN example_db.demo_data.home_rentals AS d;
SELECT * FROM mindsdb.home_rentals.1 AS p JOIN example_db.demo_data.home_rentals AS d;
UPDATE
UPDATE mindsdb.models_versions SET active = 1 WHERE version = 1 AND name = 'home_rentals';
DELETE FROM
DELETE FROM mindsdb.models_versions WHERE version = 2 AND name = 'home_rentals';
DROP MODEL
DROP MODEL mindsdb.home_rentals;