本博客搭建参考文章

how-to-build-a-blog
，部分内容比较陈旧，整体还是不错的。

hexo学习

hexo官网

markdown新手入门

入门教程
afeiasdfasi

SELECT
title,slug,last_update,content,excerpt,tags from zinnia_entry,zinnia_entry_categories,

select name as ‘姓名’,
max(case subject when ‘语文’ then score else 0 end) 语文,
max(case subject when ‘英语’ then score else 0 end) 英语,
max(case subject when ‘物理’ then score else 0 end)物理
from tb2
group by name

select * from zinnia_entry_categories a,zinnia_category b where entry_id = 28
and a.category_id=b.category_id