mindsdbadmin

{
    "predicted_value": 13772,
    "confidence": 0.9922,
    "prediction_quality": "very confident",
    "confidence_interval": [10795, 31666],
    "important_missing_information": [],
    "confidence_composition": {
        "Model": 0.008,
        "year": 0.018,
        "transmission": 0.001,

mindsdbadmin

SELECT price            AS predicted, 
       price_confidence AS confidence, 
       price_explain    AS info 
FROM   mindsdb.used_cars_model 
WHERE  model = "a6" 
       AND mileage = 36203 
       AND transmission = "automatic" 
       AND fueltype = "diesel" 
       AND mpg = "64.2" 
       AND enginesize = 2 

mindsdbadmin

SELECT price            AS predicted, 
       price_confidence AS confidence 
FROM   mindsdb.used_cars_model 
WHERE  model = "a6" 
       AND mileage = 36203 
       AND transmission = "automatic" 
       AND fueltype = "diesel" 
       AND mpg = "64.2" 
       AND enginesize = 2 
       AND year = 2016 

mindsdbadmin

SELECT * FROM mindsdb.predictors WHERE name='used_cars_model'

mindsdbadmin

{
   "api": {
       "http": {
           "host": "0.0.0.0",
           "port": "47334"
       },
       "mysql": {
           "certificate_path": "path/to/cert", 
           "host": "127.0.0.1",
           "log": {

mindsdbadmin

SELECT * FROM  test.used_cars_data LIMIT 5;

mindsdbadmin

mysqlimport --local --fields-terminated-by="," used_cars_data data.csv 

mindsdbadmin

LOAD DATA LOCAL INFILE 'data.csv' INTO used_cars_data FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';

mindsdbadmin

CREATE TABLE `used_cars_data` 
  ( 
     `model`        VARCHAR(100) DEFAULT NULL, 
     `year`         INT(11) DEFAULT NULL, 
     `price`        INT(11) DEFAULT NULL, 
     `transmission` VARCHAR(100) DEFAULT NULL, 
     `mileage`      INT(11) DEFAULT NULL, 
     `fueltype`     VARCHAR(100) DEFAULT NULL, 
     `tax`          INT(11) DEFAULT NULL, 
     `mpg`          FLOAT DEFAULT NULL, 

mindsdbadmin

SELECT price, 
       confidence 
FROM   mindsdb.used_cars_model 
WHERE  model = "a6" 
       AND mileage = 36203 
       AND transmission = "automatic" 
       AND fueltype = "diesel" 
       AND mpg = "64.2" 
       AND enginesize = 2 
       AND year = 2016