How can Update table column with the virtual column?
I solved it this way :

INSERT INTO game_log (game_detail,user_id,game_id,day_number)
select  sum(game_detail) As game_datail,user_id,game_id,0   from game_log group by user_id,game_id


--

DELETE FROM game_log where day_number != 0