mysql.html


<!DOCTYPE HTML>
<html lang="zh-hans" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>mysql · go-zero使用文档</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        <meta name="author" content="松妹子">
        
        
    <link rel="stylesheet" href="gitbook/style.css">

    
                <link rel="stylesheet" href="gitbook/gitbook-plugin-back-to-top-button/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-chapter-fold/chapter-fold.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-code/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-search-pro/search.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-splitter/splitter.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-tbfed-pagefooter/footer.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-flexible-alerts/style.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-page-toc-button/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-pageview-count/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-prism/prism-tomorrow.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-fontsettings/website.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-theme-comscore/test.css">
                
            
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="gitbook/images/favicon.ico" type="image/x-icon">

    
    <link rel="next" href="redis-lock.html" />
    
    
    <link rel="prev" href="fx.html" />
    

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
<div id="book-search-input" role="search">
    <input type="text" placeholder="输入并搜索" />
</div>

            
                <nav role="navigation">
                

<ul class="summary">
    
    
        <li class="chapter " data-level="1.1" data-path="./">
            
                <a href="./">
            
                    
                    简介
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.2" data-path="about-us.html">
            
                <a href="about-us.html">
            
                    
                    关于我们
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.3" data-path="join-us.html">
            
                <a href="join-us.html">
            
                    
                    加入我们
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.4" data-path="concept-introduction.html">
            
                <a href="concept-introduction.html">
            
                    
                    概念介绍
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.5" data-path="quick-start.html">
            
                <a href="quick-start.html">
            
                    
                    快速开发
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.5.1" data-path="monolithic-service.html">
            
                <a href="monolithic-service.html">
            
                    
                    单体服务
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.5.2" data-path="micro-service.html">
            
                <a href="micro-service.html">
            
                    
                    微服务
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.6" data-path="framework-design.html">
            
                <a href="framework-design.html">
            
                    
                    框架设计
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.6.1" data-path="go-zero-design.html">
            
                <a href="go-zero-design.html">
            
                    
                    go-zero设计理念
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.2" data-path="go-zero-features.html">
            
                <a href="go-zero-features.html">
            
                    
                    go-zero特点
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.3" data-path="api-grammar.html">
            
                <a href="api-grammar.html">
            
                    
                    api语法介绍
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.4" data-path="api-dir.html">
            
                <a href="api-dir.html">
            
                    
                    api目录结构
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.5" data-path="rpc-dir.html">
            
                <a href="rpc-dir.html">
            
                    
                    rpc目录结构
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7" data-path="project-dev.html">
            
                <a href="project-dev.html">
            
                    
                    项目开发
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.1" data-path="prepare.html">
            
                <a href="prepare.html">
            
                    
                    准备工作
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.1.1" data-path="golang-install.html">
            
                <a href="golang-install.html">
            
                    
                    golang安装
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.2" data-path="gomod-config.html">
            
                <a href="gomod-config.html">
            
                    
                    go modudle配置
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.3" data-path="goctl-install.html">
            
                <a href="goctl-install.html">
            
                    
                    goctl安装
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.4" data-path="protoc-install.html">
            
                <a href="protoc-install.html">
            
                    
                    protoc&protoc-gen-go安装
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.5" data-path="prepare-other.html">
            
                <a href="prepare-other.html">
            
                    
                    其他
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.2" data-path="dev-specification.html">
            
                <a href="dev-specification.html">
            
                    
                    开发规范
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.2.1" data-path="naming-spec.html">
            
                <a href="naming-spec.html">
            
                    
                    命名规范
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.2.2" data-path="route-naming-spec.html">
            
                <a href="route-naming-spec.html">
            
                    
                    路由规范
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.2.3" data-path="coding-spec.html">
            
                <a href="coding-spec.html">
            
                    
                    编码规范
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.3" data-path="dev-flow.html">
            
                <a href="dev-flow.html">
            
                    
                    开发流程
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.4" data-path="config-introduction.html">
            
                <a href="config-introduction.html">
            
                    
                    配置介绍
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.4.1" data-path="api-config.html">
            
                <a href="api-config.html">
            
                    
                    api配置
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.4.2" data-path="rpc-config.html">
            
                <a href="rpc-config.html">
            
                    
                    rpc配置
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.5" data-path="business-dev.html">
            
                <a href="business-dev.html">
            
                    
                    业务开发
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.5.1" data-path="service-design.html">
            
                <a href="service-design.html">
            
                    
                    目录拆分
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.2" data-path="model-gen.html">
            
                <a href="model-gen.html">
            
                    
                    model生成
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.3" data-path="api-coding.html">
            
                <a href="api-coding.html">
            
                    
                    api文件编写
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.4" data-path="business-coding.html">
            
                <a href="business-coding.html">
            
                    
                    业务编码
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.5" data-path="jwt.html">
            
                <a href="jwt.html">
            
                    
                    jwt鉴权
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.6" data-path="middleware.html">
            
                <a href="middleware.html">
            
                    
                    中间件使用
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.7" data-path="rpc-call.html">
            
                <a href="rpc-call.html">
            
                    
                    rpc服务编写与调用
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.8" data-path="error-handle.html">
            
                <a href="error-handle.html">
            
                    
                    错误处理
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.6" data-path="ci-cd.html">
            
                <a href="ci-cd.html">
            
                    
                    CI/CD
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.7" data-path="service-deployment.html">
            
                <a href="service-deployment.html">
            
                    
                    服务部署
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.8" data-path="log-collection.html">
            
                <a href="log-collection.html">
            
                    
                    日志收集
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.9" data-path="trace.html">
            
                <a href="trace.html">
            
                    
                    链路追踪
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.10" data-path="service-monitor.html">
            
                <a href="service-monitor.html">
            
                    
                    服务监控
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.8" data-path="goctl.html">
            
                <a href="goctl.html">
            
                    
                    Goctl
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.8.1" data-path="goctl-commands.html">
            
                <a href="goctl-commands.html">
            
                    
                    命令大全
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.2" data-path="goctl-api.html">
            
                <a href="goctl-api.html">
            
                    
                    api命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.3" data-path="goctl-rpc.html">
            
                <a href="goctl-rpc.html">
            
                    
                    rpc命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.4" data-path="goctl-model.html">
            
                <a href="goctl-model.html">
            
                    
                    model命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.5" data-path="goctl-plugin.html">
            
                <a href="goctl-plugin.html">
            
                    
                    plugin命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.6" data-path="goctl-other.html">
            
                <a href="goctl-other.html">
            
                    
                    其他命令
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.9" data-path="component-center.html">
            
                <a href="component-center.html">
            
                    
                    组件中心
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.9.1" data-path="logx.html">
            
                <a href="logx.html">
            
                    
                    logx
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.2" data-path="bloom.html">
            
                <a href="bloom.html">
            
                    
                    bloom
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.3" data-path="executors.html">
            
                <a href="executors.html">
            
                    
                    executors
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.4" data-path="fx.html">
            
                <a href="fx.html">
            
                    
                    fx
            
                </a>
            

        </li>
    
        <li class="chapter active" data-level="1.9.5" data-path="mysql.html">
            
                <a href="mysql.html">
            
                    
                    mysql
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.6" data-path="redis-lock.html">
            
                <a href="redis-lock.html">
            
                    
                    redis-lock
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.7" data-path="periodlimit.html">
            
                <a href="periodlimit.html">
            
                    
                    periodlimit
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.8" data-path="tokenlimit.html">
            
                <a href="tokenlimit.html">
            
                    
                    tokenlimit
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.9" data-path="timing-wheel.html">
            
                <a href="timing-wheel.html">
            
                    
                    TimingWheel
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.10" data-path="tool-center.html">
            
                <a href="tool-center.html">
            
                    
                    工具中心
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.10.1" data-path="intellij.html">
            
                <a href="intellij.html">
            
                    
                    intellij插件
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.10.2" data-path="vscode.html">
            
                <a href="vscode.html">
            
                    
                    vscode插件
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.11" data-path="plugin-center.html">
            
                <a href="plugin-center.html">
            
                    
                    插件中心
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.12" data-path="learning-resource.html">
            
                <a href="learning-resource.html">
            
                    
                    学习资源
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.12.1" data-path="wechat.html">
            
                <a href="wechat.html">
            
                    
                    公众号
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.12.2" data-path="goreading.html">
            
                <a href="goreading.html">
            
                    
                    Go夜读
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.12.3" data-path="gotalk.html">
            
                <a href="gotalk.html">
            
                    
                    Go开源说
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.13" data-path="practise.html">
            
                <a href="practise.html">
            
                    
                    开发实践
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.13.1" data-path="redis-cache.html">
            
                <a href="redis-cache.html">
            
                    
                    go-zero缓存设计之持久层缓存
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.2" data-path="buiness-cache.html">
            
                <a href="buiness-cache.html">
            
                    
                    go-zero缓存设计之业务层缓存
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.3" data-path="go-queue.html">
            
                <a href="go-queue.html">
            
                    
                    go-zero分布式定时任务
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.4" data-path="datacenter.html">
            
                <a href="datacenter.html">
            
                    
                    我是如何用go-zero 实现一个中台系统
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.5" data-path="stream.html">
            
                <a href="stream.html">
            
                    
                    流数据处理利器
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.6" data-path="online-exchange.html">
            
                <a href="online-exchange.html">
            
                    
                    10月3日线上交流问题汇总
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.14" data-path="dev-log.html">
            
                <a href="dev-log.html">
            
                    
                    开发日志
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.14.1" data-path="goctl-log.html">
            
                <a href="goctl-log.html">
            
                    
                    goctl开发日志
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.14.2" data-path="intellij-log.html">
            
                <a href="intellij-log.html">
            
                    
                    intellij开发日志
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.15" data-path="contributor.html">
            
                <a href="contributor.html">
            
                    
                    贡献人员
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.16" data-path="doc-contibute.html">
            
                <a href="doc-contibute.html">
            
                    
                    文档贡献
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.17" data-path="error.html">
            
                <a href="error.html">
            
                    
                    常见错误处理
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.18" data-path="source.html">
            
                <a href="source.html">
            
                    
                    相关源码
            
                </a>
            

        </li>
    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            本书使用 GitBook 发布
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    
<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href="." >mysql</a>
    </h1>
