SELECT action param params device_id city_id date_start date_end durat

1
2
3
4
5
6
SELECT `action`, `param`, `params`, `device_id`, `city_id`, `date_start`, `date_end`, `duration` FROM `statistic_prolonged_partition` WHERE YEAR(`date_start`) = 2018 INTO OUTFILE '/Users/lloyd/prolonged.txt';
SELECT `action`, `param`, `params`, `device_id`, `city_id`, `date` FROM `statistic_prolonged_partition` INTO OUTFILE '/Users/lloyd/hit';
LOAD DATA INFILE '/Users/lloyd/statistic.txt' INTO TABLE `statistic_prolonged_partition` (`action`, `param`, `params`, `device_id`, `city_id`, `date_start`, `date_end`, `duration`);
LOAD DATA INFILE '/Users/lloyd/hit.txt' INTO TABLE `statistic_prolonged_partition` (`action`, `param`, `params`, `device_id`, `city_id`, `date`);