![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Data Statistics&Analysis
以十
装饰过去,构造现在,设计未来
展开
-
python3数据统计模版-mysql
#!/Users/zuojingang/python_venv/bin/python3.6 # -*- coding: UTF-8 -*- import pymysql import sys import time import os from datetime import timedelta,datetime #连接数据库 connect = pymysql.connect(host=''...原创 2018-06-12 10:33:22 · 231 阅读 · 0 评论 -
python3简单查询Cassandra
#!/Users/zuojingang/python_venv/bin/python3.6 # -*- coding: UTF-8 -*- import sys import time import os from datetime import timedelta,datetime from cassandra.cluster import Cluster # from cassandra.q...原创 2018-06-12 10:53:21 · 1914 阅读 · 1 评论 -
今天遇到一个问题,mysql取分组前几条数据
亲测无误 DROP TEMPORARY TABLE IF EXISTS tableWithRowNum; CREATE TEMPORARY TABLE tableWithRowNum SELECT @rownum := @rownum + 1 AS rowNum, b.* FROM ( SELECT @rownum := 0 AS rowNum ) a, ( SELE...原创 2018-08-02 16:55:06 · 659 阅读 · 3 评论