</div>


                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
<div id="book-search-results">
    <div class="search-noresults">
    
                                <section class="normal markdown-section">
                                
                                <h1 id="mysql">mysql</h1>
<p><code>go-zero</code> &#x63D0;&#x4F9B;&#x66F4;&#x6613;&#x4E8E;&#x64CD;&#x4F5C; <code>mysql</code> API&#x3002;</p>
<blockquote>
<p>[!TIP]
&#x4F46;&#x662F;  <code>stores/mysql</code> &#x5B9A;&#x4F4D;&#x4E0D;&#x662F;&#x4E00;&#x4E2A; <code>orm</code> &#x6846;&#x67B6;&#xFF0C;&#x5982;&#x679C;&#x4F60;&#x9700;&#x8981;&#x901A;&#x8FC7; <code>sql/scheme</code> -&gt; <code>model/struct</code> &#x9006;&#x5411;&#x751F;&#x6210; <code>model</code> &#x5C42;&#x4EE3;&#x7801;&#xFF0C;&#x5F00;&#x53D1;&#x8005;&#x53EF;&#x4EE5;&#x4F7F;&#x7528;&#x300C;<a href="https://www.yuque.com/tal-tech/go-zero/nkg20f" target="_blank">goctl model</a>&#x300D;&#xFF0C;&#x8FD9;&#x4E2A;&#x662F;&#x6781;&#x597D;&#x7684;&#x529F;&#x80FD;&#x3002;</p>
</blockquote>
<h2 id="feature">Feature</h2>
<ul>
<li>&#x76F8;&#x6BD4;&#x539F;&#x751F;&#xFF0C;&#x63D0;&#x4F9B;&#x5F00;&#x53D1;&#x8005;&#x66F4;&#x53CB;&#x597D;&#x7684;API</li>
<li>&#x5B8C;&#x6210; <code>queryField -&gt; struct</code> &#x7684;&#x81EA;&#x52A8;&#x8D4B;&#x503C;</li>
<li>&#x6279;&#x91CF;&#x63D2;&#x5165;&#x300C;bulkinserter&#x300D;</li>
<li>&#x81EA;&#x5E26;&#x7194;&#x65AD;</li>
<li>API &#x7ECF;&#x8FC7;&#x82E5;&#x5E72;&#x4E2A;&#x670D;&#x52A1;&#x7684;&#x4E0D;&#x65AD;&#x8003;&#x9A8C;</li>
<li>&#x63D0;&#x4F9B; <code>partial assignment</code> &#x7279;&#x6027;&#xFF0C;&#x4E0D;&#x5F3A;&#x5236; <code>struct</code> &#x7684;&#x4E25;&#x683C;&#x8D4B;&#x503C;</li>
</ul>
<h2 id="connection">Connection</h2>
<p>&#x4E0B;&#x9762;&#x7528;&#x4E00;&#x4E2A;&#x4F8B;&#x5B50;&#x7B80;&#x5355;&#x8BF4;&#x660E;&#x4E00;&#x4E0B;&#x5982;&#x4F55;&#x521B;&#x5EFA;&#x4E00;&#x4E2A; <code>mysql</code> &#x8FDE;&#x63A5;&#x7684;model&#xFF1A;</p>
<pre class="language-"><code class="lang-go"><span class="token comment">// 1. &#x5FEB;&#x901F;&#x8FDE;&#x63A5;&#x4E00;&#x4E2A; mysql</span>
<span class="token comment">// datasource: mysql dsn</span>
heraMysql <span class="token operator">:=</span> sqlx<span class="token punctuation">.</span><span class="token function">NewMysql</span><span class="token punctuation">(</span>datasource<span class="token punctuation">)</span>

