Open YohLee opened 7 years ago
SELECT FROM_UNIXTIME(create_time) FROM bonus_user_record ----秒转日期 SELECT UNIX_TIMESTAMP(LastExtractDateTime) ----日期转秒 ServerReceiveDate=DATE('2017-09-13') ---日期格式化 DATE_FORMAT(ServerReceiveTime,'%k') ---格式化时间为(0-23) SELECT DATE_FORMAT(NOW(),'%Y-%m-%d'); SELECT STR_TO_DATE(order_sn,'%Y%m%d') date_add(a4.push_time, INTERVAL 7 DAY) CURDATE() ---当日
date_add(t1.send_time,INTERVAL 7 day)
SELECT WEEK(date_add('2012-12-31',interval6 day),2); ----获取日期所在为一年中的第几周
Scrapy scrapy startproject tuniu scrapy genspider crawl_tuniu "tuniu.com"
Python 爬虫ip代理网址
http://lwons.com/wx
http://www.xicidaili.com/nn/
http://www.xicidaili.com/wn/
http://www.66ip.cn/nmtq.php?getnum=800&isp=0&anonymoustype=4&start=&ports=&export=&ipaddress=&area=1&proxytype=0&api=66ip
http://www.kuaidaili.com/proxylist/%s/
http://www.66ip.cn/
http://www.ip181.com/
http://www.cz88.net/
http://www.cnproxy.com/
https://www.liaoxuefeng.com/wiki/0014316089557264a6b348958f449949df42a6d3a2e542c000 -----python教程
http://www.pythondoc.com/pythontutorial3/controlflow.html ---python教程
http://www.ppvke.com/Blog/archives/47569 --爬虫项目
http://simple-is-better.com/sites/ -------python 技术博客、开源项目、框架等
Azkaban//Apache Oozie 批量工作流任务调度器