I have MySQL table named datas
and column like this:
id int(11)
currency varchar(16)
date_time (datetime)
Example data:
id currency date_time
--------- ------------ ---------------------
12 EURUSD 2019-01-28 11:19:26
13 EURUSD 2019-01-28 11:19:29
14 EURUSD 2019-01-28 11:19:34
15 EURUSD 2019-01-28 11:19:38
16 EURUSD 2019-01-28 11:19:49
17 GBPUSD 2019-01-28 11:19:23
18 GBPUSD 2019-01-28 11:19:27
19 GBPUSD 2019-01-28 11:19:39
20 GBPUSD 2019-01-28 11:19:45
21 GBPUSD 2019-01-28 11:19:57
Must be like this (delete another in one minute only one row in each currency):
12 EURUSD 2019-01-28 11:19:26
17 GBPUSD 2019-01-28 11:19:23
And my program inserting rows about every 3-6 seconds. but I want to keep only 1 currency price in 1 minute, and I want to delete others.
How can I do it with a MySQL query? I'm using PHP.
My cron jobs will works every 15 minutes. with php will work this query.
MySQL version = 5.7.25