Changes between Version 25 and Version 26 of Анализа

Timestamp:

02/02/26 22:04:51 (4 days ago)

Author:

222039

Comment:

--

Анализа

@@ -90 +90 @@
 LIMIT 1000
 }}}
+
+Q4 - Insert
+{{{
+INSERT INTO weatherdata_copy (log_date, time, station, temp, humidity, airpressure, wind, visibility, winddirection)
+VALUES (
+    CONCAT('2025-', LPAD(${RANDOM_MONTH}, 2, '0'), '-', LPAD(${RANDOM_DAY}, 2, '0')),
+    '12:00:00',
+    ${RANDOM_STATION},
+    ROUND(${__Random(0,35)}.${__Random(0,9)}, 2),
+    ROUND(${__Random(30,95)}.${__Random(0,9)}, 2),
+    ROUND(${__Random(950,1050)}.${__Random(0,99)}, 2),
+    ROUND(${__Random(0,50)}.${__Random(0,99)}, 2),
+    NULL,
+    ROUND(${__Random(0,359)})
+) ON DUPLICATE KEY UPDATE 
+    temp = VALUES(temp),
+    humidity = VALUES(humidity),
+    pressure = VALUES(pressure)
+}}}
+
+Q5 - Update
+{{{
+UPDATE weatherdata_copy
+SET temp = ROUND(temp + 0.1, 2),
+    humidity = ROUND(humidity * 1.02, 2),
+    pressure = ROUND(pressure + 0.5, 2)
+WHERE log_date = '2024-06-15'
+  AND station = ${RANDOM_STATION}
+LIMIT 500
+}}}
+
+Q6 - Delete 
+{{{
+DELETE FROM weatherdata_copy
+WHERE log_date < '2020-06-01'
+LIMIT 1000
+}}}
+