1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| create table T1
( T1ident integer auto_increment primary key
, T1sensor char(06) not null
, T1location varchar(50) not null
, T1val1 decimal(5,2) not null
, T1val2 decimal(5,2) not null
, T1val3 decimal(5,2) not null
, T1dth datetime not null
)
;
insert into T1
(T1sensor, T1location, T1val1, T1val2, T1val3, T1dth)
values ('BME280', 'location 01', 095.25, 089.55, 044.00, '2023-11-14 09:35:21')
, ('BME280', 'location 01', 107.41, 078.04, 055.61, '2023-11-14 11:44:56')
, ('BME280', 'location 01', 088.69, 082.17, 051.55, '2023-11-12 08:16:40')
, ('BME280', 'location 01', 100.02, 082.55, 048.22, '2023-11-12 14:30:02')
, ('BME280', 'location 01', 111.80, 084.08, 047.73, '2023-11-11 09:08:34')
, ('BME280', 'location 01', 106.23, 079.79, 049.58, '2023-11-08 16:12:05')
, ('BME282', 'location 01', 085.40, 106.14, 045.82, '2023-11-14 11:44:56')
, ('BME282', 'location 01', 088.30, 105.22, 041.47, '2023-11-14 08:16:40')
, ('BME282', 'location 01', 084.22, 102.89, 038.33, '2023-11-12 14:30:02')
, ('BME282', 'location 01', 091.91, 104.76, 040.06, '2023-11-12 09:08:34')
, ('BME282', 'location 01', 087.65, 103.03, 042.50, '2023-11-12 16:12:05')
; |
Partager