mysql 求累加 用户

 

 

// 求累加 用户

SELECT a.id,a.money,SUM(lt.money)  as cum
FROM cum_demo a JOIN cum_demo lt
ON a.id >= lt.id
GROUP BY a.money
ORDER BY id

INSERT INTO `dk_user_analysis_test` (`id`, `date_name`, `new_user`, `type_flag`) SELECT `id`, `date_name`, `new_user`, `type_flag` FROM `dk_user_day_analysis` WHERE `type_flag` = 5

SELECT `dku`.`id`,`dku`. `date_name`, `dku`.`new_user`, SUM(`dktmp`.`new_user`) AS `totalUser`
FROM `dk_user_day_analysis` AS `dku` JOIN `dk_user_day_analysis` AS `dktmp`
ON `dku`.`id` >= `dktmp`.`id`
WHERE `dku`.`type_flag` = 5
GROUP BY `dku`.`new_user`
ORDER BY `id` ASC

// 正确。
SELECT SUM(`dktmp`.`new_user`) AS `totalUser`,`dku`.`id` FROM `dk_user_analysis_test` AS `dku` JOIN `dk_user_analysis_test` AS `dktmp` ON `dku`.`id` >= `dktmp`.`id` GROUP BY `dku`.`date_name` ORDER BY `id` ASC



SELECT a.id,a.money,SUM(lt.money)  as cum
FROM cum_demo a JOIN cum_demo lt
ON a.id >= lt.id
GROUP BY a.money
ORDER BY id

 

 

SELECT SUM( `dktmp`. `new_user`) AS `totalUser`, `dku`. `id` FROM `dk_user_day_reports` AS `dku` JOIN `dk_user_day_reports` AS `dktmp` ON `dku`. `id` >= `dktmp`. `id` WHERE `dku`. `type_flag` = 6 GROUP BY `dku`. `date_name` ORDER BY `id` ASC

UPDATE `dk_user_day_reports` SET `total_user`= 70183 WHERE `id`= 157 ;