摘要: Comparing Neo4j driver, py2neo and neo4jrestclient with some basic commands using the Panama Papers Data RHFollow May 6, 2017 1. Before we begin In ou 阅读全文
posted @ 2019-01-24 17:39 AngDH 阅读(1395) 评论(0) 推荐(1)
摘要: SELECT ID,SERVICE FROM new_schedules_spider_full WHERE SERVICE = 'WSA2' and date_sub(curdate(), interval 7 day) <= date(CREATE_TIME); 阅读全文
posted @ 2019-01-18 10:20 AngDH 阅读(2277) 评论(0) 推荐(0)
摘要: 紧挨着 组合 a b c d > ab ,bc ,cd 第一个 ,分别 与 后面的组合 a b c d > ab,ac,ad 阅读全文
posted @ 2019-01-16 16:39 AngDH 阅读(1165) 评论(0) 推荐(0)
摘要: eta_temp = one['arrival'].encode('utf-8')fd = datetime.datetime.strptime(eta_temp, "%Y-%m-%dT%H:%M:%SZ")# 加8后的时间eta = (fd + datetime.timedelta(hours=8 阅读全文
posted @ 2019-01-15 14:11 AngDH 阅读(2986) 评论(0) 推荐(0)
摘要: https://www.aliyun.com/jiaocheng/437481.html 阅读全文
posted @ 2019-01-13 13:30 AngDH 阅读(151) 评论(0) 推荐(0)
摘要: 阅读全文
posted @ 2019-01-10 00:42 AngDH 阅读(79) 评论(0) 推荐(0)
摘要: optionList = doc.xpath("//*[@id='schedules_vessel_tracing_f:hl16']/option[position()>1]")对位置大于1 的option 提取 .get('value') 获取value 的值 doc.xpath("//ul[st 阅读全文
posted @ 2019-01-08 14:37 AngDH 阅读(348) 评论(0) 推荐(0)
摘要: 报错 Operand should contain 1 column(s) 原因 select 后面加了 () select (x,x,x) 阅读全文
posted @ 2019-01-02 20:05 AngDH 阅读(2596) 评论(0) 推荐(0)
摘要: mysql查询默认是不区分大小写的 如: 1 2 select * from some_table where str=‘abc'; select * from some_table where str='ABC'; 1 2 select * from some_table where str=‘a 阅读全文
posted @ 2018-12-29 16:50 AngDH 阅读(610) 评论(0) 推荐(0)
摘要: INSERT INTO new_schedules_spider_shipsname ( ID,SCAC,VESSEL,VOYAGE,SERVICE_NAME,MD5 ) SELECT NULL,%s,%s,%s,%s,%s FROM DUAL WHERENOT EXISTS ( SELECT * 阅读全文
posted @ 2018-12-26 16:25 AngDH 阅读(366) 评论(0) 推荐(0)