Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created December 29, 2020 03:15
Show Gist options
  • Save parzibyte/e88288a42918e8fe3f515680ed1541ae to your computer and use it in GitHub Desktop.
Save parzibyte/e88288a42918e8fe3f515680ed1541ae to your computer and use it in GitHub Desktop.
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4621
Server version: 10.4.11-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [dht_log]> # By: parzibyte
MariaDB [dht_log]> # Visita: https://parzibyte.me/blog
MariaDB [dht_log]> # Usar función para mostrar máxima humedad
MariaDB [dht_log]> SELECT MAX(humidity)
-> FROM dht_log;
+---------------+
| MAX(humidity) |
+---------------+
| 91.90 |
+---------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Del mismo modo, pero ahora con otra función, mostrar la mínima humedad registrada
MariaDB [dht_log]> SELECT MIN(humidity)
-> FROM dht_log;
+---------------+
| MIN(humidity) |
+---------------+
| 56.10 |
+---------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Mostrar la fecha en la que se registró la mínima temperatura, y también mostrar la fecha en la que se registró la máxima
MariaDB [dht_log]> SELECT date
-> FROM dht_log
-> ORDER BY temperature ASC
-> LIMIT 1;
+---------------------+
| date |
+---------------------+
| 2020-12-24 11:36:16 |
+---------------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> SELECT date
-> FROM dht_log
-> ORDER BY temperature DESC
-> LIMIT 1;
+---------------------+
| date |
+---------------------+
| 2020-12-23 20:14:20 |
+---------------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Mostrar la fecha, temperatura y humedad de la fila en la que se registró la menor temperatura
MariaDB [dht_log]> SELECT date, temperature, humidity
-> FROM dht_log
-> ORDER BY temperature DESC
-> LIMIT 1;
+---------------------+-------------+----------+
| date | temperature | humidity |
+---------------------+-------------+----------+
| 2020-12-23 20:14:20 | 19.30 | 56.10 |
+---------------------+-------------+----------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Usar select para mostrar solo la fecha (sin hora) del primer registro que exista
MariaDB [dht_log]> SELECT SUBSTR(date, 1, 10)
-> FROM dht_log
-> LIMIT 1;
+---------------------+
| SUBSTR(date, 1, 10) |
+---------------------+
| 2020-12-23 |
+---------------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Con select y ORDER BY mostrar los 10 registros más altos de temperatura
MariaDB [dht_log]> SELECT temperature
-> FROM dht_log
-> ORDER BY temperature DESC
-> LIMIT 10;
+-------------+
| temperature |
+-------------+
| 19.30 |
| 19.10 |
| 18.80 |
| 18.60 |
| 18.40 |
| 18.40 |
| 18.40 |
| 18.30 |
| 18.30 |
| 18.30 |
+-------------+
10 rows in set (0.000 sec)
MariaDB [dht_log]> # Usando WHERE mostrar todos los registros que se encuentren entre las fechas 2020-12-23 20:40:07 y 2020-12-24 08:45:00
MariaDB [dht_log]> SELECT date, temperature, humidity
-> FROM dht_log
-> WHERE date >= "2020-12-23 20:40:07"
-> AND date <= "2020-12-24 08:45:00";
+---------------------+-------------+----------+
| date | temperature | humidity |
+---------------------+-------------+----------+
| 2020-12-23 20:40:07 | 17.70 | 72.50 |
| 2020-12-23 20:40:37 | 17.70 | 72.90 |
| 2020-12-23 20:41:08 | 17.70 | 73.10 |
| 2020-12-23 20:41:38 | 17.70 | 73.50 |
| 2020-12-23 20:42:08 | 17.70 | 73.60 |
| 2020-12-23 20:42:39 | 17.70 | 73.70 |
| 2020-12-23 20:43:09 | 17.70 | 73.70 |
| 2020-12-23 21:17:05 | 17.90 | 74.40 |
| 2020-12-23 21:17:35 | 17.90 | 75.90 |
| 2020-12-23 21:18:06 | 18.10 | 76.00 |
| 2020-12-23 21:18:36 | 17.70 | 76.00 |
| 2020-12-23 21:19:06 | 17.80 | 76.40 |
| 2020-12-23 21:19:37 | 18.00 | 76.30 |
| 2020-12-23 21:20:07 | 18.00 | 76.40 |
| 2020-12-23 21:20:37 | 18.00 | 76.40 |
| 2020-12-23 21:21:08 | 18.00 | 76.60 |
| 2020-12-23 21:21:38 | 18.30 | 76.80 |
| 2020-12-23 21:22:08 | 18.00 | 76.70 |
| 2020-12-23 21:22:39 | 18.00 | 76.40 |
| 2020-12-23 21:23:09 | 18.00 | 76.30 |
| 2020-12-23 21:23:39 | 18.00 | 76.50 |
| 2020-12-23 21:24:09 | 17.70 | 76.30 |
| 2020-12-23 21:24:40 | 17.90 | 76.90 |
| 2020-12-23 21:25:10 | 17.90 | 76.80 |
| 2020-12-23 21:25:40 | 17.90 | 77.00 |
| 2020-12-23 21:26:11 | 17.80 | 77.00 |
| 2020-12-23 21:26:41 | 18.40 | 76.80 |
| 2020-12-23 21:27:11 | 17.30 | 76.60 |
| 2020-12-23 21:27:42 | 17.90 | 77.20 |
| 2020-12-23 21:28:12 | 17.80 | 77.00 |
| 2020-12-23 21:28:42 | 18.10 | 74.80 |
| 2020-12-23 21:29:12 | 17.40 | 70.90 |
| 2020-12-23 21:29:43 | 17.50 | 68.40 |
| 2020-12-23 21:30:13 | 17.60 | 67.60 |
| 2020-12-23 21:30:43 | 17.50 | 68.60 |
| 2020-12-23 21:31:14 | 17.40 | 68.50 |
| 2020-12-23 21:31:44 | 17.40 | 68.00 |
| 2020-12-23 21:32:14 | 17.10 | 68.00 |
| 2020-12-23 21:32:45 | 17.30 | 69.90 |
| 2020-12-23 21:33:15 | 17.20 | 70.10 |
| 2020-12-23 21:33:45 | 18.40 | 71.70 |
| 2020-12-23 21:34:16 | 17.40 | 71.80 |
| 2020-12-23 21:34:46 | 17.40 | 72.40 |
| 2020-12-23 21:35:16 | 17.50 | 72.20 |
| 2020-12-23 21:35:47 | 17.50 | 72.40 |
| 2020-12-23 21:36:17 | 17.50 | 72.30 |
| 2020-12-23 21:36:47 | 17.50 | 72.10 |
| 2020-12-23 21:37:17 | 17.60 | 72.20 |
| 2020-12-23 21:37:48 | 17.60 | 72.70 |
| 2020-12-23 21:38:18 | 17.70 | 73.00 |
| 2020-12-23 21:38:48 | 17.60 | 72.50 |
| 2020-12-23 21:39:19 | 17.60 | 73.60 |
| 2020-12-23 21:39:49 | 17.60 | 72.40 |
| 2020-12-23 21:40:19 | 17.60 | 72.30 |
| 2020-12-23 21:40:49 | 17.60 | 73.10 |
| 2020-12-23 21:41:20 | 17.60 | 73.70 |
| 2020-12-23 21:41:50 | 17.60 | 73.70 |
| 2020-12-23 21:42:20 | 17.50 | 73.30 |
| 2020-12-23 21:42:51 | 17.50 | 74.20 |
| 2020-12-23 21:43:21 | 17.50 | 74.10 |
| 2020-12-23 21:43:51 | 17.50 | 74.00 |
| 2020-12-23 21:44:22 | 17.50 | 74.50 |
| 2020-12-23 21:44:52 | 17.50 | 74.60 |
| 2020-12-23 21:45:22 | 17.50 | 74.40 |
| 2020-12-23 21:45:53 | 17.50 | 74.80 |
| 2020-12-23 21:46:23 | 17.50 | 74.60 |
| 2020-12-23 21:46:53 | 17.50 | 74.20 |
| 2020-12-23 21:47:24 | 17.40 | 75.20 |
| 2020-12-23 21:47:54 | 17.40 | 75.40 |
| 2020-12-23 21:48:24 | 17.30 | 75.20 |
| 2020-12-23 21:48:54 | 17.40 | 75.40 |
| 2020-12-23 21:49:25 | 17.40 | 75.10 |
| 2020-12-23 21:49:55 | 17.40 | 75.30 |
| 2020-12-23 21:50:25 | 17.40 | 75.60 |
| 2020-12-23 21:50:56 | 17.40 | 75.70 |
| 2020-12-23 21:51:26 | 17.40 | 75.70 |
| 2020-12-23 21:51:56 | 17.40 | 75.70 |
| 2020-12-23 21:52:27 | 17.40 | 75.60 |
| 2020-12-23 21:52:57 | 17.30 | 73.40 |
| 2020-12-23 21:53:27 | 17.30 | 72.70 |
| 2020-12-23 21:53:57 | 17.30 | 73.70 |
| 2020-12-23 21:54:28 | 17.30 | 73.80 |
| 2020-12-23 21:55:01 | 17.30 | 73.40 |
| 2020-12-23 21:55:31 | 17.40 | 74.00 |
| 2020-12-23 21:56:02 | 17.30 | 73.50 |
| 2020-12-23 21:56:32 | 17.30 | 71.50 |
| 2020-12-23 21:57:02 | 17.30 | 71.80 |
| 2020-12-23 21:57:33 | 17.30 | 70.70 |
| 2020-12-23 21:58:03 | 17.30 | 70.80 |
| 2020-12-23 21:58:33 | 17.30 | 71.10 |
| 2020-12-23 21:59:03 | 17.40 | 70.60 |
| 2020-12-23 21:59:34 | 17.30 | 69.20 |
| 2020-12-23 22:00:04 | 17.30 | 69.10 |
| 2020-12-23 22:00:34 | 17.30 | 68.00 |
| 2020-12-23 22:01:05 | 17.30 | 67.90 |
| 2020-12-23 22:01:35 | 17.30 | 67.40 |
| 2020-12-23 22:02:05 | 17.20 | 67.50 |
| 2020-12-23 22:02:36 | 17.20 | 67.60 |
| 2020-12-23 22:03:06 | 17.10 | 68.60 |
| 2020-12-23 22:03:36 | 17.10 | 69.30 |
| 2020-12-23 22:04:07 | 17.20 | 70.40 |
| 2020-12-23 22:04:37 | 17.20 | 70.90 |
| 2020-12-23 22:05:07 | 17.20 | 70.80 |
| 2020-12-23 22:05:38 | 17.20 | 68.90 |
| 2020-12-23 22:06:08 | 17.20 | 69.60 |
| 2020-12-23 22:06:38 | 17.20 | 69.40 |
| 2020-12-23 22:07:09 | 17.20 | 69.20 |
| 2020-12-23 22:07:39 | 17.20 | 68.20 |
| 2020-12-23 22:08:09 | 17.10 | 68.40 |
| 2020-12-23 22:08:39 | 17.10 | 68.30 |
| 2020-12-23 22:09:10 | 17.10 | 68.60 |
| 2020-12-23 22:09:40 | 17.10 | 69.00 |
| 2020-12-23 22:10:10 | 17.10 | 68.90 |
| 2020-12-23 22:10:41 | 17.10 | 69.90 |
| 2020-12-23 22:11:11 | 17.10 | 70.20 |
| 2020-12-23 22:11:41 | 17.10 | 69.60 |
| 2020-12-23 22:12:12 | 17.10 | 69.20 |
| 2020-12-23 22:12:42 | 17.10 | 68.60 |
| 2020-12-23 22:13:12 | 17.10 | 68.80 |
| 2020-12-23 22:13:43 | 17.10 | 68.50 |
| 2020-12-23 22:14:13 | 17.10 | 68.00 |
| 2020-12-23 22:14:43 | 17.10 | 68.30 |
| 2020-12-23 22:15:14 | 17.10 | 68.70 |
| 2020-12-23 22:15:44 | 17.00 | 68.40 |
| 2020-12-23 22:16:14 | 17.10 | 68.80 |
| 2020-12-23 22:16:44 | 17.10 | 69.60 |
| 2020-12-23 22:17:18 | 17.10 | 71.00 |
| 2020-12-23 22:17:48 | 17.00 | 67.50 |
| 2020-12-23 22:18:21 | 17.10 | 66.00 |
| 2020-12-23 22:18:51 | 17.00 | 67.90 |
| 2020-12-23 22:19:22 | 17.00 | 68.80 |
| 2020-12-23 22:19:52 | 16.90 | 69.70 |
| 2020-12-23 22:20:22 | 17.00 | 69.40 |
| 2020-12-23 22:20:53 | 16.90 | 70.50 |
| 2020-12-23 22:21:23 | 17.00 | 71.90 |
| 2020-12-23 22:21:53 | 16.60 | 70.00 |
| 2020-12-23 22:22:23 | 16.90 | 69.40 |
| 2020-12-23 22:22:54 | 16.90 | 69.20 |
| 2020-12-23 22:23:24 | 16.70 | 69.80 |
| 2020-12-23 22:23:54 | 16.80 | 68.80 |
| 2020-12-23 22:24:25 | 16.80 | 67.50 |
| 2020-12-23 22:24:55 | 16.80 | 67.50 |
| 2020-12-23 22:25:26 | 16.30 | 68.00 |
| 2020-12-23 22:25:56 | 16.70 | 69.00 |
| 2020-12-23 22:26:26 | 16.70 | 70.10 |
| 2020-12-23 22:26:57 | 16.80 | 71.30 |
| 2020-12-23 22:27:27 | 16.80 | 71.70 |
| 2020-12-23 22:27:57 | 17.00 | 72.60 |
| 2020-12-23 22:28:27 | 16.90 | 73.70 |
| 2020-12-23 22:28:58 | 17.30 | 73.90 |
| 2020-12-23 22:29:28 | 17.30 | 73.50 |
| 2020-12-23 22:29:58 | 17.30 | 72.20 |
| 2020-12-23 22:30:31 | 17.40 | 72.50 |
| 2020-12-23 22:31:02 | 17.30 | 72.40 |
| 2020-12-23 22:31:32 | 17.20 | 72.90 |
| 2020-12-23 22:32:02 | 17.20 | 73.60 |
| 2020-12-23 22:32:35 | 17.30 | 73.80 |
| 2020-12-23 22:33:06 | 17.50 | 73.90 |
| 2020-12-23 22:33:36 | 17.10 | 75.00 |
| 2020-12-23 22:34:06 | 17.30 | 74.90 |
| 2020-12-23 22:34:40 | 17.20 | 74.80 |
| 2020-12-23 22:35:10 | 17.30 | 74.70 |
| 2020-12-23 22:35:40 | 17.20 | 77.30 |
| 2020-12-23 22:36:11 | 17.50 | 75.10 |
| 2020-12-23 22:36:41 | 17.20 | 74.80 |
| 2020-12-23 22:37:11 | 17.50 | 75.10 |
| 2020-12-23 22:37:41 | 17.30 | 75.70 |
| 2020-12-23 22:38:12 | 17.40 | 75.30 |
| 2020-12-23 22:38:42 | 17.40 | 75.10 |
| 2020-12-23 22:39:12 | 17.40 | 75.30 |
| 2020-12-23 22:39:43 | 17.90 | 75.90 |
| 2020-12-23 22:40:13 | 17.40 | 76.10 |
| 2020-12-23 22:40:43 | 17.70 | 76.20 |
| 2020-12-23 22:41:14 | 17.40 | 76.10 |
| 2020-12-23 22:41:44 | 17.40 | 75.90 |
| 2020-12-23 22:42:14 | 17.40 | 76.10 |
| 2020-12-23 22:42:45 | 17.10 | 76.20 |
| 2020-12-23 22:43:15 | 17.60 | 77.20 |
| 2020-12-23 22:43:45 | 17.50 | 76.50 |
| 2020-12-23 22:44:16 | 17.30 | 76.70 |
| 2020-12-23 22:44:46 | 17.30 | 76.70 |
| 2020-12-23 22:45:16 | 17.30 | 77.00 |
| 2020-12-23 22:45:47 | 17.30 | 77.00 |
| 2020-12-23 22:46:17 | 17.60 | 77.40 |
| 2020-12-23 22:46:47 | 17.40 | 77.00 |
| 2020-12-23 22:47:18 | 17.50 | 77.00 |
| 2020-12-23 22:47:48 | 17.40 | 76.80 |
| 2020-12-23 22:48:21 | 17.50 | 77.10 |
| 2020-12-23 22:48:51 | 17.70 | 77.20 |
| 2020-12-23 22:49:21 | 17.50 | 77.10 |
| 2020-12-23 22:49:52 | 17.60 | 77.10 |
| 2020-12-23 22:50:22 | 17.50 | 77.50 |
| 2020-12-23 22:50:52 | 17.50 | 77.30 |
| 2020-12-23 22:51:23 | 18.30 | 77.80 |
| 2020-12-23 22:51:53 | 17.50 | 77.30 |
| 2020-12-23 22:52:23 | 17.50 | 77.70 |
| 2020-12-23 22:52:54 | 17.60 | 77.70 |
| 2020-12-23 22:59:02 | 17.60 | 78.00 |
| 2020-12-23 22:59:33 | 17.90 | 79.60 |
| 2020-12-23 23:00:03 | 17.90 | 78.10 |
| 2020-12-23 23:00:33 | 17.70 | 77.50 |
| 2020-12-23 23:01:04 | 17.90 | 77.50 |
| 2020-12-23 23:01:34 | 17.90 | 77.20 |
| 2020-12-23 23:02:04 | 17.90 | 77.40 |
| 2020-12-23 23:02:34 | 17.90 | 77.90 |
| 2020-12-23 23:03:05 | 17.90 | 78.10 |
| 2020-12-23 23:03:35 | 17.90 | 78.00 |
| 2020-12-23 23:04:05 | 17.90 | 79.00 |
| 2020-12-23 23:04:36 | 17.90 | 78.80 |
| 2020-12-23 23:05:06 | 17.80 | 78.10 |
| 2020-12-23 23:05:36 | 17.90 | 78.00 |
| 2020-12-23 23:06:07 | 17.90 | 77.80 |
| 2020-12-23 23:06:37 | 17.80 | 78.30 |
| 2020-12-23 23:07:07 | 17.70 | 78.50 |
| 2020-12-23 23:07:38 | 17.70 | 78.90 |
| 2020-12-23 23:08:08 | 17.80 | 78.90 |
| 2020-12-23 23:08:38 | 17.60 | 78.80 |
+---------------------+-------------+----------+
217 rows in set (0.001 sec)
MariaDB [dht_log]> # Usar SELECT y WHERE para mostrar los registros en donde la temperatura sea menor que 17 grados centígrados
MariaDB [dht_log]> SELECT date, temperature, humidity
-> FROM dht_log
-> WHERE temperature < 17;
+---------------------+-------------+----------+
| date | temperature | humidity |
+---------------------+-------------+----------+
| 2020-12-23 22:19:52 | 16.90 | 69.70 |
| 2020-12-23 22:20:53 | 16.90 | 70.50 |
| 2020-12-23 22:21:53 | 16.60 | 70.00 |
| 2020-12-23 22:22:23 | 16.90 | 69.40 |
| 2020-12-23 22:22:54 | 16.90 | 69.20 |
| 2020-12-23 22:23:24 | 16.70 | 69.80 |
| 2020-12-23 22:23:54 | 16.80 | 68.80 |
| 2020-12-23 22:24:25 | 16.80 | 67.50 |
| 2020-12-23 22:24:55 | 16.80 | 67.50 |
| 2020-12-23 22:25:26 | 16.30 | 68.00 |
| 2020-12-23 22:25:56 | 16.70 | 69.00 |
| 2020-12-23 22:26:26 | 16.70 | 70.10 |
| 2020-12-23 22:26:57 | 16.80 | 71.30 |
| 2020-12-23 22:27:27 | 16.80 | 71.70 |
| 2020-12-23 22:28:27 | 16.90 | 73.70 |
| 2020-12-24 08:45:51 | 15.30 | 91.60 |
| 2020-12-24 08:46:22 | 15.30 | 91.90 |
| 2020-12-24 08:46:52 | 15.40 | 91.20 |
| 2020-12-24 08:47:23 | 15.30 | 90.50 |
| 2020-12-24 08:47:54 | 15.30 | 90.10 |
| 2020-12-24 08:48:24 | 15.40 | 90.20 |
| 2020-12-24 08:48:54 | 15.40 | 90.20 |
| 2020-12-24 08:49:24 | 15.40 | 90.30 |
| 2020-12-24 08:49:55 | 15.40 | 90.20 |
| 2020-12-24 08:50:25 | 15.40 | 90.00 |
| 2020-12-24 08:51:31 | 15.40 | 90.00 |
| 2020-12-24 08:52:01 | 15.30 | 90.10 |
| 2020-12-24 08:52:31 | 15.30 | 90.00 |
| 2020-12-24 08:53:02 | 15.20 | 90.00 |
| 2020-12-24 08:53:32 | 15.20 | 90.00 |
| 2020-12-24 08:54:02 | 15.20 | 90.10 |
| 2020-12-24 08:54:33 | 15.10 | 90.20 |
| 2020-12-24 08:55:03 | 15.10 | 90.10 |
| 2020-12-24 08:55:33 | 15.10 | 90.10 |
| 2020-12-24 08:56:04 | 15.10 | 90.40 |
| 2020-12-24 08:56:35 | 15.10 | 90.60 |
| 2020-12-24 08:57:05 | 15.20 | 90.40 |
| 2020-12-24 08:57:36 | 15.20 | 90.60 |
| 2020-12-24 08:58:06 | 15.20 | 90.50 |
| 2020-12-24 08:58:36 | 15.30 | 90.90 |
| 2020-12-24 08:59:06 | 15.30 | 90.80 |
| 2020-12-24 08:59:37 | 15.30 | 91.30 |
| 2020-12-24 09:00:07 | 15.40 | 90.90 |
| 2020-12-24 09:00:37 | 15.40 | 90.40 |
| 2020-12-24 09:01:08 | 15.40 | 90.40 |
| 2020-12-24 09:01:38 | 15.40 | 90.60 |
| 2020-12-24 09:02:08 | 15.40 | 90.70 |
| 2020-12-24 09:02:39 | 15.40 | 90.50 |
| 2020-12-24 09:03:10 | 15.40 | 91.30 |
| 2020-12-24 09:03:40 | 15.40 | 90.90 |
| 2020-12-24 09:04:11 | 15.40 | 90.80 |
| 2020-12-24 09:04:41 | 15.30 | 90.40 |
| 2020-12-24 09:05:11 | 15.20 | 89.60 |
| 2020-12-24 09:05:42 | 15.20 | 90.50 |
| 2020-12-24 09:06:12 | 15.20 | 90.10 |
| 2020-12-24 09:06:42 | 15.20 | 90.20 |
| 2020-12-24 09:07:13 | 15.30 | 89.90 |
| 2020-12-24 09:07:49 | 15.40 | 89.80 |
| 2020-12-24 09:08:19 | 15.30 | 90.40 |
| 2020-12-24 09:08:49 | 15.20 | 90.10 |
| 2020-12-24 09:09:19 | 15.10 | 90.00 |
| 2020-12-24 09:09:49 | 15.10 | 89.80 |
| 2020-12-24 09:10:21 | 15.10 | 90.70 |
| 2020-12-24 09:10:51 | 15.20 | 90.30 |
| 2020-12-24 09:11:21 | 15.20 | 90.50 |
| 2020-12-24 09:11:51 | 15.30 | 90.50 |
| 2020-12-24 09:12:22 | 15.20 | 90.40 |
| 2020-12-24 09:12:52 | 15.30 | 90.40 |
| 2020-12-24 09:13:23 | 15.30 | 90.10 |
| 2020-12-24 09:13:53 | 15.40 | 90.40 |
| 2020-12-24 09:14:23 | 15.40 | 90.40 |
| 2020-12-24 09:14:53 | 15.30 | 90.10 |
| 2020-12-24 09:15:27 | 15.30 | 89.40 |
| 2020-12-24 09:15:57 | 15.30 | 89.90 |
| 2020-12-24 09:16:27 | 15.20 | 90.00 |
| 2020-12-24 09:16:58 | 15.20 | 90.00 |
| 2020-12-24 09:17:28 | 15.10 | 89.80 |
| 2020-12-24 09:18:34 | 15.00 | 90.40 |
| 2020-12-24 09:19:04 | 15.00 | 90.40 |
| 2020-12-24 09:19:34 | 15.00 | 90.80 |
| 2020-12-24 11:35:15 | 15.50 | 91.00 |
| 2020-12-24 11:35:45 | 16.00 | 91.50 |
| 2020-12-24 11:36:16 | 13.70 | 90.90 |
| 2020-12-24 11:36:46 | 14.50 | 91.10 |
| 2020-12-24 11:37:16 | 15.60 | 91.30 |
| 2020-12-24 11:37:47 | 15.40 | 91.20 |
| 2020-12-24 11:38:17 | 15.40 | 91.30 |
| 2020-12-24 11:38:47 | 15.40 | 91.20 |
| 2020-12-24 11:39:17 | 15.40 | 91.00 |
| 2020-12-24 11:39:48 | 15.40 | 91.20 |
| 2020-12-24 11:40:18 | 13.70 | 90.70 |
| 2020-12-24 11:40:50 | 15.40 | 90.40 |
| 2020-12-24 11:41:20 | 15.40 | 90.70 |
| 2020-12-24 11:41:53 | 15.40 | 90.80 |
| 2020-12-24 11:42:24 | 15.50 | 90.60 |
| 2020-12-24 11:42:55 | 15.40 | 90.80 |
| 2020-12-24 11:43:25 | 15.40 | 90.40 |
| 2020-12-24 11:43:56 | 15.40 | 90.40 |
| 2020-12-24 11:44:27 | 15.40 | 90.40 |
| 2020-12-24 11:44:58 | 15.40 | 90.30 |
| 2020-12-24 11:45:28 | 15.40 | 90.30 |
| 2020-12-24 11:45:59 | 15.40 | 90.20 |
| 2020-12-24 11:46:31 | 15.40 | 90.10 |
| 2020-12-24 11:47:02 | 15.40 | 88.70 |
| 2020-12-24 11:47:33 | 15.50 | 88.90 |
| 2020-12-24 11:48:03 | 15.50 | 90.00 |
| 2020-12-24 11:48:34 | 15.50 | 90.20 |
| 2020-12-24 11:49:08 | 15.50 | 89.60 |
| 2020-12-24 11:49:38 | 15.50 | 89.20 |
| 2020-12-24 11:50:10 | 15.50 | 88.50 |
| 2020-12-24 11:50:43 | 15.50 | 89.10 |
| 2020-12-24 11:51:15 | 15.50 | 88.90 |
| 2020-12-24 11:51:45 | 15.60 | 89.10 |
| 2020-12-24 11:52:16 | 15.50 | 89.30 |
| 2020-12-24 11:52:47 | 15.50 | 89.20 |
| 2020-12-24 11:53:21 | 15.50 | 88.60 |
| 2020-12-24 11:53:51 | 15.50 | 87.80 |
| 2020-12-24 11:54:22 | 15.50 | 88.70 |
| 2020-12-24 11:54:53 | 15.50 | 88.90 |
| 2020-12-24 11:55:24 | 15.40 | 89.00 |
| 2020-12-24 11:55:54 | 15.40 | 88.70 |
| 2020-12-24 11:56:24 | 15.40 | 88.50 |
| 2020-12-24 11:56:55 | 15.40 | 87.50 |
| 2020-12-24 11:57:25 | 15.40 | 90.30 |
| 2020-12-24 11:57:55 | 15.40 | 88.80 |
| 2020-12-24 11:58:26 | 15.40 | 88.90 |
| 2020-12-24 11:58:56 | 15.20 | 88.40 |
| 2020-12-24 11:59:26 | 15.40 | 88.30 |
| 2020-12-24 11:59:57 | 15.40 | 88.30 |
| 2020-12-24 12:00:27 | 15.40 | 88.80 |
| 2020-12-24 12:00:57 | 15.40 | 87.60 |
| 2020-12-24 12:01:27 | 15.40 | 88.80 |
| 2020-12-24 12:01:58 | 15.30 | 89.30 |
| 2020-12-24 12:02:28 | 15.40 | 88.20 |
| 2020-12-24 12:02:58 | 15.40 | 88.40 |
| 2020-12-24 12:03:29 | 15.40 | 88.20 |
| 2020-12-24 12:04:00 | 15.40 | 87.80 |
| 2020-12-24 12:04:30 | 15.40 | 88.10 |
| 2020-12-24 12:05:01 | 15.50 | 87.60 |
| 2020-12-24 12:05:31 | 15.40 | 87.30 |
| 2020-12-24 12:06:01 | 15.40 | 86.30 |
| 2020-12-24 12:06:31 | 15.40 | 87.00 |
| 2020-12-24 12:07:02 | 15.40 | 87.30 |
| 2020-12-24 12:07:32 | 15.30 | 87.30 |
| 2020-12-24 12:08:04 | 15.30 | 85.90 |
| 2020-12-24 12:08:34 | 15.30 | 86.40 |
| 2020-12-24 12:09:41 | 15.30 | 86.70 |
| 2020-12-24 12:10:11 | 15.30 | 85.70 |
| 2020-12-24 12:10:41 | 15.30 | 85.90 |
| 2020-12-24 12:11:11 | 15.30 | 85.80 |
| 2020-12-24 12:11:42 | 15.30 | 85.00 |
| 2020-12-24 12:12:12 | 15.30 | 85.00 |
| 2020-12-24 12:12:42 | 15.20 | 85.90 |
| 2020-12-24 12:13:12 | 15.20 | 85.90 |
| 2020-12-24 12:13:43 | 15.20 | 84.20 |
| 2020-12-24 12:14:14 | 15.10 | 83.70 |
| 2020-12-24 12:14:44 | 15.20 | 85.40 |
| 2020-12-24 12:15:15 | 15.20 | 85.60 |
| 2020-12-24 12:15:45 | 15.20 | 86.00 |
| 2020-12-24 12:16:19 | 15.20 | 85.80 |
| 2020-12-24 12:16:50 | 15.20 | 86.10 |
| 2020-12-24 12:17:20 | 15.20 | 86.70 |
| 2020-12-24 12:17:50 | 15.20 | 85.30 |
| 2020-12-24 12:18:21 | 15.20 | 86.60 |
| 2020-12-24 12:18:51 | 15.20 | 85.80 |
| 2020-12-24 12:19:22 | 15.20 | 86.80 |
| 2020-12-24 12:19:52 | 15.20 | 86.30 |
| 2020-12-24 12:20:26 | 15.20 | 85.40 |
| 2020-12-24 12:20:59 | 15.20 | 86.70 |
| 2020-12-24 12:22:04 | 15.20 | 86.40 |
| 2020-12-24 12:22:35 | 15.20 | 85.10 |
| 2020-12-24 12:23:05 | 15.40 | 85.00 |
| 2020-12-24 12:23:36 | 15.30 | 86.70 |
| 2020-12-24 12:24:06 | 15.30 | 85.40 |
| 2020-12-24 12:24:36 | 15.30 | 85.30 |
| 2020-12-24 12:25:07 | 15.30 | 84.50 |
| 2020-12-24 12:25:38 | 15.30 | 82.60 |
| 2020-12-24 12:26:08 | 15.30 | 84.30 |
| 2020-12-24 12:26:39 | 15.40 | 84.60 |
+---------------------+-------------+----------+
179 rows in set (0.000 sec)
MariaDB [dht_log]> # Usando una consulta, mostrar los distintos registros de temperatura sin repetirse. Es decir, solo mostrar todas las temperaturas registradas pero sin repetir alguna
MariaDB [dht_log]> SELECT DISTINCT temperature
-> FROM dht_log;
+-------------+
| temperature |
+-------------+
| 19.30 |
| 19.10 |
| 18.80 |
| 18.60 |
| 18.40 |
| 18.30 |
| 17.90 |
| 18.00 |
| 17.80 |
| 17.70 |
| 17.60 |
| 17.50 |
| 17.40 |
| 17.30 |
| 17.20 |
| 17.10 |
| 17.00 |
| 18.10 |
| 16.90 |
| 16.60 |
| 16.70 |
| 16.80 |
| 16.30 |
| 15.30 |
| 15.40 |
| 15.20 |
| 15.10 |
| 15.00 |
| 15.50 |
| 16.00 |
| 13.70 |
| 14.50 |
| 15.60 |
+-------------+
33 rows in set (0.000 sec)
MariaDB [dht_log]> # Con select, mostrar el promedio de temperatura de todos los datos
MariaDB [dht_log]> SELECT AVG(temperature)
-> FROM dht_log;
+------------------+
| AVG(temperature) |
+------------------+
| 16.641570 |
+------------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Del mismo modo, mostrar el promedio de humedad
MariaDB [dht_log]> SELECT AVG(humidity)
-> FROM dht_log;
+---------------+
| AVG(humidity) |
+---------------+
| 78.398614 |
+---------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Mostrar el promedio de la temperatura pero solo para el día 24 de diciembre del 2020
MariaDB [dht_log]> SELECT AVG(temperature)
-> FROM dht_log
-> WHERE date >= "2020-12-24 00:00:00"
-> AND date <= "2020-12-24 23:59:59";
+------------------+
| AVG(temperature) |
+------------------+
| 15.312121 |
+------------------+
1 row in set (0.000 sec)
MariaDB [dht_log]> # Mostrar todos los registros, pero agregar una columna extra. Si la temperatura es mayor o igual a 17 grados centígrados, imprimir Calor. Si no, imprimir Frio.
MariaDB [dht_log]> SELECT date, temperature, humidity, IF(temperature >= 17, "Calor", "Frio")
-> FROM dht_log;
+---------------------+-------------+----------+----------------------------------------+
| date | temperature | humidity | IF(temperature >= 17, "Calor", "Frio") |
+---------------------+-------------+----------+----------------------------------------+
| 2020-12-23 20:14:20 | 19.30 | 56.10 | Calor |
| 2020-12-23 20:14:51 | 19.10 | 57.80 | Calor |
| 2020-12-23 20:15:21 | 18.80 | 58.60 | Calor |
| 2020-12-23 20:15:52 | 18.60 | 58.00 | Calor |
| 2020-12-23 20:16:22 | 18.40 | 59.00 | Calor |
| 2020-12-23 20:16:52 | 18.30 | 59.80 | Calor |
| 2020-12-23 20:17:22 | 17.90 | 60.60 | Calor |
| 2020-12-23 20:17:53 | 18.00 | 61.00 | Calor |
| 2020-12-23 20:18:23 | 18.00 | 61.60 | Calor |
| 2020-12-23 20:18:54 | 17.90 | 61.90 | Calor |
| 2020-12-23 20:19:24 | 17.80 | 61.80 | Calor |
| 2020-12-23 20:19:55 | 17.70 | 62.20 | Calor |
| 2020-12-23 20:20:25 | 17.60 | 62.50 | Calor |
| 2020-12-23 20:20:56 | 17.50 | 62.30 | Calor |
| 2020-12-23 20:21:26 | 17.50 | 62.50 | Calor |
| 2020-12-23 20:21:56 | 17.40 | 62.90 | Calor |
| 2020-12-23 20:22:26 | 17.40 | 62.90 | Calor |
| 2020-12-23 20:22:57 | 17.40 | 62.70 | Calor |
| 2020-12-23 20:23:27 | 17.30 | 63.10 | Calor |
| 2020-12-23 20:23:57 | 17.20 | 64.20 | Calor |
| 2020-12-23 20:24:28 | 17.20 | 64.30 | Calor |
| 2020-12-23 20:24:58 | 17.10 | 64.40 | Calor |
| 2020-12-23 20:25:28 | 17.20 | 64.40 | Calor |
| 2020-12-23 20:25:59 | 17.00 | 64.00 | Calor |
| 2020-12-23 20:26:29 | 17.00 | 64.20 | Calor |
| 2020-12-23 20:26:59 | 17.00 | 64.60 | Calor |
| 2020-12-23 20:27:30 | 17.00 | 65.90 | Calor |
| 2020-12-23 20:28:00 | 17.00 | 65.10 | Calor |
| 2020-12-23 20:28:30 | 17.00 | 65.40 | Calor |
| 2020-12-23 20:29:00 | 17.10 | 67.60 | Calor |
| 2020-12-23 20:29:31 | 17.10 | 68.50 | Calor |
| 2020-12-23 20:30:01 | 17.20 | 68.60 | Calor |
| 2020-12-23 20:30:31 | 17.30 | 69.30 | Calor |
| 2020-12-23 20:31:02 | 17.30 | 69.70 | Calor |
| 2020-12-23 20:31:32 | 17.40 | 69.80 | Calor |
| 2020-12-23 20:32:02 | 17.40 | 69.80 | Calor |
| 2020-12-23 20:32:33 | 17.40 | 69.60 | Calor |
| 2020-12-23 20:33:03 | 17.40 | 70.50 | Calor |
| 2020-12-23 20:33:33 | 17.40 | 69.90 | Calor |
| 2020-12-23 20:34:03 | 17.50 | 70.20 | Calor |
| 2020-12-23 20:34:34 | 17.50 | 70.60 | Calor |
| 2020-12-23 20:35:04 | 17.50 | 70.30 | Calor |
| 2020-12-23 20:35:34 | 17.60 | 71.20 | Calor |
| 2020-12-23 20:36:05 | 17.60 | 70.90 | Calor |
| 2020-12-23 20:36:35 | 17.60 | 71.10 | Calor |
| 2020-12-23 20:37:05 | 17.60 | 71.30 | Calor |
| 2020-12-23 20:37:36 | 17.70 | 72.20 | Calor |
| 2020-12-23 20:38:06 | 17.70 | 72.00 | Calor |
| 2020-12-23 20:38:36 | 17.70 | 71.70 | Calor |
| 2020-12-23 20:39:07 | 17.70 | 72.10 | Calor |
| 2020-12-23 20:39:37 | 17.70 | 72.40 | Calor |
| 2020-12-23 20:40:07 | 17.70 | 72.50 | Calor |
| 2020-12-23 20:40:37 | 17.70 | 72.90 | Calor |
| 2020-12-23 20:41:08 | 17.70 | 73.10 | Calor |
| 2020-12-23 20:41:38 | 17.70 | 73.50 | Calor |
| 2020-12-23 20:42:08 | 17.70 | 73.60 | Calor |
| 2020-12-23 20:42:39 | 17.70 | 73.70 | Calor |
| 2020-12-23 20:43:09 | 17.70 | 73.70 | Calor |
| 2020-12-23 21:17:05 | 17.90 | 74.40 | Calor |
| 2020-12-23 21:17:35 | 17.90 | 75.90 | Calor |
| 2020-12-23 21:18:06 | 18.10 | 76.00 | Calor |
| 2020-12-23 21:18:36 | 17.70 | 76.00 | Calor |
| 2020-12-23 21:19:06 | 17.80 | 76.40 | Calor |
| 2020-12-23 21:19:37 | 18.00 | 76.30 | Calor |
| 2020-12-23 21:20:07 | 18.00 | 76.40 | Calor |
| 2020-12-23 21:20:37 | 18.00 | 76.40 | Calor |
| 2020-12-23 21:21:08 | 18.00 | 76.60 | Calor |
| 2020-12-23 21:21:38 | 18.30 | 76.80 | Calor |
| 2020-12-23 21:22:08 | 18.00 | 76.70 | Calor |
| 2020-12-23 21:22:39 | 18.00 | 76.40 | Calor |
| 2020-12-23 21:23:09 | 18.00 | 76.30 | Calor |
| 2020-12-23 21:23:39 | 18.00 | 76.50 | Calor |
| 2020-12-23 21:24:09 | 17.70 | 76.30 | Calor |
| 2020-12-23 21:24:40 | 17.90 | 76.90 | Calor |
| 2020-12-23 21:25:10 | 17.90 | 76.80 | Calor |
| 2020-12-23 21:25:40 | 17.90 | 77.00 | Calor |
| 2020-12-23 21:26:11 | 17.80 | 77.00 | Calor |
| 2020-12-23 21:26:41 | 18.40 | 76.80 | Calor |
| 2020-12-23 21:27:11 | 17.30 | 76.60 | Calor |
| 2020-12-23 21:27:42 | 17.90 | 77.20 | Calor |
| 2020-12-23 21:28:12 | 17.80 | 77.00 | Calor |
| 2020-12-23 21:28:42 | 18.10 | 74.80 | Calor |
| 2020-12-23 21:29:12 | 17.40 | 70.90 | Calor |
| 2020-12-23 21:29:43 | 17.50 | 68.40 | Calor |
| 2020-12-23 21:30:13 | 17.60 | 67.60 | Calor |
| 2020-12-23 21:30:43 | 17.50 | 68.60 | Calor |
| 2020-12-23 21:31:14 | 17.40 | 68.50 | Calor |
| 2020-12-23 21:31:44 | 17.40 | 68.00 | Calor |
| 2020-12-23 21:32:14 | 17.10 | 68.00 | Calor |
| 2020-12-23 21:32:45 | 17.30 | 69.90 | Calor |
| 2020-12-23 21:33:15 | 17.20 | 70.10 | Calor |
| 2020-12-23 21:33:45 | 18.40 | 71.70 | Calor |
| 2020-12-23 21:34:16 | 17.40 | 71.80 | Calor |
| 2020-12-23 21:34:46 | 17.40 | 72.40 | Calor |
| 2020-12-23 21:35:16 | 17.50 | 72.20 | Calor |
| 2020-12-23 21:35:47 | 17.50 | 72.40 | Calor |
| 2020-12-23 21:36:17 | 17.50 | 72.30 | Calor |
| 2020-12-23 21:36:47 | 17.50 | 72.10 | Calor |
| 2020-12-23 21:37:17 | 17.60 | 72.20 | Calor |
| 2020-12-23 21:37:48 | 17.60 | 72.70 | Calor |
| 2020-12-23 21:38:18 | 17.70 | 73.00 | Calor |
| 2020-12-23 21:38:48 | 17.60 | 72.50 | Calor |
| 2020-12-23 21:39:19 | 17.60 | 73.60 | Calor |
| 2020-12-23 21:39:49 | 17.60 | 72.40 | Calor |
| 2020-12-23 21:40:19 | 17.60 | 72.30 | Calor |
| 2020-12-23 21:40:49 | 17.60 | 73.10 | Calor |
| 2020-12-23 21:41:20 | 17.60 | 73.70 | Calor |
| 2020-12-23 21:41:50 | 17.60 | 73.70 | Calor |
| 2020-12-23 21:42:20 | 17.50 | 73.30 | Calor |
| 2020-12-23 21:42:51 | 17.50 | 74.20 | Calor |
| 2020-12-23 21:43:21 | 17.50 | 74.10 | Calor |
| 2020-12-23 21:43:51 | 17.50 | 74.00 | Calor |
| 2020-12-23 21:44:22 | 17.50 | 74.50 | Calor |
| 2020-12-23 21:44:52 | 17.50 | 74.60 | Calor |
| 2020-12-23 21:45:22 | 17.50 | 74.40 | Calor |
| 2020-12-23 21:45:53 | 17.50 | 74.80 | Calor |
| 2020-12-23 21:46:23 | 17.50 | 74.60 | Calor |
| 2020-12-23 21:46:53 | 17.50 | 74.20 | Calor |
| 2020-12-23 21:47:24 | 17.40 | 75.20 | Calor |
| 2020-12-23 21:47:54 | 17.40 | 75.40 | Calor |
| 2020-12-23 21:48:24 | 17.30 | 75.20 | Calor |
| 2020-12-23 21:48:54 | 17.40 | 75.40 | Calor |
| 2020-12-23 21:49:25 | 17.40 | 75.10 | Calor |
| 2020-12-23 21:49:55 | 17.40 | 75.30 | Calor |
| 2020-12-23 21:50:25 | 17.40 | 75.60 | Calor |
| 2020-12-23 21:50:56 | 17.40 | 75.70 | Calor |
| 2020-12-23 21:51:26 | 17.40 | 75.70 | Calor |
| 2020-12-23 21:51:56 | 17.40 | 75.70 | Calor |
| 2020-12-23 21:52:27 | 17.40 | 75.60 | Calor |
| 2020-12-23 21:52:57 | 17.30 | 73.40 | Calor |
| 2020-12-23 21:53:27 | 17.30 | 72.70 | Calor |
| 2020-12-23 21:53:57 | 17.30 | 73.70 | Calor |
| 2020-12-23 21:54:28 | 17.30 | 73.80 | Calor |
| 2020-12-23 21:55:01 | 17.30 | 73.40 | Calor |
| 2020-12-23 21:55:31 | 17.40 | 74.00 | Calor |
| 2020-12-23 21:56:02 | 17.30 | 73.50 | Calor |
| 2020-12-23 21:56:32 | 17.30 | 71.50 | Calor |
| 2020-12-23 21:57:02 | 17.30 | 71.80 | Calor |
| 2020-12-23 21:57:33 | 17.30 | 70.70 | Calor |
| 2020-12-23 21:58:03 | 17.30 | 70.80 | Calor |
| 2020-12-23 21:58:33 | 17.30 | 71.10 | Calor |
| 2020-12-23 21:59:03 | 17.40 | 70.60 | Calor |
| 2020-12-23 21:59:34 | 17.30 | 69.20 | Calor |
| 2020-12-23 22:00:04 | 17.30 | 69.10 | Calor |
| 2020-12-23 22:00:34 | 17.30 | 68.00 | Calor |
| 2020-12-23 22:01:05 | 17.30 | 67.90 | Calor |
| 2020-12-23 22:01:35 | 17.30 | 67.40 | Calor |
| 2020-12-23 22:02:05 | 17.20 | 67.50 | Calor |
| 2020-12-23 22:02:36 | 17.20 | 67.60 | Calor |
| 2020-12-23 22:03:06 | 17.10 | 68.60 | Calor |
| 2020-12-23 22:03:36 | 17.10 | 69.30 | Calor |
| 2020-12-23 22:04:07 | 17.20 | 70.40 | Calor |
| 2020-12-23 22:04:37 | 17.20 | 70.90 | Calor |
| 2020-12-23 22:05:07 | 17.20 | 70.80 | Calor |
| 2020-12-23 22:05:38 | 17.20 | 68.90 | Calor |
| 2020-12-23 22:06:08 | 17.20 | 69.60 | Calor |
| 2020-12-23 22:06:38 | 17.20 | 69.40 | Calor |
| 2020-12-23 22:07:09 | 17.20 | 69.20 | Calor |
| 2020-12-23 22:07:39 | 17.20 | 68.20 | Calor |
| 2020-12-23 22:08:09 | 17.10 | 68.40 | Calor |
| 2020-12-23 22:08:39 | 17.10 | 68.30 | Calor |
| 2020-12-23 22:09:10 | 17.10 | 68.60 | Calor |
| 2020-12-23 22:09:40 | 17.10 | 69.00 | Calor |
| 2020-12-23 22:10:10 | 17.10 | 68.90 | Calor |
| 2020-12-23 22:10:41 | 17.10 | 69.90 | Calor |
| 2020-12-23 22:11:11 | 17.10 | 70.20 | Calor |
| 2020-12-23 22:11:41 | 17.10 | 69.60 | Calor |
| 2020-12-23 22:12:12 | 17.10 | 69.20 | Calor |
| 2020-12-23 22:12:42 | 17.10 | 68.60 | Calor |
| 2020-12-23 22:13:12 | 17.10 | 68.80 | Calor |
| 2020-12-23 22:13:43 | 17.10 | 68.50 | Calor |
| 2020-12-23 22:14:13 | 17.10 | 68.00 | Calor |
| 2020-12-23 22:14:43 | 17.10 | 68.30 | Calor |
| 2020-12-23 22:15:14 | 17.10 | 68.70 | Calor |
| 2020-12-23 22:15:44 | 17.00 | 68.40 | Calor |
| 2020-12-23 22:16:14 | 17.10 | 68.80 | Calor |
| 2020-12-23 22:16:44 | 17.10 | 69.60 | Calor |
| 2020-12-23 22:17:18 | 17.10 | 71.00 | Calor |
| 2020-12-23 22:17:48 | 17.00 | 67.50 | Calor |
| 2020-12-23 22:18:21 | 17.10 | 66.00 | Calor |
| 2020-12-23 22:18:51 | 17.00 | 67.90 | Calor |
| 2020-12-23 22:19:22 | 17.00 | 68.80 | Calor |
| 2020-12-23 22:19:52 | 16.90 | 69.70 | Frio |
| 2020-12-23 22:20:22 | 17.00 | 69.40 | Calor |
| 2020-12-23 22:20:53 | 16.90 | 70.50 | Frio |
| 2020-12-23 22:21:23 | 17.00 | 71.90 | Calor |
| 2020-12-23 22:21:53 | 16.60 | 70.00 | Frio |
| 2020-12-23 22:22:23 | 16.90 | 69.40 | Frio |
| 2020-12-23 22:22:54 | 16.90 | 69.20 | Frio |
| 2020-12-23 22:23:24 | 16.70 | 69.80 | Frio |
| 2020-12-23 22:23:54 | 16.80 | 68.80 | Frio |
| 2020-12-23 22:24:25 | 16.80 | 67.50 | Frio |
| 2020-12-23 22:24:55 | 16.80 | 67.50 | Frio |
| 2020-12-23 22:25:26 | 16.30 | 68.00 | Frio |
| 2020-12-23 22:25:56 | 16.70 | 69.00 | Frio |
| 2020-12-23 22:26:26 | 16.70 | 70.10 | Frio |
| 2020-12-23 22:26:57 | 16.80 | 71.30 | Frio |
| 2020-12-23 22:27:27 | 16.80 | 71.70 | Frio |
| 2020-12-23 22:27:57 | 17.00 | 72.60 | Calor |
| 2020-12-23 22:28:27 | 16.90 | 73.70 | Frio |
| 2020-12-23 22:28:58 | 17.30 | 73.90 | Calor |
| 2020-12-23 22:29:28 | 17.30 | 73.50 | Calor |
| 2020-12-23 22:29:58 | 17.30 | 72.20 | Calor |
| 2020-12-23 22:30:31 | 17.40 | 72.50 | Calor |
| 2020-12-23 22:31:02 | 17.30 | 72.40 | Calor |
| 2020-12-23 22:31:32 | 17.20 | 72.90 | Calor |
| 2020-12-23 22:32:02 | 17.20 | 73.60 | Calor |
| 2020-12-23 22:32:35 | 17.30 | 73.80 | Calor |
| 2020-12-23 22:33:06 | 17.50 | 73.90 | Calor |
| 2020-12-23 22:33:36 | 17.10 | 75.00 | Calor |
| 2020-12-23 22:34:06 | 17.30 | 74.90 | Calor |
| 2020-12-23 22:34:40 | 17.20 | 74.80 | Calor |
| 2020-12-23 22:35:10 | 17.30 | 74.70 | Calor |
| 2020-12-23 22:35:40 | 17.20 | 77.30 | Calor |
| 2020-12-23 22:36:11 | 17.50 | 75.10 | Calor |
| 2020-12-23 22:36:41 | 17.20 | 74.80 | Calor |
| 2020-12-23 22:37:11 | 17.50 | 75.10 | Calor |
| 2020-12-23 22:37:41 | 17.30 | 75.70 | Calor |
| 2020-12-23 22:38:12 | 17.40 | 75.30 | Calor |
| 2020-12-23 22:38:42 | 17.40 | 75.10 | Calor |
| 2020-12-23 22:39:12 | 17.40 | 75.30 | Calor |
| 2020-12-23 22:39:43 | 17.90 | 75.90 | Calor |
| 2020-12-23 22:40:13 | 17.40 | 76.10 | Calor |
| 2020-12-23 22:40:43 | 17.70 | 76.20 | Calor |
| 2020-12-23 22:41:14 | 17.40 | 76.10 | Calor |
| 2020-12-23 22:41:44 | 17.40 | 75.90 | Calor |
| 2020-12-23 22:42:14 | 17.40 | 76.10 | Calor |
| 2020-12-23 22:42:45 | 17.10 | 76.20 | Calor |
| 2020-12-23 22:43:15 | 17.60 | 77.20 | Calor |
| 2020-12-23 22:43:45 | 17.50 | 76.50 | Calor |
| 2020-12-23 22:44:16 | 17.30 | 76.70 | Calor |
| 2020-12-23 22:44:46 | 17.30 | 76.70 | Calor |
| 2020-12-23 22:45:16 | 17.30 | 77.00 | Calor |
| 2020-12-23 22:45:47 | 17.30 | 77.00 | Calor |
| 2020-12-23 22:46:17 | 17.60 | 77.40 | Calor |
| 2020-12-23 22:46:47 | 17.40 | 77.00 | Calor |
| 2020-12-23 22:47:18 | 17.50 | 77.00 | Calor |
| 2020-12-23 22:47:48 | 17.40 | 76.80 | Calor |
| 2020-12-23 22:48:21 | 17.50 | 77.10 | Calor |
| 2020-12-23 22:48:51 | 17.70 | 77.20 | Calor |
| 2020-12-23 22:49:21 | 17.50 | 77.10 | Calor |
| 2020-12-23 22:49:52 | 17.60 | 77.10 | Calor |
| 2020-12-23 22:50:22 | 17.50 | 77.50 | Calor |
| 2020-12-23 22:50:52 | 17.50 | 77.30 | Calor |
| 2020-12-23 22:51:23 | 18.30 | 77.80 | Calor |
| 2020-12-23 22:51:53 | 17.50 | 77.30 | Calor |
| 2020-12-23 22:52:23 | 17.50 | 77.70 | Calor |
| 2020-12-23 22:52:54 | 17.60 | 77.70 | Calor |
| 2020-12-23 22:59:02 | 17.60 | 78.00 | Calor |
| 2020-12-23 22:59:33 | 17.90 | 79.60 | Calor |
| 2020-12-23 23:00:03 | 17.90 | 78.10 | Calor |
| 2020-12-23 23:00:33 | 17.70 | 77.50 | Calor |
| 2020-12-23 23:01:04 | 17.90 | 77.50 | Calor |
| 2020-12-23 23:01:34 | 17.90 | 77.20 | Calor |
| 2020-12-23 23:02:04 | 17.90 | 77.40 | Calor |
| 2020-12-23 23:02:34 | 17.90 | 77.90 | Calor |
| 2020-12-23 23:03:05 | 17.90 | 78.10 | Calor |
| 2020-12-23 23:03:35 | 17.90 | 78.00 | Calor |
| 2020-12-23 23:04:05 | 17.90 | 79.00 | Calor |
| 2020-12-23 23:04:36 | 17.90 | 78.80 | Calor |
| 2020-12-23 23:05:06 | 17.80 | 78.10 | Calor |
| 2020-12-23 23:05:36 | 17.90 | 78.00 | Calor |
| 2020-12-23 23:06:07 | 17.90 | 77.80 | Calor |
| 2020-12-23 23:06:37 | 17.80 | 78.30 | Calor |
| 2020-12-23 23:07:07 | 17.70 | 78.50 | Calor |
| 2020-12-23 23:07:38 | 17.70 | 78.90 | Calor |
| 2020-12-23 23:08:08 | 17.80 | 78.90 | Calor |
| 2020-12-23 23:08:38 | 17.60 | 78.80 | Calor |
| 2020-12-24 08:45:21 | 17.10 | 78.60 | Calor |
| 2020-12-24 08:45:51 | 15.30 | 91.60 | Frio |
| 2020-12-24 08:46:22 | 15.30 | 91.90 | Frio |
| 2020-12-24 08:46:52 | 15.40 | 91.20 | Frio |
| 2020-12-24 08:47:23 | 15.30 | 90.50 | Frio |
| 2020-12-24 08:47:54 | 15.30 | 90.10 | Frio |
| 2020-12-24 08:48:24 | 15.40 | 90.20 | Frio |
| 2020-12-24 08:48:54 | 15.40 | 90.20 | Frio |
| 2020-12-24 08:49:24 | 15.40 | 90.30 | Frio |
| 2020-12-24 08:49:55 | 15.40 | 90.20 | Frio |
| 2020-12-24 08:50:25 | 15.40 | 90.00 | Frio |
| 2020-12-24 08:51:31 | 15.40 | 90.00 | Frio |
| 2020-12-24 08:52:01 | 15.30 | 90.10 | Frio |
| 2020-12-24 08:52:31 | 15.30 | 90.00 | Frio |
| 2020-12-24 08:53:02 | 15.20 | 90.00 | Frio |
| 2020-12-24 08:53:32 | 15.20 | 90.00 | Frio |
| 2020-12-24 08:54:02 | 15.20 | 90.10 | Frio |
| 2020-12-24 08:54:33 | 15.10 | 90.20 | Frio |
| 2020-12-24 08:55:03 | 15.10 | 90.10 | Frio |
| 2020-12-24 08:55:33 | 15.10 | 90.10 | Frio |
| 2020-12-24 08:56:04 | 15.10 | 90.40 | Frio |
| 2020-12-24 08:56:35 | 15.10 | 90.60 | Frio |
| 2020-12-24 08:57:05 | 15.20 | 90.40 | Frio |
| 2020-12-24 08:57:36 | 15.20 | 90.60 | Frio |
| 2020-12-24 08:58:06 | 15.20 | 90.50 | Frio |
| 2020-12-24 08:58:36 | 15.30 | 90.90 | Frio |
| 2020-12-24 08:59:06 | 15.30 | 90.80 | Frio |
| 2020-12-24 08:59:37 | 15.30 | 91.30 | Frio |
| 2020-12-24 09:00:07 | 15.40 | 90.90 | Frio |
| 2020-12-24 09:00:37 | 15.40 | 90.40 | Frio |
| 2020-12-24 09:01:08 | 15.40 | 90.40 | Frio |
| 2020-12-24 09:01:38 | 15.40 | 90.60 | Frio |
| 2020-12-24 09:02:08 | 15.40 | 90.70 | Frio |
| 2020-12-24 09:02:39 | 15.40 | 90.50 | Frio |
| 2020-12-24 09:03:10 | 15.40 | 91.30 | Frio |
| 2020-12-24 09:03:40 | 15.40 | 90.90 | Frio |
| 2020-12-24 09:04:11 | 15.40 | 90.80 | Frio |
| 2020-12-24 09:04:41 | 15.30 | 90.40 | Frio |
| 2020-12-24 09:05:11 | 15.20 | 89.60 | Frio |
| 2020-12-24 09:05:42 | 15.20 | 90.50 | Frio |
| 2020-12-24 09:06:12 | 15.20 | 90.10 | Frio |
| 2020-12-24 09:06:42 | 15.20 | 90.20 | Frio |
| 2020-12-24 09:07:13 | 15.30 | 89.90 | Frio |
| 2020-12-24 09:07:49 | 15.40 | 89.80 | Frio |
| 2020-12-24 09:08:19 | 15.30 | 90.40 | Frio |
| 2020-12-24 09:08:49 | 15.20 | 90.10 | Frio |
| 2020-12-24 09:09:19 | 15.10 | 90.00 | Frio |
| 2020-12-24 09:09:49 | 15.10 | 89.80 | Frio |
| 2020-12-24 09:10:21 | 15.10 | 90.70 | Frio |
| 2020-12-24 09:10:51 | 15.20 | 90.30 | Frio |
| 2020-12-24 09:11:21 | 15.20 | 90.50 | Frio |
| 2020-12-24 09:11:51 | 15.30 | 90.50 | Frio |
| 2020-12-24 09:12:22 | 15.20 | 90.40 | Frio |
| 2020-12-24 09:12:52 | 15.30 | 90.40 | Frio |
| 2020-12-24 09:13:23 | 15.30 | 90.10 | Frio |
| 2020-12-24 09:13:53 | 15.40 | 90.40 | Frio |
| 2020-12-24 09:14:23 | 15.40 | 90.40 | Frio |
| 2020-12-24 09:14:53 | 15.30 | 90.10 | Frio |
| 2020-12-24 09:15:27 | 15.30 | 89.40 | Frio |
| 2020-12-24 09:15:57 | 15.30 | 89.90 | Frio |
| 2020-12-24 09:16:27 | 15.20 | 90.00 | Frio |
| 2020-12-24 09:16:58 | 15.20 | 90.00 | Frio |
| 2020-12-24 09:17:28 | 15.10 | 89.80 | Frio |
| 2020-12-24 09:18:34 | 15.00 | 90.40 | Frio |
| 2020-12-24 09:19:04 | 15.00 | 90.40 | Frio |
| 2020-12-24 09:19:34 | 15.00 | 90.80 | Frio |
| 2020-12-24 11:35:15 | 15.50 | 91.00 | Frio |
| 2020-12-24 11:35:45 | 16.00 | 91.50 | Frio |
| 2020-12-24 11:36:16 | 13.70 | 90.90 | Frio |
| 2020-12-24 11:36:46 | 14.50 | 91.10 | Frio |
| 2020-12-24 11:37:16 | 15.60 | 91.30 | Frio |
| 2020-12-24 11:37:47 | 15.40 | 91.20 | Frio |
| 2020-12-24 11:38:17 | 15.40 | 91.30 | Frio |
| 2020-12-24 11:38:47 | 15.40 | 91.20 | Frio |
| 2020-12-24 11:39:17 | 15.40 | 91.00 | Frio |
| 2020-12-24 11:39:48 | 15.40 | 91.20 | Frio |
| 2020-12-24 11:40:18 | 13.70 | 90.70 | Frio |
| 2020-12-24 11:40:50 | 15.40 | 90.40 | Frio |
| 2020-12-24 11:41:20 | 15.40 | 90.70 | Frio |
| 2020-12-24 11:41:53 | 15.40 | 90.80 | Frio |
| 2020-12-24 11:42:24 | 15.50 | 90.60 | Frio |
| 2020-12-24 11:42:55 | 15.40 | 90.80 | Frio |
| 2020-12-24 11:43:25 | 15.40 | 90.40 | Frio |
| 2020-12-24 11:43:56 | 15.40 | 90.40 | Frio |
| 2020-12-24 11:44:27 | 15.40 | 90.40 | Frio |
| 2020-12-24 11:44:58 | 15.40 | 90.30 | Frio |
| 2020-12-24 11:45:28 | 15.40 | 90.30 | Frio |
| 2020-12-24 11:45:59 | 15.40 | 90.20 | Frio |
| 2020-12-24 11:46:31 | 15.40 | 90.10 | Frio |
| 2020-12-24 11:47:02 | 15.40 | 88.70 | Frio |
| 2020-12-24 11:47:33 | 15.50 | 88.90 | Frio |
| 2020-12-24 11:48:03 | 15.50 | 90.00 | Frio |
| 2020-12-24 11:48:34 | 15.50 | 90.20 | Frio |
| 2020-12-24 11:49:08 | 15.50 | 89.60 | Frio |
| 2020-12-24 11:49:38 | 15.50 | 89.20 | Frio |
| 2020-12-24 11:50:10 | 15.50 | 88.50 | Frio |
| 2020-12-24 11:50:43 | 15.50 | 89.10 | Frio |
| 2020-12-24 11:51:15 | 15.50 | 88.90 | Frio |
| 2020-12-24 11:51:45 | 15.60 | 89.10 | Frio |
| 2020-12-24 11:52:16 | 15.50 | 89.30 | Frio |
| 2020-12-24 11:52:47 | 15.50 | 89.20 | Frio |
| 2020-12-24 11:53:21 | 15.50 | 88.60 | Frio |
| 2020-12-24 11:53:51 | 15.50 | 87.80 | Frio |
| 2020-12-24 11:54:22 | 15.50 | 88.70 | Frio |
| 2020-12-24 11:54:53 | 15.50 | 88.90 | Frio |
| 2020-12-24 11:55:24 | 15.40 | 89.00 | Frio |
| 2020-12-24 11:55:54 | 15.40 | 88.70 | Frio |
| 2020-12-24 11:56:24 | 15.40 | 88.50 | Frio |
| 2020-12-24 11:56:55 | 15.40 | 87.50 | Frio |
| 2020-12-24 11:57:25 | 15.40 | 90.30 | Frio |
| 2020-12-24 11:57:55 | 15.40 | 88.80 | Frio |
| 2020-12-24 11:58:26 | 15.40 | 88.90 | Frio |
| 2020-12-24 11:58:56 | 15.20 | 88.40 | Frio |
| 2020-12-24 11:59:26 | 15.40 | 88.30 | Frio |
| 2020-12-24 11:59:57 | 15.40 | 88.30 | Frio |
| 2020-12-24 12:00:27 | 15.40 | 88.80 | Frio |
| 2020-12-24 12:00:57 | 15.40 | 87.60 | Frio |
| 2020-12-24 12:01:27 | 15.40 | 88.80 | Frio |
| 2020-12-24 12:01:58 | 15.30 | 89.30 | Frio |
| 2020-12-24 12:02:28 | 15.40 | 88.20 | Frio |
| 2020-12-24 12:02:58 | 15.40 | 88.40 | Frio |
| 2020-12-24 12:03:29 | 15.40 | 88.20 | Frio |
| 2020-12-24 12:04:00 | 15.40 | 87.80 | Frio |
| 2020-12-24 12:04:30 | 15.40 | 88.10 | Frio |
| 2020-12-24 12:05:01 | 15.50 | 87.60 | Frio |
| 2020-12-24 12:05:31 | 15.40 | 87.30 | Frio |
| 2020-12-24 12:06:01 | 15.40 | 86.30 | Frio |
| 2020-12-24 12:06:31 | 15.40 | 87.00 | Frio |
| 2020-12-24 12:07:02 | 15.40 | 87.30 | Frio |
| 2020-12-24 12:07:32 | 15.30 | 87.30 | Frio |
| 2020-12-24 12:08:04 | 15.30 | 85.90 | Frio |
| 2020-12-24 12:08:34 | 15.30 | 86.40 | Frio |
| 2020-12-24 12:09:41 | 15.30 | 86.70 | Frio |
| 2020-12-24 12:10:11 | 15.30 | 85.70 | Frio |
| 2020-12-24 12:10:41 | 15.30 | 85.90 | Frio |
| 2020-12-24 12:11:11 | 15.30 | 85.80 | Frio |
| 2020-12-24 12:11:42 | 15.30 | 85.00 | Frio |
| 2020-12-24 12:12:12 | 15.30 | 85.00 | Frio |
| 2020-12-24 12:12:42 | 15.20 | 85.90 | Frio |
| 2020-12-24 12:13:12 | 15.20 | 85.90 | Frio |
| 2020-12-24 12:13:43 | 15.20 | 84.20 | Frio |
| 2020-12-24 12:14:14 | 15.10 | 83.70 | Frio |
| 2020-12-24 12:14:44 | 15.20 | 85.40 | Frio |
| 2020-12-24 12:15:15 | 15.20 | 85.60 | Frio |
| 2020-12-24 12:15:45 | 15.20 | 86.00 | Frio |
| 2020-12-24 12:16:19 | 15.20 | 85.80 | Frio |
| 2020-12-24 12:16:50 | 15.20 | 86.10 | Frio |
| 2020-12-24 12:17:20 | 15.20 | 86.70 | Frio |
| 2020-12-24 12:17:50 | 15.20 | 85.30 | Frio |
| 2020-12-24 12:18:21 | 15.20 | 86.60 | Frio |
| 2020-12-24 12:18:51 | 15.20 | 85.80 | Frio |
| 2020-12-24 12:19:22 | 15.20 | 86.80 | Frio |
| 2020-12-24 12:19:52 | 15.20 | 86.30 | Frio |
| 2020-12-24 12:20:26 | 15.20 | 85.40 | Frio |
| 2020-12-24 12:20:59 | 15.20 | 86.70 | Frio |
| 2020-12-24 12:22:04 | 15.20 | 86.40 | Frio |
| 2020-12-24 12:22:35 | 15.20 | 85.10 | Frio |
| 2020-12-24 12:23:05 | 15.40 | 85.00 | Frio |
| 2020-12-24 12:23:36 | 15.30 | 86.70 | Frio |
| 2020-12-24 12:24:06 | 15.30 | 85.40 | Frio |
| 2020-12-24 12:24:36 | 15.30 | 85.30 | Frio |
| 2020-12-24 12:25:07 | 15.30 | 84.50 | Frio |
| 2020-12-24 12:25:38 | 15.30 | 82.60 | Frio |
| 2020-12-24 12:26:08 | 15.30 | 84.30 | Frio |
| 2020-12-24 12:26:39 | 15.40 | 84.60 | Frio |
+---------------------+-------------+----------+----------------------------------------+
433 rows in set (0.001 sec)
MariaDB [dht_log]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment