1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
| CREATE TABLE station_x
(
id INT PRIMARY KEY AUTO_INCREMENT,
dateEnregistrement DATETIME NOT NULL,
valA DECIMAL(10,2) NOT NULL,
valB DECIMAL(10,2) NOT NULL,
valC DECIMAL(10,2) NOT NULL,
valD DECIMAL(10,2) NOT NULL,
valE DECIMAL(10,2) NOT NULL,
valF DECIMAL(10,2) NOT NULL,
valG DECIMAL(10,2) NOT NULL,
valH DECIMAL(10,2) NOT NULL,
valI DECIMAL(10,2) NOT NULL,
valJ DECIMAL(10,2) NOT NULL,
valK DECIMAL(10,2) NOT NULL
);
CREATE TABLE station_y
(
id INT PRIMARY KEY AUTO_INCREMENT,
dateEnregistrement DATETIME NOT NULL,
valA DECIMAL(10,2) NOT NULL,
valB DECIMAL(10,2) NOT NULL,
valC DECIMAL(10,2) NOT NULL,
valD DECIMAL(10,2) NOT NULL,
valE DECIMAL(10,2) NOT NULL,
valF DECIMAL(10,2) NOT NULL,
valG DECIMAL(10,2) NOT NULL,
valH DECIMAL(10,2) NOT NULL,
valI DECIMAL(10,2) NOT NULL,
valJ DECIMAL(10,2) NOT NULL,
valK DECIMAL(10,2) NOT NULL
);
CREATE TABLE all_station
(
id INT PRIMARY KEY AUTO_INCREMENT,
station VARCHAR(55) NOT NULL,
mesure VARCHAR(55) NOT NULL,
valMax DECIMAL(10,2) NOT NULL,
dateMax DATETIME NOT NULL,
valMin DECIMAL(10,2) NOT NULL,
dateMin DATETIME NOT NULL
);
INSERT INTO station_x VALUES
(null, '2020-12-02 00:00:00', 4, 8, 9.4, 12, 15, 16.7, 89.2, 14, 0.3, 45, 4.8),
(null, '2020-12-02 00:00:00', 7, 5, 4.2, 7.9, 45, 14.2, 85.3, 14, 1, 37.8, 5),
(null, '2020-12-02 00:00:00', 2, 2.8, 4.6, 14.2, 28, 26, 52.1, 7.6, 1.6, 42.2, 4.6),
(null, '2020-11-30 00:00:00', 4.6, 25, 4.6, 15, 26.3, 78, 45, 24, 12.3, 0.8, 14),
(null, '2020-11-25 00:00:00', 8.6, 56.2, 4.3, 12, 23.6, 45, 12.3, 78, 12.69, 48, 52.3),
(null, '2020-11-12 00:00:00', 45, 12.3, 0.2, 15, 1, 4, 85, 2, 12, 12.3, 4),
(null, '2020-11-07 00:00:00', 12.6, 5, 45, 23.6, 96.5, 10, 0.2, 12, 36, 74.38, 5),
(null, '2020-11-01 00:00:00', 12, 0.8, 45, 36.1, 28.4, 14, 11, 0.45, 23, 52.3, 9.5),
(null, '2020-10-28 00:00:00', 11.5, 1.6, 8, 23, 14.7, 65, 12.5, 0.78, 2, 7, 52),
(null, '2020-10-26 00:00:00', 3.6, 5, 58, 8, 5.41, 5, 4.2, 8.6, 56, 23.4, 45.85);
INSERT INTO station_y VALUES
(null, '2020-12-02 00:00:00', 4, 8, 9.4, 12, 15, 16.7, 89.2, 14, 0.3, 45, 4.8),
(null, '2020-12-02 00:00:00', 7, 5, 4.2, 7.9, 45, 14.2, 85.3, 14, 1, 37.8, 5),
(null, '2020-12-02 00:00:00', 2, 2.8, 4.6, 14.2, 28, 26, 52.1, 7.6, 1.6, 42.2, 4.6),
(null, '2020-11-30 00:00:00', 4.6, 25, 4.6, 15, 26.3, 78, 45, 24, 12.3, 0.8, 14),
(null, '2020-11-25 00:00:00', 8.6, 56.2, 4.3, 12, 23.6, 45, 12.3, 78, 12.69, 48, 52.3),
(null, '2020-11-12 00:00:00', 45, 12.3, 0.2, 15, 1, 4, 85, 2, 12, 12.3, 4),
(null, '2020-11-07 00:00:00', 12.6, 5, 45, 23.6, 96.5, 10, 0.2, 12, 36, 74.38, 5),
(null, '2020-11-01 00:00:00', 12, 0.8, 45, 36.1, 28.4, 14, 11, 0.45, 23, 52.3, 9.5),
(null, '2020-10-28 00:00:00', 11.5, 1.6, 8, 23, 14.7, 65, 12.5, 0.78, 2, 7, 52),
(null, '2020-10-26 00:00:00', 3.6, 5, 58, 8, 5.41, 5, 4.2, 8.6, 56, 23.4, 45.85); |
Partager