<span class="token comment">// 2. &#x5728; servicecontext &#x4E2D;&#x8C03;&#x7528;&#xFF0C;&#x61C2;model&#x4E0A;&#x5C42;&#x7684;logic&#x5C42;&#x8C03;&#x7528;</span>
model<span class="token punctuation">.</span><span class="token function">NewMysqlModel</span><span class="token punctuation">(</span>heraMysql<span class="token punctuation">,</span> tablename<span class="token punctuation">)</span><span class="token punctuation">,</span>

<span class="token comment">// 3. model&#x5C42; mysql operation</span>
<span class="token keyword">func</span> <span class="token function">NewMysqlModel</span><span class="token punctuation">(</span>conn sqlx<span class="token punctuation">.</span>SqlConn<span class="token punctuation">,</span> table <span class="token builtin">string</span><span class="token punctuation">)</span> <span class="token operator">*</span>MysqlModel <span class="token punctuation">{</span>
    <span class="token keyword">defer</span> <span class="token keyword">func</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
        <span class="token function">recover</span><span class="token punctuation">(</span><span class="token punctuation">)</span>
    <span class="token punctuation">}</span><span class="token punctuation">(</span><span class="token punctuation">)</span>
    <span class="token comment">// 4. &#x521B;&#x5EFA;&#x4E00;&#x4E2A;&#x6279;&#x91CF;insert&#x7684; [mysql executor]</span>
    <span class="token comment">// conn: mysql connection; insertsql: mysql insert sql</span>
    bulkInserter <span class="token punctuation">,</span> err <span class="token operator">:=</span> sqlx<span class="token punctuation">.</span><span class="token function">NewBulkInserter</span><span class="token punctuation">(</span>conn<span class="token punctuation">,</span> insertsql<span class="token punctuation">)</span>
    <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        logx<span class="token punctuation">.</span><span class="token function">Error</span><span class="token punctuation">(</span><span class="token string">&quot;Init bulkInsert Faild&quot;</span><span class="token punctuation">)</span>
        <span class="token function">panic</span><span class="token punctuation">(</span><span class="token string">&quot;Init bulkInsert Faild&quot;</span><span class="token punctuation">)</span>
        <span class="token keyword">return</span> <span class="token boolean">nil</span>
    <span class="token punctuation">}</span>
    <span class="token keyword">return</span> <span class="token operator">&amp;</span>MysqlModel<span class="token punctuation">{</span>conn<span class="token punctuation">:</span> conn<span class="token punctuation">,</span> table<span class="token punctuation">:</span> table<span class="token punctuation">,</span> Bulk<span class="token punctuation">:</span> bulkInserter<span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre>
<h2 id="crud">CRUD</h2>
<p>&#x51C6;&#x5907;&#x4E00;&#x4E2A; <code>User model</code></p>
<pre class="language-"><code class="lang-go"><span class="token keyword">var</span> userBuilderQueryRows <span class="token operator">=</span> strings<span class="token punctuation">.</span><span class="token function">Join</span><span class="token punctuation">(</span>builderx<span class="token punctuation">.</span><span class="token function">FieldNames</span><span class="token punctuation">(</span><span class="token operator">&amp;</span>User<span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token string">&quot;,&quot;</span><span class="token punctuation">)</span>

<span class="token keyword">type</span> User <span class="token keyword">struct</span> <span class="token punctuation">{</span>
    Avatar <span class="token builtin">string</span> <span class="token string">`db:&quot;avatar&quot;`</span>             <span class="token comment">// &#x5934;&#x50CF;</span>
    UserName <span class="token builtin">string</span> <span class="token string">`db:&quot;user_name&quot;`</span>         <span class="token comment">// &#x59D3;&#x540D;</span>
    Sex <span class="token builtin">int</span> <span class="token string">`db:&quot;sex&quot;`</span>                         <span class="token comment">// 1&#x7537;,2&#x5973;</span>
    MobilePhone <span class="token builtin">string</span> <span class="token string">`db:&quot;mobile_phone&quot;`</span>     <span class="token comment">// &#x624B;&#x673A;&#x53F7;</span>
<span class="token punctuation">}</span>
</code></pre>
<p>&#x5176;&#x4E2D; <code>userBuilderQueryRows</code> &#xFF1A; <code>go-zero</code> &#x4E2D;&#x63D0;&#x4F9B; <code>struct -&gt; [field...]</code> &#x7684;&#x8F6C;&#x5316;&#xFF0C;&#x5F00;&#x53D1;&#x8005;&#x53EF;&#x4EE5;&#x5C06;&#x6B64;&#x5F53;&#x6210;&#x6A21;&#x7248;&#x76F4;&#x63A5;&#x4F7F;&#x7528;&#x3002;</p>
<h3 id="insert">insert</h3>
<pre class="language-"><code class="lang-go"><span class="token comment">// &#x4E00;&#x4E2A;&#x5B9E;&#x9645;&#x7684;insert model&#x5C42;&#x64CD;&#x4F5C;</span>
<span class="token keyword">func</span> <span class="token punctuation">(</span>um <span class="token operator">*</span>UserModel<span class="token punctuation">)</span> <span class="token function">Insert</span><span class="token punctuation">(</span>user <span class="token operator">*</span>User<span class="token punctuation">)</span> <span class="token punctuation">(</span><span class="token builtin">int64</span><span class="token punctuation">,</span> <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    <span class="token keyword">const</span> insertsql <span class="token operator">=</span> <span class="token string">`insert into `</span><span class="token operator">+</span>um<span class="token punctuation">.</span>table<span class="token operator">+</span><span class="token string">` (`</span><span class="token operator">+</span>userBuilderQueryRows<span class="token operator">+</span><span class="token string">`) values(?, ?, ?)`</span>
    <span class="token comment">// insert op</span>
    res<span class="token punctuation">,</span> err <span class="token operator">:=</span> um<span class="token punctuation">.</span>conn<span class="token punctuation">.</span><span class="token function">Exec</span><span class="token punctuation">(</span>insertsql<span class="token punctuation">,</span> user<span class="token punctuation">.</span>Avatar<span class="token punctuation">,</span> user<span class="token punctuation">.</span>UserName<span class="token punctuation">,</span> user<span class="token punctuation">.</span>Sex<span class="token punctuation">,</span> user<span class="token punctuation">.</span>MobilePhone<span class="token punctuation">)</span>
    <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        logx<span class="token punctuation">.</span><span class="token function">Errorf</span><span class="token punctuation">(</span><span class="token string">&quot;insert User Position Model Model err, err=%v&quot;</span><span class="token punctuation">,</span> err<span class="token punctuation">)</span>
        <span class="token keyword">return</span> <span class="token operator">-</span><span class="token number">1</span><span class="token punctuation">,</span> err
    <span class="token punctuation">}</span>
    id<span class="token punctuation">,</span> err <span class="token operator">:=</span> res<span class="token punctuation">.</span><span class="token function">LastInsertId</span><span class="token punctuation">(</span><span class="token punctuation">)</span>
    <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        logx<span class="token punctuation">.</span><span class="token function">Errorf</span><span class="token punctuation">(</span><span class="token string">&quot;insert User Model to Id  parse id err,err=%v&quot;</span><span class="token punctuation">,</span> err<span class="token punctuation">)</span>
        <span class="token keyword">return</span> <span class="token operator">-</span><span class="token number">1</span><span class="token punctuation">,</span> err
    <span class="token punctuation">}</span>
    <span class="token keyword">return</span> id<span class="token punctuation">,</span> <span class="token boolean">nil</span>
<span class="token punctuation">}</span>
</code></pre>
<ul>
<li>&#x62FC;&#x63A5; <code>insertsql</code></li>
<li>&#x5C06; <code>insertsql</code> &#x4EE5;&#x53CA; &#x5360;&#x4F4D;&#x7B26;&#x5BF9;&#x5E94;&#x7684; <code>struct field</code> &#x4F20;&#x5165; -&gt; <code>con.Exex(insertsql, field...)</code></li>
</ul>
<blockquote>
<p>[!WARNING]
<code>conn.Exec(sql, args...)</code> &#xFF1A; <code>args...</code> &#x9700;&#x5BF9;&#x5E94; <code>sql</code> &#x4E2D;&#x5360;&#x4F4D;&#x7B26;&#x3002;&#x4E0D;&#x7136;&#x4F1A;&#x51FA;&#x73B0;&#x8D4B;&#x503C;&#x5F02;&#x5E38;&#x7684;&#x95EE;&#x9898;&#x3002;</p>
</blockquote>
<p><code>go-zero</code> &#x5C06;&#x6D89;&#x53CA; <code>mysql</code> &#x4FEE;&#x6539;&#x7684;&#x64CD;&#x4F5C;&#x7EDF;&#x4E00;&#x62BD;&#x8C61;&#x4E3A; <code>Exec()</code> &#x3002;&#x6240;&#x4EE5; <code>insert/update/delete</code> &#x64CD;&#x4F5C;&#x672C;&#x8D28;&#x4E0A;&#x4E00;&#x81F4;&#x7684;&#x3002;&#x5176;&#x4F59;&#x4E24;&#x4E2A;&#x64CD;&#x4F5C;&#xFF0C;&#x5F00;&#x53D1;&#x8005;&#x6309;&#x7167;&#x4E0A;&#x8FF0; <code>insert</code> &#x6D41;&#x7A0B;&#x5C1D;&#x8BD5;&#x5373;&#x53EF;&#x3002;</p>
<h3 id="query">query</h3>
<p>&#x53EA;&#x9700;&#x8981;&#x4F20;&#x5165; <code>querysql</code> &#x548C; <code>model</code> &#x7ED3;&#x6784;&#x4F53;&#xFF0C;&#x5C31;&#x53EF;&#x4EE5;&#x83B7;&#x53D6;&#x5230;&#x88AB;&#x8D4B;&#x503C;&#x597D;&#x7684; <code>model</code> &#x3002;&#x65E0;&#x9700;&#x5F00;&#x53D1;&#x8005;&#x624B;&#x52A8;&#x8D4B;&#x503C;&#x3002;</p>
<pre class="language-"><code class="lang-go"><span class="token keyword">func</span> <span class="token punctuation">(</span>um <span class="token operator">*</span>UserModel<span class="token punctuation">)</span> <span class="token function">FindOne</span><span class="token punctuation">(</span>uid <span class="token builtin">int64</span><span class="token punctuation">)</span> <span class="token punctuation">(</span><span class="token operator">*</span>User<span class="token punctuation">,</span> <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    <span class="token keyword">var</span> user User
    <span class="token keyword">const</span> querysql <span class="token operator">=</span> <span class="token string">`select `</span><span class="token operator">+</span>userBuilderQueryRows<span class="token operator">+</span><span class="token string">` from `</span><span class="token operator">+</span>um<span class="token punctuation">.</span>table<span class="token operator">+</span><span class="token string">` where id=? limit 1`</span>
    err <span class="token operator">:=</span> um<span class="token punctuation">.</span>conn<span class="token punctuation">.</span><span class="token function">QueryRow</span><span class="token punctuation">(</span><span class="token operator">&amp;</span>user<span class="token punctuation">,</span> querysql<span class="token punctuation">,</span> uid<span class="token punctuation">)</span>
    <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        logx<span class="token punctuation">.</span><span class="token function">Errorf</span><span class="token punctuation">(</span><span class="token string">&quot;userId.findOne error, id=%d, err=%s&quot;</span><span class="token punctuation">,</span> uid<span class="token punctuation">,</span> err<span class="token punctuation">.</span><span class="token function">Error</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span>
        <span class="token keyword">if</span> err <span class="token operator">==</span> sqlx<span class="token punctuation">.</span>ErrNotFound <span class="token punctuation">{</span>
            <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> ErrNotFound
        <span class="token punctuation">}</span>
        <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> err
    <span class="token punctuation">}</span>
    <span class="token keyword">return</span> <span class="token operator">&amp;</span>user<span class="token punctuation">,</span> <span class="token boolean">nil</span>
<span class="token punctuation">}</span>
</code></pre>
<ul>
<li>&#x58F0;&#x660E; <code>model struct</code> &#xFF0C;&#x62FC;&#x63A5; <code>querysql</code></li>
<li><code>conn.QueryRow(&amp;model, querysql, args...)</code> &#xFF1A; <code>args...</code> &#x4E0E; <code>querysql</code> &#x4E2D;&#x7684;&#x5360;&#x4F4D;&#x7B26;&#x5BF9;&#x5E94;&#x3002;</li>
</ul>
<blockquote>
<p>[!WARNING]
<code>QueryRow()</code> &#x4E2D;&#x7B2C;&#x4E00;&#x4E2A;&#x53C2;&#x6570;&#x9700;&#x8981;&#x4F20;&#x5165; <code>Ptr</code> &#x300C;&#x5E95;&#x5C42;&#x9700;&#x8981;&#x53CD;&#x5C04;&#x5BF9; <code>struct</code> &#x8FDB;&#x884C;&#x8D4B;&#x503C;&#x300D;</p>
</blockquote>
<p>&#x4E0A;&#x8FF0;&#x662F;&#x67E5;&#x8BE2;&#x4E00;&#x6761;&#x8BB0;&#x5F55;&#xFF0C;&#x5982;&#x679C;&#x9700;&#x8981;&#x67E5;&#x8BE2;&#x591A;&#x6761;&#x8BB0;&#x5F55;&#x65F6;&#xFF0C;&#x53EF;&#x4EE5;&#x4F7F;&#x7528; <code>conn.QueryRows()</code></p>
<pre class="language-"><code class="lang-go"><span class="token keyword">func</span> <span class="token punctuation">(</span>um <span class="token operator">*</span>UserModel<span class="token punctuation">)</span> <span class="token function">FindOne</span><span class="token punctuation">(</span>sex <span class="token builtin">int</span><span class="token punctuation">)</span> <span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token operator">*</span>User<span class="token punctuation">,</span> <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    users <span class="token operator">:=</span> <span class="token function">make</span><span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token operator">*</span>User<span class="token punctuation">,</span> <span class="token number">0</span><span class="token punctuation">)</span>
    <span class="token keyword">const</span> querysql <span class="token operator">=</span> <span class="token string">`select `</span><span class="token operator">+</span>userBuilderQueryRows<span class="token operator">+</span><span class="token string">` from `</span><span class="token operator">+</span>um<span class="token punctuation">.</span>table<span class="token operator">+</span><span class="token string">` where sex=?`</span>
    err <span class="token operator">:=</span> um<span class="token punctuation">.</span>conn<span class="token punctuation">.</span><span class="token function">QueryRows</span><span class="token punctuation">(</span><span class="token operator">&amp;</span>users<span class="token punctuation">,</span> querysql<span class="token punctuation">,</span> sex<span class="token punctuation">)</span>
    <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        logx<span class="token punctuation">.</span><span class="token function">Errorf</span><span class="token punctuation">(</span><span class="token string">&quot;usersSex.findOne error, sex=%d, err=%s&quot;</span><span class="token punctuation">,</span> uid<span class="token punctuation">,</span> err<span class="token punctuation">.</span><span class="token function">Error</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span>
        <span class="token keyword">if</span> err <span class="token operator">==</span> sqlx<span class="token punctuation">.</span>ErrNotFound <span class="token punctuation">{</span>
            <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> ErrNotFound
        <span class="token punctuation">}</span>
        <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> err
    <span class="token punctuation">}</span>
    <span class="token keyword">return</span> users<span class="token punctuation">,</span> <span class="token boolean">nil</span>
