Changes between Version 22 and Version 23 of Partitioning

Timestamp:

11/05/25 20:21:06 (3 weeks ago)

Author:

222039

Comment:

--

Partitioning

@@ -106 +106 @@
 }}}
 
+Архивирање на стари податоци (Опција: Креирање на Архивска табела):
+{{{#!div
+{{{#!sql
+CREATE TABLE weatherdata_archive_2024_01 LIKE weatherdata;
+ALTER TABLE weatherdata_archive_2024_01 REMOVE PARTITIONING;
+
+-- Move data from partition to archive
+INSERT INTO weatherdata_archive_2024_01
+SELECT * FROM weatherdata PARTITION (p_2024_01);
+
+-- Drop partition from weatherdata
+ALTER TABLE weatherdata DROP PARTITION p_2024_01;
+}}}
+}}}
+
 == Тестирање и Перформанси