暗淡了时光

记录用户的播放记录时：1）当用户没有播放过这一条音频的时候新增一条记录2）当用户播放过这一条音频时，则播放次数加一表设计如下：sql语句如下：INSERT INTO playrecord (uid,fileId,time,playtimes) VALUES (#{uid}, #{fileId}, #{time},1) ON DUPLICATE KEY UPDATE time=#{time}, pl...

select ip, created_at, customer_id from (select * from customer_activity_log where op_code = 2000 GROUP BY customer_id ,created_at desc) as base group by customer_id