<span class="token punctuation">}</span>
</code></pre>
<p>&#x4E0E; <code>QueryRow()</code> &#x4E0D;&#x540C;&#x7684;&#x5730;&#x65B9;&#x5728;&#x4E8E;&#xFF1A; <code>model</code> &#x9700;&#x8981;&#x8BBE;&#x7F6E;&#x6210; <code>Slice</code> &#xFF0C;&#x56E0;&#x4E3A;&#x662F;&#x67E5;&#x8BE2;&#x591A;&#x884C;&#xFF0C;&#x9700;&#x8981;&#x5BF9;&#x591A;&#x4E2A; <code>model</code> &#x8D4B;&#x503C;&#x3002;&#x4F46;&#x540C;&#x65F6;&#x9700;&#x8981;&#x6CE8;&#x610F;&#xFE0F;&#xFF1A;&#x7B2C;&#x4E00;&#x4E2A;&#x53C2;&#x6570;&#x9700;&#x8981;&#x4F20;&#x5165; <code>Ptr</code></p>
<h3 id="querypartial">querypartial</h3>
<p>&#x4ECE;&#x4F7F;&#x7528;&#x4E0A;&#xFF0C;&#x4E0E;&#x4E0A;&#x8FF0;&#x7684; <code>QueryRow()</code> &#x65E0;&#x5F02;&#x300C;&#x8FD9;&#x6B63;&#x4F53;&#x73B0;&#x4E86; <code>go-zero</code> &#x9AD8;&#x5EA6;&#x7684;&#x62BD;&#x8C61;&#x8BBE;&#x8BA1;&#x300D;&#x3002;</p>
<p>&#x533A;&#x522B;&#xFF1A;</p>
<ul>
<li><code>QueryRow()</code> &#xFF1A; <code>len(querysql fields) == len(struct)</code> &#xFF0C;&#x4E14;&#x4E00;&#x4E00;&#x5BF9;&#x5E94;</li>
<li><code>QueryRowPartial()</code> &#xFF1A;<code>len(querysql fields) &lt;= len(struct)</code></li>
</ul>
<p>numA&#xFF1A;&#x6570;&#x636E;&#x5E93;&#x5B57;&#x6BB5;&#x6570;&#xFF1B;numB&#xFF1A;&#x5B9A;&#x4E49;&#x7684; <code>struct</code> &#x5C5E;&#x6027;&#x6570;&#x3002;
&#x5982;&#x679C; <code>numA &lt; numB</code> &#xFF0C;&#x4F46;&#x662F;&#x4F60;&#x6070;&#x6070;&#x53C8;&#x9700;&#x8981;&#x7EDF;&#x4E00;&#x591A;&#x5904;&#x7684;&#x67E5;&#x8BE2;&#x65F6;&#x300C;&#x5B9A;&#x4E49;&#x4E86;&#x591A;&#x4E2A; <code>struct</code> &#x8FD4;&#x56DE;&#x4E0D;&#x540C;&#x7684;&#x7528;&#x9014;&#xFF0C;&#x6070;&#x6070;&#x90FD;&#x53EF;&#x4EE5;&#x4F7F;&#x7528;&#x76F8;&#x540C;&#x7684; <code>querysql</code> &#x300D;&#xFF0C;&#x5C31;&#x53EF;&#x4EE5;&#x4F7F;&#x7528; <code>QueryRowPartial()</code></p>
<h2 id="&#x4E8B;&#x52A1;">&#x4E8B;&#x52A1;</h2>
<p>&#x8981;&#x5728;&#x4E8B;&#x52A1;&#x4E2D;&#x6267;&#x884C;&#x4E00;&#x7CFB;&#x5217;&#x64CD;&#x4F5C;&#xFF0C;&#x4E00;&#x822C;&#x6D41;&#x7A0B;&#x5982;&#x4E0B;&#xFF1A;</p>
<pre class="language-"><code class="lang-go"><span class="token keyword">var</span> insertsql <span class="token operator">=</span> <span class="token string">`insert into User(uid, username, mobilephone) values (?, ?, ?)`</span>
err <span class="token operator">:=</span> usermodel<span class="token punctuation">.</span>conn<span class="token punctuation">.</span><span class="token function">Transact</span><span class="token punctuation">(</span><span class="token keyword">func</span><span class="token punctuation">(</span>session sqlx<span class="token punctuation">.</span>Session<span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
    stmt<span class="token punctuation">,</span> err <span class="token operator">:=</span> session<span class="token punctuation">.</span><span class="token function">Prepare</span><span class="token punctuation">(</span>insertsql<span class="token punctuation">)</span>
    <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        <span class="token keyword">return</span> err
    <span class="token punctuation">}</span>
    <span class="token keyword">defer</span> stmt<span class="token punctuation">.</span><span class="token function">Close</span><span class="token punctuation">(</span><span class="token punctuation">)</span>

    <span class="token comment">// &#x8FD4;&#x56DE;&#x4EFB;&#x4F55;&#x9519;&#x8BEF;&#x90FD;&#x4F1A;&#x56DE;&#x6EDA;&#x4E8B;&#x52A1;</span>
    <span class="token keyword">if</span> <span class="token boolean">_</span><span class="token punctuation">,</span> err <span class="token operator">:=</span> stmt<span class="token punctuation">.</span><span class="token function">Exec</span><span class="token punctuation">(</span>uid<span class="token punctuation">,</span> username<span class="token punctuation">,</span> mobilephone<span class="token punctuation">)</span><span class="token punctuation">;</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        logx<span class="token punctuation">.</span><span class="token function">Errorf</span><span class="token punctuation">(</span><span class="token string">&quot;insert userinfo stmt exec: %s&quot;</span><span class="token punctuation">,</span> err<span class="token punctuation">)</span>
        <span class="token keyword">return</span> err
    <span class="token punctuation">}</span>

    <span class="token comment">// &#x8FD8;&#x53EF;&#x4EE5;&#x7EE7;&#x7EED;&#x6267;&#x884C; insert/update/delete &#x76F8;&#x5173;&#x64CD;&#x4F5C;</span>
    <span class="token keyword">return</span> <span class="token boolean">nil</span>
