mysql query for selecting the result from one table and inserting in another table -

this question has answer here:

• mysql query selecting result of condition of 1 table , showing on table [closed] 1 answer
• mysql query selecting result of condition of 1 table , showing on table 2 answers

sir..can u plz tell me query plz

table1

-------------------------------- stock_name|temple|quantity|type -------------------------------- rice      |shiva |  32    |purchase rice      |shiva |  10    |issue wheat     |ganesh|  50    | purchase wheat     |ganesh|  45    | issue    ghee      |ganesh|  50    | purchase ghee      |ganesh|   5    | issue    

expected output in table2

-------------------------------- stock_name|temple|quantity| -------------------------------- rice      |shiva |  22    | wheat     |ganesh|  5     |  ghee      |ganesh|  45    | 

and here same answer in every other question posted

insert secondtable (stock_name,temple,quantity) select  stock_name,         temple,         sum(case when type = 'purchase'                       quantity                       else quantity * -1                   end) quantity    firsttable group   stock_name, temple