-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
66 lines (57 loc) · 14.2 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<!DOCTYPE html><html lang="zh-CN"><head><meta name="generator" content="Hexo 3.9.0"><meta charset="UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"><title>Binge</title><meta name="description" content><meta name="keywords" content><meta name="author" content="Binge Huang"><meta name="copyright" content="Binge Huang"><meta name="format-detection" content="telephone=no"><link rel="shortcut icon" href="/favicon.ico"><link rel="stylesheet" href="/css/index.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/font-awesome@latest/css/font-awesome.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@latest/dist/jquery.fancybox.min.css"><meta http-equiv="x-dns-prefetch-control" content="on"><link rel="canonical" href="http://yoursite.com/"><meta name="twitter:card" content="summary_large_image"><meta name="twitter:title" content="Binge"><meta name="twitter:description" content><meta name="twitter:image" content="http://yoursite.com/img/avatar.jpg"><meta property="og:type" content="website"><meta property="og:title" content="Binge"><meta property="og:url" content="http://yoursite.com/"><meta property="og:site_name" content="Binge"><meta property="og:description" content><meta property="og:image" content="http://yoursite.com/img/avatar.jpg"><meta http-equiv="Cache-Control" content="no-transform"><meta http-equiv="Cache-Control" content="no-siteapp"><link rel="preload" href="/img/marvel.jpeg" as="image"><link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Titillium+Web"><script>var GLOBAL_CONFIG = {
root: '/',
algolia: undefined,
localSearch: undefined,
translate: {"defaultEncoding":2,"translateDelay":0,"cookieDomain":"https://xxx/","msgToTraditionalChinese":"繁","msgToSimplifiedChinese":"简"},
highlight_copy: 'true',
copy: {
success: '复制成功',
error: '复制错误',
noSupport: '浏览器不支持'
},
bookmark: {
title: '添加书签',
message_prev: '按',
message_next: '键将本页加入书签'
},
runtime_unit: '天'
}</script></head><body><canvas class="fireworks"></canvas><nav class="full_page" id="nav" style="background-image: url(/img/marvel.jpeg)"><div id="page-header"><span class="pull-left"> <a class="blog_title" id="site-name" href="/">Binge</a></span><div class="open toggle-menu pull-right"><div class="menu-icon-first"></div><div class="menu-icon-second"></div><div class="menu-icon-third"></div></div><span class="pull-right menus"><div class="mobile_author_icon"><img class="lozad" src="/img/avatar.jpg" onerror="onerror=null;src='/img/friend_404.gif'"><div class="mobile_author-info__description"></div></div><hr><div class="menus_item"><a class="site-page" href="/"><i class="fa-fw fa fa-home"></i><span> 主页</span></a><a class="site-page" href="/archives/"><i class="fa-fw fa fa-archive"></i><span> 归档</span></a><a class="site-page" href="/tags/"><i class="fa-fw fa fa-tags"></i><span> 标签</span></a><a class="site-page" href="/categories/"><i class="fa-fw fa fa-folder-open"></i><span> 分类</span></a><a class="site-page" href="/link/"><i class="fa-fw fa fa-link"></i><span> 友链</span></a><a class="site-page" href="/about/"><i class="fa-fw fa fa-heart"></i><span> 关于</span></a><script>document.body.addEventListener('touchstart', function(){ });</script></div></span><span class="pull-right"></span></div><div id="site-info"><div id="site-title"><span class="blogtitle">Binge</span></div><div id="site-sub-title"><span class="subtitle"></span></div><div id="site-social-icons"><a class="social-icon" href="https://github.com/noviceBinge" target="_blank"><i class="fa fa-github"></i></a></div></div><div class="scroll-down"><i class="fa fa-angle-down scroll-down-effects"></i></div></nav><div id="content-outer"><div class="layout_page" id="content-inner"><div class="recent-posts" id="recent-posts"><div class="recent-post-item article-container"><div class="post_cover is_left"><a href="/2019/11/21/mysqlevent/" title="Mysql存储过程基本使用"><img class="post_bg lozad" data-src="https://noviceBinge.github.io/img/round.png" onerror="onerror=null;src='/img/404.jpg'"></a></div><div class="recent-post-info"> <a class="article-title" href="/2019/11/21/mysqlevent/" title="Mysql存储过程基本使用">Mysql存储过程基本使用</a><time class="post-meta__date"><i class="fa fa-calendar" aria-hidden="true"></i> 2019-11-21</time><div class="content">检查数据库事件是否开启，如果 event_scheduler 等于 NO表示开启 SELECT @@event_scheduler; SHOW VARIABLES LIKE ‘event_scheduler’; SELECT @@event_scheduler;
开启事件（全局） ...</div><div class="more_setting"><a class="more more--border more--primary more--animated" href="/2019/11/21/mysqlevent/#more" style="margin-top: 14px">阅读更多</a></div></div></div><div class="recent-post-item article-container"><div class="post_cover is_right"><a href="/2019/10/29/left-join/" title="当Left join 1对多时？"><img class="post_bg lozad" data-src="https://noviceBinge.github.io/img/round.png" onerror="onerror=null;src='/img/404.jpg'"></a></div><div class="recent-post-info"> <a class="article-title" href="/2019/10/29/left-join/" title="当Left join 1对多时？">当Left join 1对多时？</a><time class="post-meta__date"><i class="fa fa-calendar" aria-hidden="true"></i> 2019-10-29</time><div class="content">场景一个起租单可能对应多条附件，通过起租单id关联Select 起租单id，附件id from 起租单表 left join 附件表 on 起租单id = 附件id
原以为left join出现1对多时，左表只会select出一条数据，但是现实是会造成左表重复数据的产生。
修正方法：不要求查询右表所 ...</div><div class="more_setting"><a class="more more--border more--primary more--animated" href="/2019/10/29/left-join/#more" style="margin-top: 14px">阅读更多</a></div></div></div><div class="recent-post-item article-container"><div class="post_cover is_left"><a href="/2019/08/12/hello-world/" title="Hello World"><img class="post_bg lozad" data-src="https://cdn.jsdelivr.net/gh/jerryc127/CDN@latest/cover/default_bg.png" onerror="onerror=null;src='/img/404.jpg'"></a></div><div class="recent-post-info"> <a class="article-title" href="/2019/08/12/hello-world/" title="Hello World">Hello World</a><time class="post-meta__date"><i class="fa fa-calendar" aria-hidden="true"></i> 2019-08-12</time><div class="content">Welcome to Hexo! This is your very first post. Check documentation for more info. If you get any problems when using Hexo, you can find the answer in ...</div><div class="more_setting"><a class="more more--border more--primary more--animated" href="/2019/08/12/hello-world/#more" style="margin-top: 14px">阅读更多</a></div></div></div><nav id="pagination"><div class="pagination"><span class="page-number current">1</span></div></nav></div><div class="aside_content" id="aside_content"><div class="card_widget card-author"><div class="card-content"><div class="post_data"><div class="data-item text-center"><img class="lozad" src="/img/avatar.jpg" onerror="onerror=null;src='/img/friend_404.gif'"><p class="author-info__name text-center">Binge Huang</p><p class="author-info__description text-center"></p></div></div><div class="post_data data_config"><div class="data-item text-center"><div class="data_link"><a href="/archives/"><p class="headline">文章</p><p class="length_num">3</p></a></div></div></div><div class="post_data text-center"><a class="data-item bookmark bookmarke--primary bookmark--animated" id="bookmark-it" href="javascript:;" title="加入书签">加入书签</a></div><div class="post_data data_config"><div id="aside-social-icons"> <a class="social-icon data-item" href="https://github.com/noviceBinge" target="_blank"><i class="fa fa-github"></i></a></div></div></div></div><div class="card_widget card-announcement"><div class="card-content"><div class="item_headline"><i class="fa fa-bullhorn card-announcement-animation" aria-hidden="true"></i><span>公告</span></div><div class="announcement_content">感谢访问本站，若喜欢请收藏 ^_^</div></div></div><div class="card_widget card-recent-post"><div class="card-content"><div class="item_headline"><i class="fa fa-history" aria-hidden="true"></i><span>最新文章</span></div><div class="aside_recent_item"><div class="aside_recent_post"><a href="/2019/11/21/mysqlevent/"><div class="aside_post_cover"><img class="aside_post_bg lozad" data-src="https://noviceBinge.github.io/img/round.png" onerror="onerror=null;src='/img/404.jpg'" title="Mysql存储过程基本使用"></div><div id="aside_title"><div class="aside_post_title" href="/2019/11/21/mysqlevent/" title="Mysql存储过程基本使用">Mysql存储过程基本使用</div><time class="aside_post_meta post-meta__date">2019-11-21</time></div></a></div><div class="aside_recent_post"><a href="/2019/10/29/left-join/"><div class="aside_post_cover"><img class="aside_post_bg lozad" data-src="https://noviceBinge.github.io/img/round.png" onerror="onerror=null;src='/img/404.jpg'" title="当Left join 1对多时？"></div><div id="aside_title"><div class="aside_post_title" href="/2019/10/29/left-join/" title="当Left join 1对多时？">当Left join 1对多时？</div><time class="aside_post_meta post-meta__date">2019-10-29</time></div></a></div><div class="aside_recent_post"><a href="/2019/08/12/hello-world/"><div class="aside_post_cover"><img class="aside_post_bg lozad" data-src="https://cdn.jsdelivr.net/gh/jerryc127/CDN@latest/cover/default_bg.png" onerror="onerror=null;src='/img/404.jpg'" title="Hello World"></div><div id="aside_title"><div class="aside_post_title" href="/2019/08/12/hello-world/" title="Hello World">Hello World</div><time class="aside_post_meta post-meta__date">2019-08-12</time></div></a></div></div></div></div><div class="card_widget card-archives"><div class="card-content"><div class="item_headline"><i class="fa fa-archive" aria-hidden="true"></i><span>归档</span></div><div class="archives_item"><ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/11/">2019年11月</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/10/">2019年10月</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/08/">2019年08月</a><span class="archive-list-count">1</span></li></ul></div></div></div><div class="card_widget card-webinfo"><div class="card-content"><div class="item_headline"><i class="fa fa-line-chart" aria-hidden="true"></i><span>网站资讯</span></div><div class="webinfo"><div class="webinfo_item"><div class="webinfo_article_name">文章数目 :</div><div class="webinfo_article_count">3</div></div><div class="webinfo_item"><div class="webinfo_runtime_name">已运行时间 :</div><div class="webinfo_runtime_count" id="webinfo_runtime_count"></div><script id="runtionshow" src="/js/runtimeshow.js" start_date="6/7/2018 00:00:00"> </script></div><div class="webinfo_item"> <div class="webinfo_site_uv_name">本站访客数 :</div><div class="webinfo_site_uv_count" id="busuanzi_value_site_uv"></div></div><div class="webinfo_item"><div class="webinfo_site_name">本站总访问量 :</div><div class="webinfo_site_pv_count" id="busuanzi_value_site_pv"></div></div></div></div></div></div></div></div><footer><div class="layout" id="footer"><div class="copyright">©2018 - 2019 By Binge Huang</div><div class="framework-info"><span>驱动 </span><a href="http://hexo.io"><span>Hexo</span></a><span class="footer-separator">|</span><span>主题 </span><a href="https://github.com/jerryc127/hexo-theme-butterfly"><span>Butterfly</span></a></div></div></footer><i class="fa fa-arrow-up" id="go-up" aria-hidden="true"></i><section class="rightside" id="rightside"><i class="fa fa-plus" id="font_plus" title="放大字体"></i><i class="fa fa-minus" id="font_minus" title="缩小字体"></i><a class="translate_chn_to_cht" id="translateLink" href="javascript:translatePage();" title="简繁转换">繁</a><i class="fa fa-moon-o nightshift" id="nightshift" title="夜间模式"></i></section><script src="https://cdn.jsdelivr.net/npm/jquery@latest/dist/jquery.min.js"></script><script src="https://cdn.jsdelivr.net/npm/@fancyapps/fancybox@latest/dist/jquery.fancybox.min.js"></script><script src="https://cdn.jsdelivr.net/npm/js-cookie@2/src/js.cookie.min.js"></script><script src="/js/utils.js"></script><script src="/js/main.js"></script><script src="https://cdn.jsdelivr.net/npm/animejs@latest/anime.min.js"></script><script src="/js/third-party/fireworks.js"></script><script src="/js/nightshift.js"></script><script id="ribbon" src="/js/third-party/canvas-ribbon.js" size="150" alpha="0.6" zindex="-1" data-click="false"></script><script src="/js/tw_cn.js"></script><script>translateInitilization()
</script><script src="https://cdn.jsdelivr.net/npm/[email protected]"> </script><script>var typed = new Typed(".subtitle", {
strings: ['我可以耗上壹整天','I can do this all day'],
startDelay: 300,
typeSpeed: 100,
loop: true,
backSpeed: 50
});
</script><script>//首頁fullpage
function alignContent() {
for (var n = $(window).height(), e = document.querySelectorAll(".full_page"), i = 0; i < e.length; i++)
e[i].style.height = n + "px";
$("#site-info").each(function () {
var x = $(this).height();
$(this).css("top", (n-x)/2)
})
}
function recent_post_padding() {
$(".recent-post-info").each(function () {
var k = $(".recent-post-item").height();
var e = $(this).height();
$(this).css({"padding-top": (k-e)/2 , "padding-bottom": (k-e)/2 })
})
}
alignContent();
//recent-post-item垂直置中
if ($(window).width() > 768) {
recent_post_padding();
}
$(window).bind("resize", function () {
alignContent()
if ($(window).width() > 768) {
recent_post_padding();
}
})
</script><script async src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script><script src="https://cdn.jsdelivr.net/npm/[email protected]/instantpage.min.js" type="module"></script><script src="https://cdn.jsdelivr.net/npm/lozad/dist/lozad.min.js"></script><script>const observer = lozad(); // lazy loads elements with default selector as '.lozad'
observer.observe();</script></body></html>