<span class="token punctuation">}</span><span class="token punctuation">)</span>
</code></pre>
<p>&#x5982;&#x540C;&#x4E0A;&#x8FF0;&#x4F8B;&#x5B50;&#xFF0C;&#x5F00;&#x53D1;&#x8005;&#x53EA;&#x9700;&#x5C06; <strong>&#x4E8B;&#x52A1;</strong> &#x4E2D;&#x7684;&#x64CD;&#x4F5C;&#x90FD;&#x5305;&#x88C5;&#x5728;&#x4E00;&#x4E2A;&#x51FD;&#x6570; <code>func(session sqlx.Session) error {}</code> &#x4E2D;&#x5373;&#x53EF;&#xFF0C;&#x5982;&#x679C;&#x4E8B;&#x52A1;&#x4E2D;&#x7684;&#x64CD;&#x4F5C;&#x8FD4;&#x56DE;&#x4EFB;&#x4F55;&#x9519;&#x8BEF;&#xFF0C; <code>Transact()</code> &#x90FD;&#x4F1A;&#x81EA;&#x52A8;&#x56DE;&#x6EDA;&#x4E8B;&#x52A1;&#x3002;</p>
<p><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/gitalk@1/dist/gitalk.css"></p>
<script src="./javascript/gitalk.js"></script>
<div id="gitalk-container"></div>
<script>
var gitalk = new Gitalk({
  "clientID": "b9f61eecd453fb93cefc",
  "clientSecret": "8e70a3944fa689c13136aa56ea5bfb9945802bd2",
  "repo": "go-zero-doc",
  "owner": "zeromicro",
  "admin": ["anqiansong"],
  "id": window.location.pathname,      
  "distractionFreeMode": false  
});
gitalk.render("gitalk-container");
</script>


