MySQL for the Internet of Things

(Steven Felgate) #1

Chapter 5 ■ MySQL priMer


INSERT INTO plant_monitoring.readings VALUES (1, 220, 38.9, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (1, 222, 38.5, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (1, 218, 37.1, NULL, NULL);


INSERT INTO plant_monitoring.readings VALUES (2, 355, 38.1, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 350, 38.6, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 366, 38.7, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 378, 38.8, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 361, 38.7, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 348, 37.5, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 343, 39.1, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 342, 38.8, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 358, 36.9, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (2, 377, 36.1, NULL, NULL);


INSERT INTO plant_monitoring.readings VALUES (3, 155, 33.6, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 150, 33.7, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 166, 33.6, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 278, 32.3, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 261, 31.2, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 248, 32.5, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 313, 33.6, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 342, 32.8, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 458, 31.9, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (3, 470, 33.4, NULL, NULL);


INSERT INTO plant_monitoring.readings VALUES (4, 333, 33.1, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 345, 33.6, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 360, 34.4, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 380, 34.2, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 395, 33.7, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 385, 33.4, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 425, 32.3, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 420, 31.1, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 422, 33.8, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (4, 418, 32.5, NULL, NULL);


INSERT INTO plant_monitoring.readings VALUES (5, 335, 39.9, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 335, 38.7, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 330, 38.8, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 330, 39.1, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 315, 39.2, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 315, 39.5, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 325, 39.2, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 320, 38.9, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 322, 38.5, NULL, NULL);
INSERT INTO plant_monitoring.readings VALUES (5, 318, 37.1, NULL, NULL);

Free download pdf