Se connecter root, sur MariaDB 10, puis sur la base domo
SELECT * FROM graph_tbl WHERE ftimestamp
< ‘2023-11-01 00:00:00’
create table graph_tbl_2022_1101_2023_1030
as SELECT * FROM graph_tbl WHERE ftimestamp
< ‘2023-11-01 00:00:00’
delete FROM graph_tbl WHERE ftimestamp
< ‘2023-11-01 00:00:00’
CREATE UNIQUE INDEX idx_mesure ON graph_tbl
(ffeed(15),ftimestamp)2022_1101_2023_1030
drop INDEX idx_mesure ON graph_tbl
CREATE UNIQUE INDEX idx_mesure ON graph_tbl
(ffeed(15),ftimestamp)
———————————————————-
create table graph_conso_2022_1001
as SELECT * FROM graph_conso WHERE ftimestamp
< ‘2022-10-01 00:00:00’
delete FROM graph_conso WHERE ftimestamp
< ‘2022-10-01 00:00:00’
CREATE UNIQUE INDEX idx_mesure ON graph_conso_2022_1001
(ffeed(15),ftimestamp)
drop INDEX idx_mesure ON graph_conso
CREATE UNIQUE INDEX idx_mesure ON graph_conso
(ffeed(15),ftimestamp)