Skip to main content

​
Description

The SELECT * FROM files.file_name statement is used to select data from a file. First, you upload a file to the MindsDB Editor by following this guide. And then, you can CREATE MODEL from the uploaded file.

​
Syntax

Here is the syntax: 
SELECT *
FROM files.file_name;
On execution, we get: 
+--------+--------+--------+--------+
| column | column | column | column |
+--------+--------+--------+--------+
| value  | value  | value  | value  |
+--------+--------+--------+--------+
Where:
NameDescription
file_nameName of the file uploaded to the MindsDB Editor by following this guide.
columnName of the column from the file.

​
Example

Once you uploaded your file by following this guide, you can query it like a table. 
SELECT *
FROM files.home_rentals
LIMIT 10;
On execution, we get: 
+-----------------+---------------------+-------+----------+----------------+---------------+--------------+--------------+
| number_of_rooms | number_of_bathrooms | sqft  | location | days_on_market | initial_price | neighborhood | rental_price |
+-----------------+---------------------+-------+----------+----------------+---------------+--------------+--------------+
| 0               | 1                   | 484,8 | great    | 10             | 2271          | south_side   | 2271         |
| 1               | 1                   | 674   | good     | 1              | 2167          | downtown     | 2167         |
| 1               | 1                   | 554   | poor     | 19             | 1883          | westbrae     | 1883         |
| 0               | 1                   | 529   | great    | 3              | 2431          | south_side   | 2431         |
| 3               | 2                   | 1219  | great    | 3              | 5510          | south_side   | 5510         |
| 1               | 1                   | 398   | great    | 11             | 2272          | south_side   | 2272         |
| 3               | 2                   | 1190  | poor     | 58             | 4463          | westbrae     | 4123.812     |
| 1               | 1                   | 730   | good     | 0              | 2224          | downtown     | 2224         |
| 0               | 1                   | 298   | great    | 9              | 2104          | south_side   | 2104         |
| 2               | 1                   | 878   | great    | 8              | 3861          | south_side   | 3861         |
+-----------------+---------------------+-------+----------+----------------+---------------+--------------+--------------+
Now let’s create a predictor using the uploaded file. You can learn more about the CREATE MODEL command here. 
CREATE MODEL mindsdb.home_rentals_model
FROM files
    (SELECT * from home_rentals)
PREDICT rental_price;
On execution, we get: 
Query OK, 0 rows affected (x.xxx sec)