- 博客(4)
- 收藏
- 关注
原创 删除重复数据mysql
DELETE FROM draw_imgflowface USING draw_imgflowface,( SELECT DISTINCT MIN(`id`) AS `id`,img FROM draw_imgflowface GROUP BY imgData HAVING COUNT(imgData) > 1 ) AS `t2` WHERE draw_imgflow
2014-11-20 16:25:23 328
原创 按照日期统计每天用户数量
SELECT count(distinct userNum) as newcount,date(from_unixtime(addtime)) as time FROM `userlist` group by date(from_unixtime(addtime))
2014-11-13 14:05:08 3198
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人