mysql : get data from query with select insert

Asked Nov 25 '16 at 07:00

Active Nov 25 '16 at 08:09

Viewed 59 times

Iam having query below

   SELECT cookie_name,SUBTIME( CURTIME() , min( time ) ) AS spent ,date, sum( cookie_view ) AS views FROM cookie_table GROUP BY cookie_name, date HAVING sum( cookie_view ) =1

For this query i got data like this

         cookie_name     spent               date   views   
         5gm7aXUvkbhh   00:25:44.000000     25/11/16    1
         ZR7929L32Bq    00:28:30.000000     25/11/16    1

From this data i want to get day wise report i.e; how many names and how many views spent with in 0-1min,1-2min and >2min like

        views  time  cookie_name  date
         -      0-1     -          -
         -      1-2     -          -
         2      >2      2      25/11/16

For this report i want to sore this data to duplicate table? how ?give any suggestion

edited Nov 25 '16 at 08:09

asked Nov 25 '16 at 07:00

you hope for output including "name" and yet do not include where such a value could come from – WEBjuju Nov 25 '16 at 07:06
cookie_name @WEBjuju – Nov 25 '16 at 07:10
take a look at one of the many answers on grouping/summing time in mysql http://stackoverflow.com/questions/4102480/mysql-how-to-sum-a-timediff-on-a-group – WEBjuju Nov 25 '16 at 07:14
i want to store that first query data in other table? – Nov 25 '16 at 07:18

mysql : get data from query with select insert

0 Answers0