no comments yet
10
Apr
2018
MySQL删除重复记录只保留一条
DELETE FROM small_pic WHERE num IN (
SELECT num
FROM (
SELECT num
FROM small_pic
GROUP BY num
HAVING COUNT( * ) >1
)t
)
DELETE FROM small_pic WHERE num IN (
SELECT num
FROM (
SELECT num
FROM small_pic
GROUP BY num
HAVING COUNT( * ) >1
)t
)
用highlight.js来实现代码高亮显示,只需要三行代码就可以了,非常方便:
<link href="https://highlightjs.org/static/demo/styles/default.css" rel="stylesheet">
<script src="https://highlightjs.org/static/highlight.pack.js"></script>
<script >hljs.initHighlightingOnLoad();</script>
更多配色可以直接在官网中参考。https://highlightjs.org/static/demo/
假设数据共有1005条,计划每10条为一页:
总页数= ceil(总数/每页数量)
$pages = ceil(1005/10);
Centos下出现这个错误,可用如下命令行安装:
yum install -y gcc libffi-devel python-devel openssl-devel
获取下载资源的直链地址:
import httplib
conn = httplib.HTTPConnection("www.sample.com")
conn.request("HEAD", "/download/down.jsp?DownID=8")
res = conn.getresponse()
print res.getheaders()