INSERT INTO Statement¶
Description¶
The INSERT INTO
statement is used to insert data into a table. This inserted data comes from the subselect statement. It is commonly used to input predictions into the database.
Syntax¶
INSERT INTO [integration_name].[table_name]
(SELECT ...);
It performs a subselect (SELECT ...)
and gets data from there. Then, this data is inserted into a table of integration [integration_name]
using INSERT INTO TABLE [table_name]
statement.
On execution, we get:
Query OK, 0 row(s) updated - x.xxxs
Example¶
In this example, we want to input the predictions into a table int1.tbl1
. Given is the following schema:
int1
└── tbl1
mindsdb
└── predictor_name
int2
└── tbl2
Where:
Description | |
---|---|
int1 |
Integration name where the table tbl1 resides |
tbl1 |
Table where data will be inserted |
predictor_name |
Name of the ML model |
int2 |
Database to be used as a source in the inner SELECT |
tbl2 |
Table to be used as a source |
In order to achieve the desired result, we execute the following query:
INSERT INTO int1.tbl1 (
SELECT *
FROM int2.tbl2 AS ta
JOIN mindsdb.predictor_name AS tb
WHERE ta.date > '2015-12-31'
);
On execution, we get:
Query OK, 0 row(s) updated - x.xxxs