<footer class="page-footer"><span class="copyright">Copyright &#xA9; 2019-2021 go-zero all right reserved&#xFF0C;powered by Gitbook</span><span class="footer-modification">&#x6700;&#x540E;&#x66F4;&#x65B0;&#x65F6;&#x95F4;&#xFF1A;
2021-04-10 07:21:07
</span></footer>
<script>console.log("plugin-popup....");document.onclick = function(e){ e.target.tagName === "IMG" && window.open(e.target.src,e.target.src)}</script><style>img{cursor:pointer}</style>
                                
                                </section>
                            
    </div>
    <div class="search-results">
        <div class="has-results">
            
            <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
            <ul class="search-results-list"></ul>
            
        </div>
        <div class="no-results">
            
            <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>
            
        </div>
    </div>
</div>

                        </div>
                    </div>
                
            </div>

            
                <a href="fx.html" class="navigation navigation-prev " aria-label="Previous page: fx">
                    <i class="fa fa-angle-left"></i>
                </a>
                
                
                <a href="redis-lock.html" class="navigation navigation-next " aria-label="Next page: redis-lock">
                    <i class="fa fa-angle-right"></i>
                </a>
                
            
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"mysql","level":"1.9.5","depth":2,"next":{"title":"redis-lock","level":"1.9.6","depth":2,"path":"redis-lock.md","ref":"redis-lock.md","articles":[]},"previous":{"title":"fx","level":"1.9.4","depth":2,"path":"fx.md","ref":"fx.md","articles":[]},"dir":"ltr"},"config":{"plugins":["back-to-top-button","chapter-fold","code","-lunr","-search","search-pro","github","splitter","-sharing","sharing-plus","tbfed-pagefooter","flexible-alerts","page-toc-button","pageview-count","popup","hide-element","edit-link","-highlight","prism","theme-comscore"],"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"pluginsConfig":{"tbfed-pagefooter":{"copyright":"Copyright © 2019-2021 go-zero","modify_label":"最后更新时间：","modify_format":"YYYY-MM-DD HH:mm:ss"},"chapter-fold":{},"prism":{"lang":{"shell":"bash"},"css":["prismjs/themes/prism-tomorrow.css"]},"github":{"url":"https://github.com/tal-tech/go-zero"},"splitter":{},"search-pro":{},"sharing-plus":{"qq":false,"all":["facebook","google","twitter","instapaper","linkedin","pocket","stumbleupon"],"douban":false,"facebook":true,"weibo":false,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":true,"messenger":false,"line":false,"vk":false,"pocket":true,"google":false,"viber":false,"stumbleupon":false,"qzone":false,"linkedin":false},"popup":{},"code":{"copyButtons":true},"hide-element":{"elements":[".gitbook-link"]},"fontsettings":{"theme":"white","family":"sans","size":2},"theme-comscore":{},"page-toc-button":{"maxTocDepth":2,"minTocSize":2},"back-to-top-button":{},"pageview-count":{},"flexible-alerts":{"danger":{"className":"danger","icon":"fa fa-ban","label":"Attention"},"note":{"className":"info","icon":"fa fa-info-circle","label":"Note"},"style":"callout","tip":{"className":"tip","icon":"fa fa-lightbulb-o","label":"Tip"},"warning":{"className":"warning","icon":"fa fa-exclamation-triangle","label":"Warning"}},"sharing":{"qq":false,"all":["douban","facebook","google","linkedin","twitter","weibo","qq","qzone","weibo"],"douban":false,"facebook":false,"weibo":true,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":false,"messenger":false,"line":true,"vk":false,"pocket":false,"google":true,"viber":false,"stumbleupon":false,"qzone":true,"linkedin":true},"edit-link":{"label":"编辑此页","base":"https://github.com/zeromicro/go-zero-doc/blob/master"},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":false}},"theme":"default","author":"松妹子","pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"go-zero使用文档","language":"zh-hans","gitbook":"3.2.3"},"file":{"path":"mysql.md","mtime":"2021-04-10T07:21:07.996Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2021-04-10T07:22:08.598Z"},"basePath":".","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="gitbook/gitbook.js"></script>
    <script src="gitbook/theme.js"></script>
    
        
        <script src="gitbook/gitbook-plugin-back-to-top-button/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-chapter-fold/chapter-fold.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-code/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-search-pro/jquery.mark.min.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-search-pro/search.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-github/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-splitter/splitter.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-sharing-plus/buttons.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-flexible-alerts/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-page-toc-button/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-pageview-count/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-hide-element/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-edit-link/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-theme-comscore/test.js"></script>
        
    
    </body>
</html>