By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test_data (
UNIQUE_ID bigint(11) NOT NULL,
DEVICE_NAME varchar(128) NOT NULL DEFAULT '',
PARAMETER_NAME varchar(256) DEFAULT NULL,
GMT_OFFSET varchar(6) DEFAULT NULL,
CHECK_TIME datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
OUTPUT_DATA text NOT NULL,
PERF_DATA text NOT NULL,
PRIMARY KEY (UNIQUE_ID)
);
CREATE TABLE test_arc (
UNIQUE_ID bigint(11) NOT NULL,
DEVICE_NAME varchar(128) NOT NULL DEFAULT '',
PARAMETER_NAME varchar(256) DEFAULT NULL,
GMT_OFFSET varchar(6) DEFAULT NULL,
CHECK_TIME datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
OUTPUT_DATA text NOT NULL,
PERF_DATA text NOT NULL,
PRIMARY KEY (UNIQUE_ID)
);
INSERT INTO test_data VALUES
(1643929202000474, 'abc12780', 'win_cpu_wmi_do', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202002959, 'abc12781', 'net_iface_poller_v3_la', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202004005, 'abc12782', 'net_ping', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202004801, 'abc12783', 'win_cpu_wmi_do', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202005819, 'abc12784', 'ora_tablespaceusage_ora', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202006857, 'abc12785', 'win_mem_wmi_do', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202007283, 'abc12786', 'win_diskio_C_wmi_do', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202007926, 'abc12787', 'net_iface_poller_v3_la', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202008595, 'abc12788', 'win_diskio_C_wmi_do', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202009618, 'abc12789', 'win_diskio_C_wmi_do', '01', '2022-02-04 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202010452, 'abc12780', 'win_cpu_wmi_do', '01', '2022-02-05 00:00:02', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202010827, 'abc12781', 'net_iface_poller_v3_la', '01', '2022-02-05 00:00:03', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202011389, 'abc12782', 'net_ping', '01', '2022-02-05 00:00:04', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202011671, 'abc12783', 'win_cpu_wmi_do', '01', '2022-02-05 00:00:05', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202011938, 'abc12784', 'ora_tablespaceusage_ora', '01', '2022-02-05 00:00:06', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202012196, 'abc12785', 'win_mem_wmi_do', '01', '2022-02-05 00:00:07', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202012459, 'abc12786', 'win_diskio_C_wmi_do', '01', '2022-02-05 00:00:08', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202012558, 'abc12787', 'net_iface_poller_v3_la', '01', '2022-02-05 00:00:09', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202012787, 'abc12788', 'win_diskio_C_wmi_do', '01', '2022-02-05 00:00:10', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202013300, 'abc12789', 'win_diskio_C_wmi_do', '01', '2022-02-05 00:00:11', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202013608, 'abc12780', 'win_cpu_wmi_do', '01', '2022-02-05 00:00:12', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202014260, 'abc12781', 'net_iface_poller_v3_la', '01', '2022-02-05 00:00:13', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202015194, 'abc12782', 'net_ping', '01', '2022-02-05 00:00:14', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202016096, 'abc12783', 'win_cpu_wmi_do', '01', '2022-02-05 00:00:15', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202017440, 'abc12784', 'ora_tablespaceusage_ora', '01', '2022-02-05 00:00:16', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202019088, 'abc12785', 'win_mem_wmi_do', '01', '2022-02-05 00:00:17', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202019184, 'abc12786', 'win_diskio_C_wmi_do', '01', '2022-02-05 00:00:18', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202020615, 'abc12787', 'net_iface_poller_v3_la', '01', '2022-02-05 00:00:19', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202020726, 'abc12788', 'win_diskio_C_wmi_do', '01', '2022-02-05 00:00:20', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202022100, 'abc12789', 'win_diskio_C_wmi_do', '01', '2022-02-05 00:00:21', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202022990, 'abc12780', 'win_cpu_wmi_do', '01', '2022-02-05 00:00:22', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202023928, 'abc12781', 'net_iface_poller_v3_la', '01', '2022-02-05 00:00:23', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202024403, 'abc12782', 'net_ping', '01', '2022-02-05 00:00:24', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202024847, 'abc12783', 'win_cpu_wmi_do', '01', '2022-02-05 00:00:25', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
(1643929202026175, 'abc12784', 'ora_tablespaceusage_ora', '01', '2022-02-05 00:00:26', 'status', 'Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95;'),
select * from test_data;
| UNIQUE_ID | DEVICE_NAME | PARAMETER_NAME | GMT_OFFSET | CHECK_TIME | OUTPUT_DATA | PERF_DATA |
|---|---|---|---|---|---|---|
| 1643929202000474 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202002959 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202004005 | abc12782 | net_ping | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202004801 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202005819 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202006857 | abc12785 | win_mem_wmi_do | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202007283 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202007926 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202008595 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202009618 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-04 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202010452 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202010827 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:03 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202011389 | abc12782 | net_ping | 01 | 2022-02-05 00:00:04 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202011671 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:05 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202011938 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-05 00:00:06 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202012196 | abc12785 | win_mem_wmi_do | 01 | 2022-02-05 00:00:07 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202012459 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:08 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202012558 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:09 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202012787 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:10 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202013300 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:11 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202013608 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:12 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202014260 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:13 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202015194 | abc12782 | net_ping | 01 | 2022-02-05 00:00:14 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202016096 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:15 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202017440 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-05 00:00:16 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202019088 | abc12785 | win_mem_wmi_do | 01 | 2022-02-05 00:00:17 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202019184 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:18 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202020615 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:19 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202020726 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:20 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202022100 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:21 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202022990 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:22 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202023928 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:23 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202024403 | abc12782 | net_ping | 01 | 2022-02-05 00:00:24 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202024847 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:25 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202026175 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-05 00:00:26 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202027148 | abc12785 | win_mem_wmi_do | 01 | 2022-02-05 00:00:27 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202028012 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:28 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202029066 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:29 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202029992 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:30 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202031360 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:31 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202032019 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:32 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202033074 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:33 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202033949 | abc12782 | net_ping | 01 | 2022-02-05 00:00:34 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202034203 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:35 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202035442 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-05 00:00:36 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202035728 | abc12785 | win_mem_wmi_do | 01 | 2022-02-05 00:00:37 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202036155 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:38 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202038944 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:39 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202039323 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:40 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202040336 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:41 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202040776 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:42 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202041336 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:43 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202041974 | abc12782 | net_ping | 01 | 2022-02-05 00:00:44 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202042495 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:45 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202043266 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-05 00:00:46 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202044215 | abc12785 | win_mem_wmi_do | 01 | 2022-02-05 00:00:47 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202044909 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:48 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202045684 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:49 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202050068 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:50 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202050553 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:51 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202051122 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:52 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202051590 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:53 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202052338 | abc12782 | net_ping | 01 | 2022-02-05 00:00:54 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202052588 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-05 00:00:55 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202052849 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-05 00:00:56 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202053115 | abc12785 | win_mem_wmi_do | 01 | 2022-02-05 00:00:57 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202053336 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-05 00:00:58 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202053648 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-05 00:00:59 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202053894 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:01 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202054151 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:02 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202054404 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-06 00:00:03 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202054708 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-06 00:00:04 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202054984 | abc12782 | net_ping | 01 | 2022-02-06 00:00:05 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202055259 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-06 00:00:06 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202058651 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-06 00:00:07 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202058947 | abc12785 | win_mem_wmi_do | 01 | 2022-02-06 00:00:08 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202059219 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:09 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202059723 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-06 00:00:10 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202060389 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:11 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202060772 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:12 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202061102 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-06 00:00:13 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202062011 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-06 00:00:14 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202063310 | abc12782 | net_ping | 01 | 2022-02-06 00:00:15 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202063571 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-06 00:00:16 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202063806 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-06 00:00:17 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202064498 | abc12785 | win_mem_wmi_do | 01 | 2022-02-06 00:00:18 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202064766 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:19 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202065072 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-06 00:00:20 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202065339 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:21 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202065592 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:22 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202066034 | abc12780 | win_cpu_wmi_do | 01 | 2022-02-06 00:00:23 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202066557 | abc12781 | net_iface_poller_v3_la | 01 | 2022-02-06 00:00:24 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202066856 | abc12782 | net_ping | 01 | 2022-02-06 00:00:25 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202067116 | abc12783 | win_cpu_wmi_do | 01 | 2022-02-06 00:00:26 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202067332 | abc12784 | ora_tablespaceusage_ora | 01 | 2022-02-06 00:00:27 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202067544 | abc12785 | win_mem_wmi_do | 01 | 2022-02-06 00:00:28 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202067755 | abc12786 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:29 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202068492 | abc12787 | net_iface_poller_v3_la | 01 | 2022-02-06 00:00:30 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202068782 | abc12788 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:31 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
| 1643929202068988 | abc12789 | win_diskio_C_wmi_do | 01 | 2022-02-06 00:00:32 | status | Physical Memory Used=18789924864B; Physical Memory Utilisation=73%;90;95; |
set @start_date = '2022-01-01 00:00:00';
SELECT @start_date;
| @start_date |
|---|
| 2022-01-01 00:00:00 |
set @report_date=STR_TO_DATE('2022-02-05','%Y-%m-%d');
SELECT @report_date;
| @report_date |
|---|
| 2022-02-05 |
set @report_date1=STR_TO_DATE(MIN(check_time),'%Y-%m-%d') AS DATE from test_data;
SELECT @report_date1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS DATE from test_data;
SELECT @report_date1' at line 1
SET @enddate = NOW();
SELECT @enddate;
| @enddate |
|---|
| 2022-02-22 06:00:16 |
SELECT COUNT(*) from test_data where check_time>@report_date and check_time<@enddate
| COUNT(*) |
|---|
| 90 |
SET @interval=@report_date+INTERVAL 1 DAY;
SELECT @interval;
| @interval |
|---|
| 2022-02-06 |
CREATE PROCEDURE `insert_data` ()
BEGIN
DECLARE intervals DATETIME DEFAULT @interval;
DECLARE mindate DATETIME DEFAULT @start_date;
DECLARE maxdate DATETIME DEFAULT @enddate;
DECLARE i DATETIME DEFAULT ;
WHILE maxdate< mindate DO
INSERT INTO test_arc
SELECT * FROM test_data
ORDER BY check_time ASC
LIMIT i, limitSize
ON DUPLICATE KEY UPDATE UNIQUE_ID=VALUES(UNIQUE_ID), check_time=VALUES(check_time);
SET mindate = mindate + @interval;
END WHILE;
END
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
WHILE maxdate< mindate DO
INSERT INTO test_arc
SELECT * FROM te' at line 6
select * from test_arc;