Sandy's Blog

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()