go操作数据库 Go-SQL-Driver/MySQL 使用详解

时间:2023-03-09 15:04:38
go操作数据库 Go-SQL-Driver/MySQL 使用详解

go操作mysql的驱动包很多,这里讲解当下比较流行的Go-SQL-Driver/MySQL
1.下载安装
  执行下面两个命令:

    下载:go get github.com/Go-SQL-Driver/MySQL
     安装:go install github.com/Go-SQL-Driver/MySQL
  安装完成以后的文件截图

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAnQAAACvCAIAAAD7bdRdAAAgAElEQVR4nO2da7akKgyFnVNNx8HUXByLQznj6P5hqRCyQ+L7sb9117p9LAyQAAHU0PwjhBBCyKY0ZxeAEEIIeRqNzufb/3Vt9Xrb/fXfz8LrOWp6Qdv9gV/lfdHyILaScxZIz03T4FIr18366nKSrOu6ubueoyQt+fPt51Ztt/Bf3ZN/ivSTfqbr4z9+92D5OpP+R8m//z/VLoTsj2/gXexcm7bTO7nZTf3ONVpOCHIjHvdyBZCef795natZ30rtXQP63fUcJNMJdpbijpQhVZ5+bt2FnI2d61PtQsgBtF2y4vh8v21yPZlzJ5Pp2MpDDi/p3F3LV2QoKFe8sXImYkQOco2hlB8X6wIgPTcx52rVV13pdtMVZUB/oJ5jlCvOfKGp3ZA7szJ92nMWOtfCLtC5QnsRQurMk+XSA6XT52bhth6QD69nP6UdW5nSB8uZ3qJtif5K803Ta/IviaFnv3M16qumN3eFn6nnANLJjY5Rrk/Rinb8O0uveeuRxLlq8pNUTueK7UUIIVG4/XUM1DMhhDycthuXAA/alrwg1DMhhLyKYi+a7AL1TAghhBBCCCGEEEIImbGDS5Cr4rVb1L5sD8dCfe8CX9wj58PO/WzoXMmF+Hz7/vuZ/78XdK5kLejTdX+EvG0H02icmqWc9drr3vmulV/q/57OVYmm4WvOJum3qDKkZ+W77ZDsCyhQMOtzKKf4ZL0eTG0rvf3imu3eyuhcyVpUZ5YGlKmO1rd0rkf58KPzXS3/Ic61iGGY/tUtGzSL0E12pKolzlWNhXYFksK13d9f3/dzhfveHiE21du4YLVih24Cnetrabsh+IqY9iUzRBnOV50h5iS9R4ScsQKCf779X/edhDkjQ5XfdqDyLInc5FKfFtlKRLRB+sRi7eQiX5we2Le2AHPWa5ICVhGK/nV7RdqDU3NZ+VG77fv+7+9vysYOt2wMkxH7wkEfxPJd41x17RbtQbVjXp5Sjlpf1N4UkW03KH7ycd+fYxTjxpjzVnorIljBXpDkX7RDRXpyacqDka1eTNspLQvFerViwJYrlfnK0NT6ruv/utYcTB0zUD09DB43s71zlR1so9i5YkQvBwirJiI9tC+K7Rypl566uCdJp9kr2h4wqF54ZTNO9sY4g1bNsJOL21dzwkL+9Oc656qFIw3E7k73nTpbnzX5ModByrCCbLvhn3/jY1Atsy31Nm8KV1sVaIflVGu6YvcX8ha02TiYCcLr4595U05Dlk4zz5pzdcxAq+lBeWrOVdVNPv8uHZecX8T1BvKtbI8V8xpjSVWxr0u+Vf6Ic93Ovo5yV8pvxdTV5Mkhc/IiUfs2+eoJTA93c64+15enlu4OSrRqr+vztx/8GxiK7PLabKW3n2+d/m+B2mEiY5wSLG4P5Ikopre3YdGd0LnOt/3+FZW/UXmizjV5pDZ26WKlq88mQuUEeY+bUGVabczA6ev21fJ21cuW59f/VnpD9arK151rTQ/poArLORvG2lBWV/AuJ6HJ39C5jsmzn8ptf5f8QvxUznT2LXYVsLylekvdc+GnPXqR7aft+r7vvx+UL53ra9l35Tr2j6wTbbly3dG5Vijlb7ZyNXNR8rV+Da9cA/X6sadzPW/lWtVDtoRZsVKptpN1K1d/q1fzabu//tsWMqzt1pozhFfkI6j++zGKu0Jvn9BXOLAdtsPz5f77abv++520wpUraZoGmF5sgKUNHj1rUR42zal/s8Xf7k/Wq5JnEvAZm5EeDxvKwy8gp0FXLDx60yrgeCZnnpOqrkRj6YdU09X8mWuoXs10qRzEyopCe0XbQ5GyVi9d/6ZzVfUwPtgwKuCyb5+rQdvg1MrpRErMihN1rmPf1decanUcE5xSyliAfHaTrYq301vrf+DaWO2w7f76vhuazrB8VctD5/pSQGdItn6K9o+2UuYNl+pAMydN3qb7fHv0dihOb3TrojxATlo1ZzeA/XbSz6rzSuEuL8jX2EU2Bjvljli9yv3BYghOLxv2iraHKXdtVa5pQtO/4VzNRc+fkkPMvtneJCpnMksw1WwKR/u8sE7lXW2n5Qj0DNobWhRbzlXLeBu9fWJf4eB2OE+28mkXHgcI2QrZ5h6Ca6dnh+2gvXeYzqrX1Ti9ig9b7yzTZ3TF3uyktwXlIOQQ0Bz3thidbdfzSvfu5GfV62pcYzA93cFvxkJ92i8XWLfdrN8RQjwoe9G1hBlXHVDd9SJkLdpz3vOgcyWEEEIIIYQQQgghO+DddopuT3E761iob0IIuSF0roQQcjv2eg209tLfWa+f7p3vWvnVCEeuEpzvXKUetnl5PH0dLK2j+T3rAtkXUKBg1mfbFdU88jxUQoiLhS++rxa8W74V9s53tfyHOFcZzCf7i+ehhkkK13ZnnodKCHGhhTfa7ZxXI18U2QTli6tjJxf54vRAD7UFmLNekxSwish+HQa78psYFPmoEuGopjkZNU+1L89DzYsvO0Ueo0tE79Pqi9qbIrLt/k45D5UQ4kbpRm2njJUohqoVW9Vawsl8UUzOWOxWOaKXuVuBE3keaiQ2b//leagg//zW7EejvoZ8mcMg5XPOeaiEEAfaiqJ+bf4LXR//xHF/Cj8cl6/LrW2PFf7fWFK5dFORb5U/4lwdK4zselRvjmV4me94xa53McWYvEjUvo3+7BAs2DZ3rj7Xl6eW7g5KtGqv6/NzxnmohJA6cGyXndzcfkSDEXauRb7L5MM6oV1brb44fV0Pi+tly6s+c3U514jeUL2q8nXnWtPDlNwq52wYa0NZXcG7nIQmf0PnOibPfiq3/V3yC/FTOcd/KLsKWN46vRFCqgDnt/vKVbm+1crVzMXaplZ+Da9cA/X6sadzPW/lWtXD/OcK+zaOdrL9M1e/cx3SP+08VEJIHd+AOl8MP3MFD9E88qcUlvwSnoc6D46G3pSSoHrp+jedq6qH6eksroDLvn2uBm2DUyunEynR2uqWtdMnScqbTtlC1uG8leu2cx0zznYBdtUbIWTGfMdE6+TJllbRr9HbnvNznmxnDO4V/8YEnocq9GasodLS8DxUcb2iZlM42ueFdSrvajstR6Bn0N7QothyrlrGu+qNEDIR3YE7NN8dCrd3fc+q19U4vYr6xOG2LNPngpXnw/RGyEmcte1j5MvzUB/ANbYTT3fwm7FQn/bLBdZtD9EbISRF2UOuJcy46sDgrhcha9Ge8xJCCCGEEEIIIYQQckmu8ayORPHaLWpftodjob5Vgi+yE3JB2LmfDZ0ruRCf35EH4//rydkayTmglxOtSIRlyu2a78KXJcOc9frv3vmulV+NMOUqwfnDmdQD+kA1Rvo6XlpH83viBbIvoEDBrM+2K6p55Hm0vzhZe+27ELIZqjNLA9xUR+tbOtejfPjR+a6W/xDnKoMpZX/xPNowSeHa7szzaD/JWX0e5V6iNZJb0XZ/u53bKsfXVoliLmOZKhGF7Ji65TcuqDyVKLGLPqBXhQzLGp5Hq+pft1ekPTg1J6MWqu2W59HmxZedPY+RJqInavVF7U0R2XZ/p5xHq37EV+34MEhWqHmSN9Fq50eiWK9WDNhypTJfGdpg33X9X9eag6ljBqqn1zy5vXLawLnKDif0szA2shzRy25r1YTn0UZiI4+Tvb+uVZxnXjIzVmjQvtpoLORPf65zrqXr4Xm0Tbop7OzyirRqPyXvRpuNg5kgvD7+mTe+NPTsNPOsOVfHDLSaHpSn5lxV3eSz0tJxyflFXG8g38r2WDGvMZZUFfu65FvljzjX7ezrKHel/GkDHVdPRr2LKcbkRaL2bfLVE5ge7uZcfa4vTy3dHZRo1V7X5+eM82h/vnX6fx1dO9facyfXQukM9jYsuhM61/m237+i8jcqT9S5Jo/Uxi5drHT12USonCDvHu5XaWMGTl+3r5a3q162PL/+t9IbqldVvu5ca3qYklvlnA1jbSirK3iXk9Dkb+hcx+TZT+W2v0t+IX4qZzr7FrsKWN5SvaXuObKnq0qz+il5PfuuXMf+kXWiLVeuOzrXCqX8zVauZi5Kvtav4ZVroF4/9nSu561cq3qY/1xh38bRTrZ/5up3rkP6p51H+4l9hTMVLtDvCNE7g9gASxs8etaiPGyaU/9mi7/dn6wlJs/w4DM2Iz0eNpSHX0BOg65YePSmVcDxTI7n0VbaQ5GyVi9d/6ZzVfUwPtgwKuCyb5+rQdvg1MrpREq0trpl7eBKT19zqtVxTHBKKWMB8tlNtiLcTm9t9IErKK7R7whBnSHZ7yjaP9pKmTdcqgPNnNR3/ihOb3TrojxATlo1Z2eD/XbSD8+jLfRv2CvaHqbctVW5pglN/4ZzNRc9f0oOMftme5OonMkswVSzKRzt88I6lXe1nZYj0DNob2hRbDlXLeNt9PYJfoUjc9dy4K4wOZh8qv8YXDt/K7edDxIZl793IS7A6VWM7aJcnmX6jK7Ym8fpjRAbNMe9LUan53m0D2BvPfs43cFvxkJ9LtxpfY7eCCEpyl50LWHGVQcGd70IWYv2nJcQQgghhBBCCCGEPJxrPPMihBDyI/hCPCGEEEKccOlDyMbwM/lns5V92U6eDXKutDshC2HneTZ0rsQDnasbFNkEnquKIuYon2oMZtC/4QCRjKbEMi2SE/1EBEVQSj6MuWcLAV8Ta/Uy9KmqIRohKLvnaXqOgtpn2/2hc3Yj5yuD9CE1m/bVy892clWMdhWxox1WNjcJ7a7SdlqgchTTFcd6xbE91fifwVi1bjnVb0S3if17PeIxdVUdtnkzL2dP3vb+VD1HMerbdn/qR83q9aAc046OstbyZTu5LpH2A+wYda5FHq5CvsvubRrTFZ0yoV0X6l+cfkRzrkvk4BqulHM1jPjBUbvgqgc6z1P1HMWqr89my+SYdjQKK+1r2JHt5KJE2g+w4+7O9SV2F2GCkoDpinKt638byBnRnGskX8TS8lwd1NwX1Nc+AcDZeZ6q5yhm+ww4V1NvupwFEeVL+xrlZzu5KqD9ROy4t3N9h91zfaxauUYG9yUrVyQntDH/1BnTgpVrrRGXXYUz0zBW+9xz5Zrf6rSavnKt3ct2cjFA+4nYkSvXLSjWLOmKcOEz16b5jMcuYiO1YM99LorLuYJ8k9uEZJRve/O9/mx/x3+O6ZRotLt1PiVUzIv0HMVonxHnaulNXaksOWdUMwjq12wnl6U+Va7bUXraXCJoUrS7INsVqJ6j6XxbOPPXaDhR3xYDr53VtsXA/pRiVPyWWpL1Pd9SA3rQ6oX1ae8mzlnUJjEP1nMU1D5DztXQm5p+wa5wA+yrlp/t5LIY7SpgxzS1PPd6/hVcpt0NnM/wtuKs5f/Ntx1uA/VMPLCdvJN32f0A53rW+aCvOpf0RKhn4oHt5J281+6HrFzBHsLunJXv26CeL8ZskIyzBza2k3dCuxNCCCGEEEIIIYSQS7P6hYvw45TkVUrjE7XHv1hJCCHkuRz+NmMsw53e4SeErKb4Din/SnjqvOobEf334/ueVXyjnJCNDOlvHDICgE/WoP7nRKO9oH2hveR3yXOgFTV9tF2Z8svyp7Ur9LCCo51r0FvSuRJyUX4jmIjLoAyCTfJ7EajAFYkpGRyzEVcNuNQ06Zk9xOLz7TOVjv/E+k+cXuE85AVorzlznB7Z3dGuLPl6+XM9pBFoVkDnSghZwNA3swFkM+cKYkUi+RwmFuKL9pPrvwNWUi5U2oPtXJP0WzpXtfxBN/j59n993//9/U2Bx7KAnr/lbxmhxs8kpgznqXyLUEQoK4tT9g/Qa4KfOqCIOcm2ArvmHWi7P995wEq7ybtqyOxsPwqjPtNxaSvnqryAMe0DqrH4Bku8zwgrcX6XLPT/+faTrw041zKzU1auWvmjk7NR8LTe1aZ/avC2GLJcw0Ck7C7oySs/aFejMVpfEev1HYhnJvPFwo5ld0seEKXusd6n2H40srmKvjvrc67ajFsMG/pDNhifkl7WSzE869fl5EabV433aduwqr0avG1bpN/WuZbll11cLa0QPCokG1TAin8pmnM15K93rtHyo/Qb64EcgGYlvIOVNf90uhoyNduPRtLNxT8PWrnmD8kykMsgkmUr12a0VGTlqtmrvnJVt/1XO9ei/FJirTcj52q9oLcEzbka8lc7VzTZdZYP6fNtg+M9UaxUsW/b9X3ffz9pMvB6pA7bj0q2xvhbOgiueuaKtwveZozlLHnmOlu6CzhXzV6VZ67zn5s7V1l+IWCpcz1i5bqnc52WJF648ngOgZXr+Hy2/37arv9+tVbjWuKw/SgUlVfePFGcn9u5gj13Y/DVLpMq+YLS87Zwvn0acK6lYRwvNCmGd7Qrh3xRfqmH7L7i6Sl0rvAZ0jL2da5aR5HToeKZbmlxPjN7BmonQnZsu7++74amPyxfhyTmecBsPx6k4pRnVuqjT79zzQSlg16RbzL8+vcjyAzYyKnqvy1fgKg419lecv9RMaJoQKF2ZcmH5U/vUaT5nGsiZs3bwuX+rLKCdzhXICeVUNR3NoK2S6hfVOqrtR9yYYwZKuiOU5sUz3L01sP2Qwghi3jZ9h3ZGLYfQgj58d7zNckWsP0QQojKvI3M7TsSh+2HEEIIIYQQQgi5E/Cd/xvJ5/Z+gfuFgr3tQ8iF4Is25DjoXB8JBxFCStgvyHG807luFZziskEuOIhcBfCdbtPk3wLLb4jl9TIoxxzrxfj6VVIkH4uE5LT5ORpDbYZ4k2qulf4uv48Ml2clL+8X0fHqrPHtsuNqDDrXNVy2Ebx8ELkcZTMtQl6h0GVKuFDhXJe0wFqQkPR634/hnT7fvu/70blmQTymyD5Wf1eDgYXKs5KX9ws610P5fPvpIMtifqi8Wj10HvDOtRIRBqX/fPE5mjA2SFueU5iMWsNtFZuYgW70aiWT6Hx4i06tUQQTNYMFTHJkRCFFb2lyacM8tkpVP0g+ZG89XJDCuSInhK6f6Vy77++olLYbOqt0rkl5TOc6DQZqcL5VztUaT2C/eCbh8Uobb6PjpKX/iB+54ri6mMwjyZiTyvXcg6VdIJm+Ns3n+21L+Un6UeQUciuJ6ZqrRxq1jGeXyXGhdV0QA7PNzVXOPryZ7h1704iFq+htxAydn/1olNOQ7y/no2OQ6itXrfGA66c619+5uW03/HOpcx1/07zrJs4VjCewXzyR8HhljLeBcdKt/6ofQfkaFb7qeCLynU3Tlmufjz99Vb4V0zUBlELI77qIZ21U46GcsjmDQ46RZUTPYSw5hlRlMCxttEK+u5xb6eGaqN07mVlv9sw1MMUpnJkm55fvbz94+NfCbeGs0LKc3vIg4Hjy7HZVsm68Evrxj5NR/UM/4itntTyXsDsKIF4uz5UBFw3ETvnAuYp+VXeuf8OGRMC7lsZD9c1/UoYEZ7ZOvS1uBKacmHMdk2c/GfoJlXpvPVyUytzZXjeOAs5buSb/SJxrgtju03JUljkLyoNA48nD25VGdLzC421gnLT0H/EjRjlhZS87nlgr0YiztFauIeea69W3ch3viyyflBlZzZzlXReaYW23cv2lbwvLwZpy5VqjtjGF6gsGixOca5q1XLmKn/XyyLUofBhhlgfBlWuJa7yyxtvAOGnpP+RHUL5GJS87nrieuTbNZzwPEisl827ZM9eoc83XjE7nGnKv2liH6mudawjHTOXpTnL3Cc9cQ851HAizH3T9VOSfoIdLUtSoUOC8QlWvZ+oXjf4WzrUY7IrWFXGuRbvCO2FGv3gg4fHKGm9D46RD/y4/gvLVS3jp8eTz7T1vC2f6t7YfvemxMbJdDeWtV+hcm/lpep25qGIsK/ZGjF0WJAd040nSTucdIvmq8yv3a9K8204rjKofID/J5Wg9XAqp5z4b+zR9ouuppOxxJ5BvojkzTc4S56o1K5le+dtVnjQbn3M1+sUjiY5Xxnirpm/scV5bJEX9CMqX4wlx8KrtKQPqgRCyFRxPXgrPOxygHgghW8Hx5FiKTaXQltkBxXr3NgX1sDMXbf+E7AHHE0IIIYQQQgghZAlGRJX6jdpeE7pOjsT9YH+x/QkhZCceMS4trUT1q3dyJjQDIYScyULn6ox2SE7i4s51aeiDveTsB+wQ+PtX9VPF4hWlJLZE/u2s/iHtWAYkhzyJ6/eLgbuUcyF0ro+EzvUiVDqE8vFAHgll/M7AiqCU+049+oN+Lix5Jnex8l3KuRAUoQlG0ChCsFSu/+5W58lt98dzQLdj0sOFz3M1A0Pp8lXz2gGmKnkf2H7CzhVMi8zwhF0ZURXl+/Dh7PXU+pfWT7WYTkP7qcRnUoIrSjnijjyYnl5OfVwCGRvlrOto73EAxRauhKcKrFyNGI9iT8vmwjEkL4ERQ9XQc2kwETcua/Nb2FHIQuVPzJs2/zI+p7cfnNN+os416hSH65/faeZi5QoiWNK5Ph1gZbWf6ue5Zn4hlQf7IzoXtlVjzpvlbMC4BPyUWk7IgeOAkINmvsudaxF9uBLzFoHuXC7xWSzUsz4bUtrAVnYcb4C5ir+yvumQY2R5RvuJOtfK9u+EGBLGbMLPXF/aWx4Odq4Ve2d9P94flZzMPAPOFfRTWM56yaxybjMOVAPr65m5nWu5/F9WhYXlfA21AxUCznVMnv20lR2nG/CWkpRvRCL3O9ez2s8xK9dmLHl1U5kr1zcQcq5ivlXtF6g/euT4yqnct1X/PXQcOGLlCpXLlet2bLdy/aXf6TzX8QZl5RrY0MFyjJvvsHJFJag61yGnDpR/kkrn+gYCzjVPGnI22a1AzhEr15BTPHrlip515U+8N3jm2jQfngO6F0g/Tdy5jpNQ2brjdgRohtLl3+c8XZ0j3hZOa5WsGHIDceX6IkBDBs41X5PaTgv2RyBH7COLZ664w0WeuVYWgeeNA+ht4SZd5pfn/AWcq5DkmKU3qlLwW17JPsWrxw2kH1XP9uu2bacpM25HyCxK+IBCvrErjORcqP1ANcsf0sIqVZbPStNHYNnqYRaU3qJeRDol9wf1r9LcWWP71leEqD/qckRh1IWz2S/yGbd6LeZc6UdqvHf7l2wB2w8hhOPAD57bR9bA9kMI4TigAvYAydUoNh+vsQXJ9kMI4ThACCGEEEIIIYQQyN0fdN+9/ETAx0NkT8Rbt3xxluzG3Z3T3ctPBHSu5HgqX2kTB8qnS9Hvh/JP7GT68kOn4pWX5DMnZE48nTI+pFrG3Z3T3ctPBMucK0NGkJRoe6BzXYkeEcZ2rlkwmDFB6vTkR8fJR7+dGYYNmxNF0NDlr+Tuzunu5ScCOleyHjrXYwHDsOlchx+zay04VzIaKxWa0xcTssrn2//1ff/39zcFpiqj15QRqW4BKH+ySTBrdjJh4MkKimyiZkCapjEjoOHYU8pGjIj4hmKpadFs5E9hc9Hu98EKTF9rD6URUeRxth8XzjiGrQwT1bX5xRacKxk95cNZnunP6NxqHKSm9a4W0lwNmnV1QPnFFCgLF51uNETC5jO2sxsYu7uJnX9ZtNsJS/+KXUF7wNDud8LeccT9XB9H9VDxbD9OLCeXk02ipyjgQlWF3y0Diw8/yGeu4FkvKueUDMlHpDeOBcn+P2V3M2sbK3utKqI91+vr2zm4n952xqnn6k7M59v/9V0nPWtF/7pzDZmIdr8VRzhXth8n8ZWr2KCSAcTb/FxJKT/xZbusXGtWQs618gLX5THKr+4+RutrbTfdWW97Y+hHzC/tnZ7BiH0vvasxCW5AL7NPQnCWn3a/Jrs7V7afAOFnrnLNOS1i/5JXobSnr5mgvZ65LnWut59JOcqf6jzcuN88A10BXLnmHcC3ch07jmjweGvO3u73PAyg3e/FAc7VIS1P9OL2E3xbuFAK2p5NV7rZ0/NlzhXu0evy08rJC6pzhc8G7oJefnT+YvRTq1c/O1kBfOZa7C2k+sTPXGUC0ZM+2TGuikHs83Fp99sjO3kx+umGAuNu0UTYfqIoC300+EqFjn9n19v8o9ds7yoZIbTdLOOttvS33KaK/PQXn3PFb7XdBb38+i5O3Lli/UC7kEHP6tvCmV2q518a80k1fflT/iqbnpp2fwBpayjGsaI9WANueoP9lGmE7YeQlTx1G2dz7I2120G7kzWw/RCiwHMQF/AA50q7kzWw/RBSpdxjJBUe4Fxpd7IOth9CCCGEEEIIIeQBoBe8Nn/x6xHbaefBFwcIuS+H918lSA93cs/BGUeJnAWdKyH35SL9l+P5CWzlXF0xPkicnTrnVvZ6j93F99zZp+D5F9xq8JamTLE+X/RVo7ZcQeW05KS//S4XyYfPHmELhelRvsP1NJjGcAPSQ0Wf8nvNcHlWcpH+u5Vz5bgRgM714lykc+4t5/oUwVXU6If7ONd6vuAOLWa4KAWUI35Iz/75/RxqmDI9yrft/v76vp8r0Pf96Fw1Pdj6FEHmFpRnJRfpv3Su6wERXpJZmRLlyj8EaDE9jMAgU7ZSklaeIUf1XW9cfACKJBIWdBJTOXc4z9UM5KKLgflCObW8b2gXn3Pa2bk6naIW6zUqp1bOPZ1r9/2deNl2Q1Qs6Vwdek6SqUVd61w/333Pk7YC5YN+B8dboKVQt3v5uKHHMrVjP0aGAHRupfa3JUkvTxa7NU3T5uqsa/HuMTBB+YEeoN68eaB8tdi5hf4jQ9K97XIJ55rc7HSKaZTQ+MrVMO6uzvV3nnTbDf9c6lzH37SybuJcv/udJ22HNY2Mt+BqeFxF+b5h3ECtHcxkm6lUi4aA5cYG5RH6mVNlcwYHqL6mHi6EUX6tyFBvtUzMzubVf6CT3Nwuvu3ZnZ+5Gg8PlSEny85yrpoc+ZsypK52rkb5f/vBw78WbgtnlZSF9ZYHkSp2XGVn/9ezcXOEc40X7aXjhrMzr3Guov0tM7a13QHKaUaY9tbX1sN1iOphWb1Ke5XbNR79+zvJ3e0iGr+2mGz2cq7pvL22R4FWrqicPguWqTS5twMAAARBSURBVPZduSb/SJxrXf8pYltMlHaLlavmXLdqz7s71+C4ivJ9x7ix98o118cuK9easlwmucJMZw2OcqZ62Mq5Nq11nii662Yz0BX4nNkB28Lqijm/od6/os61tMvuzjUtarEtnP+sl1+uRe3JwVbO9TYr1wR/3V87bmTrcOczV38bL9dQ0knrlYs8c9VnKG87d1Av/8LzXAGaAuQwPjoJS/9QkY+zi+XMMmNUtitXOVdlYWfeIZ6BaeU0nJaWbXrl2s61GHytOX51uFdHPNW5wnYeRNpr8XirV68yrgLePG7Mk7Usq2R9XupwvEfTGV7lrzpfUCsPdhLm7oXafKc7bnruoF5+XQ9Lt0cKe+UXRQ5Q/7qcB9rFGIDSlq618ewno1u48h2n0HJd5rCYWk5DTvpTYfktnKuW7xLnqulT05v421WeNBufc8XtPEjaG48+z9VRKI4bb+ey24wvh3bZnzXrJkKuCMeNk+G5g9eEdjkcjkXk9nDcuBRgz+E9FJtc4e2fnYv1UrsgLmovN3cvPxm4qB05bhBCCCGEEEIIIU8i+kkCIWQz+DCWEEII2Rg6V0LuTTTuCSHXRLzqgb8TVaLDydg6WtrhuvhMti/C/m3VnehcCbk3dK7kGWQtOQmGZrfw32fuIFRQGlOt7RznmG5aHTpXQvyACE3J7FdERCrfcUbXhSA9+sex57xCUEQPTf4lMfTcf7/lj+A6rK+ePqye2+s5QO7knLF5p8ab6wbKqZ5jWufz3fecUUJeSDoPrscWHgbGdBhOw7OV13EsR5SvvD8nEnNYL4+lhyvEolyKUc62+1M/OlOvB+UIF1Af0O+u5xgygmo6I0G6GpOlqhXpRUTaT+Uc0zqjyj/f/i/PfKOYt4S8DrTRk1+f/hLjXvU6kmNvMAWca7CcEF85r7stZpXTZ+NlcrI50opy3kXPQbJnn2Kb90//KVuWKlOP7Jff9Y92jimQr7L3aS2EvA7nKRyZ04pe17r50sOM5H3R8iC2knMWSM9N04Scq1lfXU4okvfd9RxFrvvqeyli+0V/RluuK8d/rFi5as71qXYhZH8WrFxDg2MLzu07YOUaGhTuvqJCev79ttvKNb+1PqDfXc9Bim3h6gtNcs2pPaM1nt1u7FyfahdCDiD+zDW28pDDi/bOo3zmGjl3MFbORIzI4e7PApGem5hzrTxzLVe6bzs3N0a54swXmtoNYve4SJ/2nIXONXAUGrIXIaTOPFkuPZB4e3PRth6QD69nP6UdW5nSB8uZ3qJtif5Kc8/z/ww9+52rUV81vbkr/Ew9B5BObnSMcn2KVrTj31l6zVuPgGeuwghnnDNKCCHc/joI6pkQQh4Oz/87BuqZEEJeRbEXTXaBeiaEEEIIIYQQQgjZkH/gP0JuA89rvSdeu0Xty/ZwLNS3Dp0rMfhHCCGEkE2hcyWEEEI2hs6VEEII2Zj/ipYqeBKjlagAAAAASUVORK5CYII=" alt="" />
 
  root/go_s是go工作目录,环境变量:$GOPATH中设置的值
2.导入包
  import (
          "database/sql"
          _"github.com/Go-SQL-Driver/MySQL"
  )
 aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWgAAABpCAIAAACYrC6TAAAHN0lEQVR4nO3dMW7jOBTG8XebAQxMlTukUZU+VTqXOcAAaVSnS2+kDeADuA7gi+Qcu4UjmiL5KD6ZlmXp/8NikZEVmmKizxRFMfJfRwCgEMEBwIzgAGBGcAAwIzgAmBEcAMwIDgBmBAcAM4IDgBnBAcCM4ABgRnAAMCM4AJgRHADMBoPj74sc/01Zo/GeP3++3x5uXQtgBZbT4yA2gMnMNDge5biXJ8t3kBvAdJYSHOQGMKFccDzKcS/HfX+M44987eXrQ457eX+Rr70c9/L653f760vqW0Te9+ntT//k6+X86vvjbzlH/7+SEZaHt++fz2fz0QMYxTw4egqIP/L35bdTcDr5f0/4bs/XD/l6+f366V96++9Lp9wJWHscdDiAKY0LjicReZTjh/ztB8c5ArpXReRd2S7ue2MEBzBndYPjfKq7gNC2i0jF4OBSBZjSQnocdDmAKdUNjhFjHOngCGKoAMkBTCcTHK8f/bsbp7zI9ziUuyrnolJ3VZJO46ald1VE5OHtm+QAplFtHkcwlnELdDqAiSwpOABMhOAAYDbTKecA5ozgAGC25uDYiRxEDiKbW9cEuDOrDY5GZHfrOgD3atnBsRVpRTYiB+WlcgeRxlI+sGQERyGCAzhbYXBsu6GNQ3+MY9eNerTdF9tue7B/vnxg+VYYHP5Lvp3Ittu5iQZB6HEAZ8sOjoxkcJyi4dQHKQkOYKUIDofgAEoRHA7BAZQiOJx8cOy6sVIABMdZPjia1F0VYKVWGxwAxiM4AJgRHADMCA4AZgQHADOCo/p6HLt7mPGx8W4Szb+2mB2CY53B4dxXbTEXyw6OkofQCoOj/JN5ylNxc3HwJWvLw3sYQHDcdXC0xlVFYgQHxlhncLTd5f22Hxz+Uh1uY349juT+W2WaaXJ/8TYGKTA4XbWwHO14heDAOCsMjsb7p38iNd7TKE10zsQ9Dm3/Xb/83dD+bX97k9pnm1ohNZg1X1gOwYEKlh0cSW3/cTXtUiX+MM9fgPgriZnKb5VlkwfrGWwZVw6DoxhjhcERnCr+iZRcUtC9FJ9g2hKE1vLd1VDwPG6mPsk1U7VytPrErwJFVhgc2idwMNA4GBza/lqPI19+/C5t9pTO94CCcuhxoLIVBod2ze+fYMmxgGA9Dm1/bYxD2z9Ik+TYhETP+MdXJSXlxMd1+X0ZrNEKg0O8uxv+ieRPpoxPsPgGh7a/dldF2z/Y7vPfdLCbkCknc1dFUlc3wIB1Bsddu/Bv0GmDtYABwXF3LhyVIDhQAcGxNgQHKiA4AJgRHADMCI5C5fOvrWMQzKSYEvPo6yA4qiM4sHzrDI6KD3HFMzjvMTjidT20KSEmrVeOf4zJeS7Wdjgohc+B357xYQ6OT9dqtys+rEhwXGgZweHPH930D2o79i5MMCe19Z5CTs6sHREcjff1rP7Onn/sB+/QNgXBUbHdCI7KtAZNziiVVMyLvk7Hrj/js+lvdwZnmmZoM0rbVDm7rqpt90V8jvnltPpJmCxfo/1Ca8/OXBIc8coJO6+2/jkcV96vT3IFhvhbtPLjg5KuwXfee51eDQLCPbVYsd0IjspM63ScaK2f7HG4PYN1OrTgSH6SaJp+3ZJrfASfSFuvHxFPPA0etNV+EQfXBwm0ykVEUL775yXBIf02afQ+SPxz9BvEb4rM8WbKl6g9D91buOuX0/+DmrjDqdhuBMcU8k+RmoKj5JMh6HFo7ztYz8H65/8mbvyO7ojcwy/bbPn5qsY9r8MkwaHlWvLnmPwZZY43P+s/2Z7brpOySb1d8EDjVdutDoLDya9bYQoOLSBM2wvrWf6+yeDI/PHtE3f+ZOrpLrW00ynT8yr85IzLrxgcrdcp8ysWXIqWlB+358Fr/6YfHMElTOzCdrsigsOp2OOwBscNexxx/YNy2gt6HD63/2RjHEnJn2PT/RSCUUmtPpny4/YMtgQ3sA7RlrjAuu1WB8HhjBvjiNfp0ALCHwwrWb9Dq8mIMQ4tOJInQHBXxf2+Wsc44kGBwnoWCrrx/k/BGhwSXRcE9ZSC9VC07fngaKOe1LXbrQ6Cw5e8q+Lf8tB+vQ56lzL4eInLz99VSa6god1Vyd/nj4ND+53zl/YIrmu0eiYl+/lBOW67dpeqpPDgKJIncP7n2Co9kWT9teBItmc+OBqlk3K9dquD4NBYu+J3Jz/CN4FN1FO4a+Pac8Qtj1m0G8Hh8y8lbntSTWAOE89uHl4VjWvPcUs33r7dFhocz58/Kd9v+W+LrzuAK2nu+jdtocEB4JoIDgBm+eB4/vz5fnuYuEoA5m6gx/Hw9v3z+TxtlQDM3eClCp0OAKHB4KDPASA0PDhKcgAIEBwAzAgOAGYEBwAzBkcBmHE7FoAZE8AAmDHlHIAZD7kBMCM4AJgRHADMCA4AZgQHADOCA4AZwQHAjOAAYEZwADAjOACYERwAzAgOAGYEBwAzggOAGcEBwOp/GbqXGSori8wAAAAASUVORK5CYII=" alt="" />

3.链接数据库
  Open函数:
  db, err := sql.Open("mysql", "用户名:密码@tcp(IP:端口)/数据库?charset=utf8")
  例如:db, err := sql.Open("mysql", "root:111111@tcp(127.0.0.1:3306)/test?charset=utf8")
   aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAuAAAAA5CAIAAAD4EgmQAAAIqUlEQVR4nO3dMW7jOBSAYd4mQICtfIdpVKV3NZ3LHCCAG9fTpTfcDpADpDaQi/gcu4VW9BP53hMpyzad/B8WiwxNyxRFUY8UZYcAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABu4Sn8/QhfH+HrPfxz77I4Vtvj6bCuesv6cDpuV37K+ANOp5OdAQAA3MzLW/j7+96FuAY1GLHDnBkBEAAAuJbX9/Dn170LcQXWZEltOgAAuINvGqCY8YY1U0KAAgBAE17fw9eH+K9fg/IU/n6El5jp1zj91zn/i9jUy9t4I47V9ng6Ho+n0+l02PbLPmJgMCwDSVaCrA//J8rAog804ktJ0OHcsNFfWm2PBCgAADQjnUFxA5Svt/+TX97Gf8e45Cm8+vMxQySw2h77qCJOXawP5whhfZgKOfpgZkhJ8zvzIVmA0gc5rD8BAKAhVQHK61OWHsIfmT4pxgdDDKHHElmqFqCIHEn+mgBleAMxCgAAzagKUKbTJzkByvl+jfK8rxagiH8nEUn1LR7WoAAA0JJLA5TFZlDGcxhFMyh2gMIiWQAAHlr+FM+fj3PK6/t0gFK/BsUKUMarZS8KUHjMGACAR6Y8Ziwe1Xn9PR2ghOqnePRbPKNneLYxXhDJ8oGdqQAlrLZHvqgNAAC0pu6r7oclMMyjAAAAAAAAAAAAAAAAAAAAoBGjZ4F4GscknolqrpZaeNL7OYTP4b/uvkXBlXUh7O9dhu/toWt4/917gP3Q0T3P3UILPfaDIECp0mAtNdbYv333hEu6ZhR63PPocUteYpnYscHrSKMIUKrU1dItpl3U+GQTwm6Y1bgxtXtaqjw32K/yGSA5afTcQHovDu+SbnSpma28g3bKE9N3WgmdvUhsjJ1aJL9fn6qdsX0r3SqP/OiEfyF8zkq71PFVt9PVzI/eN0C5aj2EoQtK7Iwm5PRXjY0rm0WAUqWmlsRvECS/0LggvZ0ToMw2o4OzLmy3T/8MYTP8vRd/h+U67t14s0559uO/8249lI1HO3G4d8Z2LskfFQYoG1GTcvtWulWe5/FBScrpN/J8v656YVb3xfLTApSNaMObcf04/RXXW0f8dUHxzbOr7fF02MYh/2V1d/75wvF21of+I9MXrXSb8qX+F5QyL2b+zbzxYwurZhw6rIvqWam3/hOtCjXKo54Y+2Hwuhv+6K80SWcnz0B1BBzEiGGjXZZuH6B0wyUwKa0c2ajlT+onGdknH91OIKKmJ8cxXvud/ZIj47ipvRjx58fLufw4F3grENnb4U4kQ6KSJlSbP1LL7xz3YO+XTLfKMxk8FVZ14fFN3l4ys6XuV0n7sWZcNlr+YJ+/Vv+j7ldJ+cM4vyxbLJK1nU2W3ufPg065v2a/R4RiSUb2oy/MX2LE78wcrA/6V85a6bY0QMm/2H8q0BkFEOvD6PcWlfo5f0xZq0pyxn/a9azX2yh/8suQ5kShFaBsxLgt9qFJttinyI61Eydzl520LQQon9mlLinnfiq954ycGglErHR54D6H/+evRt14C3Lqxa8f62rtvKROjBe2B+tCslR+P6cfoFhBhkx3LoTqBT4Yb5RFyj/UOr7xLWrA1GXvstp/3GDSD/jtpxv/vdHSg3H+FvY//vkrb6Il4Y7fTpx+II+W5AzKPstMgFLFGdlr6Utt393qPW7IrQ96TOSWuLxVJaHEKEBRtz/ruNRUXDwh+1NRnlfxpWQ6Wh0dJpP8JQHKtakDWaucfvmdDtrSQoASO8F4BJPZ5ny/rJs1+b2hZ/ufJeW07gsU3n/pW1SMtyYPUG3+qDyUiZe9riDdKo91IU/eWFjOyeMr279zW82qrvwqO6/9qOnW+Tuj/yk/3EsFKEEc98npwDMCFJ31Y4GTPyJYsf2xRgOU5FcWVyLRrodlZlCs+tfqbanyuAFKDPyTk19dcemf2O0EKP7INU+P/3zoACV2oNbEWGQdqdnHVy1nV79fVeW5PP+MnJFzEc2j/+RTJsvpTEbm1OObzBzkd4XywlvtPz/FZrQfqzzOHUC1/7G245S/qpzOdqrWoHgIUAw3mEEx6/16AUr9LZ7xxyfrYS6fQamuZ6PeJgLHippzApSY6FxL5Go+ZlCkdgKUZzEWTwblS82glC+SDW50kk/OW+67BmX2u9T2lqxBcS6QVsmt9qke38mWnL+rvP077Ufdr2TCrCRAUUvl71dS/hvc4km2U9gBEp+Y5q1Bse6IuNsPYbU9FszL1AcoFy+SXW0PYgWKDGa8NSjZIhCnPAVrSqw1KKLepma2yqvOD1B22Ugl6U0K16BUPTcRatqVQ+3g5q1BsZZtPtwaFHkHIWj7NW8NinMtScrjRCdqeeInqtvp5a3r8vxW+a38u+xVP90qT2e0yfxVP7FnHV+ZIS+nOu9iHRd1parafqwAZSMyTwYoJf1PKD5/c8kTWPlAq7Ae8kWyJWEujxk74nRDxVM8VReS80MnZVfTOwQoxh2eoThZ/WQvjpPV8mjfg1L4FE/c1OStt9X2WFYPfoDSZb2VHHzk69dien5CWrPHqusFKMF+GsV5SqVz36LuaT7VfJd0f05C3a9O27j/FE+foaQekqn4vLGp1Hp2vtdkkfxWPav5k0H5ZLpTHuuplmAMxJ3Refnxdc5razvBuLVktR81QEk+dzJAccqpfq5ffpVVHmc7aj3Ipl40/8T8ydKsmYPvbvFA9wpNc5EyVk2GS3kfUeOntqvr2FdOX1kb8TvZyQl5XKh2+gSPhemTpRUP07+bRwhQFlF7aya6KED5se3qauLk1uyL2V1WEWESxwXA2A8IULriGVHVZTMoaA4XQgAAAABL+df4DwAA4G4IUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQHMIUAAAQAP+A6KRuM/dC33UAAAAAElFTkSuQmCC" alt="" />

4.增删改查
  下面例子中的表结构:
  CREATE TABLE `userinfo` (
      `uid` int(10) NOT NULL AUTO_INCREMENT,
      `username` varchar(64) DEFAULT NULL,
      `departname` varchar(64) DEFAULT NULL,
      `created` date DEFAULT NULL,
      PRIMARY KEY (`uid`)
   ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
截图:
 aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcEAAAB/CAIAAAAYbu4OAAAT1ElEQVR4nO2dsW7jPhLG/Sh5DlXZfl/guhSGnmC7O7eqVR1g4A7YylcvAqjaJkBaF6kN/IFNk/b/BrxCEjUznKFIxpKV5PshhS3TI0qUvwwp8tPOAQAAKGV36woAAMAHBhoKAADlQEMBAKAcaCgAAJQDDQUAgHKgoQAAUE6qhj4f3f2Du39w3w7u9dE1Z+fOwxa/vef1kW2nHzXBFr38gzu9xeKoWHES9+sL0+P69uCeI/Gj9Rm4tNWu7hIKXp2u3lXtJau8Z77GpcfVVlmVAmDrJGno89F9Ow6veylpzsPr/eNUxr+m292b21OteXP7g3s+joJFCj8fh7Cnw/BpLE5AJI663/4rfUnnnDszTRQl548rQlfv8tTsFlzaqmrzvlJwXF19o38oACxFgoa+uf1R/0RqylFubwKV8Tns9MURr31h/DBOhDCOtV+poeQw4xqaVR/Bpa18otenflSH2mpMBatqErXLtHlHlK7fWrWX8fNBn3xxGnnYb12HuSbNQNVdJOams9wsJwdgMRI0VNO7Hqqhp8OkR77bG/Z2T4ehdxzKkKqhGb1mO461X9o9p912Z2toQX1CLm1FBcwr3YV0dPskr39N+7+XtqIa52W4f00V6hJ0my9tRXWWfarloW1FVLird7mJqgRZKPiEvFdDvQaJ/E7P10iuFyrdgnmosV+Zhz5MurlcHupsDdXHJGkSGqaE7OtyL6GGGvvVNJSVju8qjdsNDQOwHGl9eUMypjz0LG+/qLLrb0wN2dxRfmppaBaqOqv7ZRrK34oR23D89z3EtMxN28e8r6sjCSA0FICbknpPiWpHo91Ten1k2kTLW/13v93vJa6honyktiKOtV+hoY2Rh1oamlifkEndLm1FRi2Z6JGOb+wO+3IaKu+hR6U8CfTlwSckdW7T6TDlcYPunOXg4OkwzHwK5xg9v7m9Nt8onMbk81k9TrSSShx7v//+n4zvc2qxvT/kgvqYTN3zqm1rf/OHd9qZ3GgfyVtBRHKVvr/fZ91NRbT9kj3zYYT36x8SUfD5wBx7sCLIRMGnAxoKVgVz7MEnAxoKAADlQEMBAKAcaCgAAJQDDQUAgHKgoQAAUA40FAAAyllMQ/MX9kX9Lrua+wkVxBerrd6JmKPz/HR3//Nu//KXKPb68v3+5939z7tvT7+nrTlGc/1C1b7moekJ9XUd9mj7qGbF95H3j3y/hr+qud2ErAUgZ8NvJX5Uu13VKrYB3BElDJWw42nxAPXQovsN4w/LvUSUsaRSz6pVLLr8Br28WZ/4eQDrs2QeemXfzGCt4ZK+nDPrOPlc8deX79+efrs/P6SG/vnx7dewAPb56a75YwWY4fno9r4+xL5A+Lr2Mjrjo5oZn36xmfNXjWw3ubRV1Yp1p/zt0O5+6ao/df7fWFdzh5a0/0/hWtiurqqKBKICyh1g+nfCZ0v135ri0G/yfenljfpEzgO4Cev15SO+marfJftgt6u78vXaPo0S5lL3D645BqnTuDxUrm0l6DlwoKHPT99Pf49v/j7u35GKnrwdgde4wAtGGAWoHoAZ8VfRUJ/TSdW01+nLfz/BmUz8/6RqaNvWVCBJFecikGLjdl7zS1vV3VCIvrbKW/XJPEywNKuOh8b9ioJrmv5rD/ry+YSuS6+PbHl+sp+IcfXOaugvalSV8aiOXpgGeRo1TjGR4i6FeRoaxHeraOh4RTD5yNLQUAoTDaZ0Db2M3/aalebqQv+thkMBw9a666P1h0A1VB2I0OtjnAdwKzasoQnGQlmoGkr9Q1M11BqKzdPQDAMOpm6LaaiI71bQUO5N5c/GbTV0uNLSNFQdkozkoTQbSMpDw/oY5wHcCmjo+GYRDSVjoKIvX6ChfYUfl+nLh/GFIPLdqd6Ake0qtvEUaflZ7bhuX360JKxb0pc3LrwpAh0xVWXdkau/6/qSgYZK9PpkHiZYmrU1VPXNlJ8OsIuEPhujjFwN9Y/5DO4yp/bl3d/HZtwi7ikV9OV7Gn5TPrynRL+Vq6EivvCEtZ43VaqhMu1ifVt6D0daQcuzf8V7SurYEW+qaW80gqgzf0bWNAZqHa9S3q6PdR58QYjrmqw7P1T3zdT9Lp0Tj8aoi4dEG833099oos95nmT0HJumI37X/cQm//eN9NlPv+6UuU0uI62mc4z6ionnj8Yf+zw7zSg7vuGvam5XYbN1HJ/R5Oh72uIRO9NrzW1iNdCfzbfzCif2OOQFytyjuhPHO72t/6uWj9Zn7jzgNv2qYI59Ee/uR6EjBpaAPUYQrAI0tJB3Tcp799guAAp4YtUtgIYCAEA50FDwGdFGJcPRQwDeDzQUAADKgYYCAEA50FAAACgHGgoAAOVsyD/0Y7CZ4xp8p9JWIqWjzNn682NYJvDzB5+u/7t5hy+q8Mei5i/S/3Sc3n86BB8dnSNrKNTVAYn+px/HdxVsiw/kH7oZNnNcswvSswmm/r++fA+kc+D06655kSYAeWsHzmT96Nnw0OLr9JmPwZvbH1kx4XiS5ZnywXxXwWbYhH+oo2vpqmrKZbgxjihMfM7rzseva2UWC3NMnxbs76pqWF08FOBGu8F+s2BrKM88USKph1ikT/MXmpXQNZf+tz1YhERTm8T4/sQyBQy8pqaje7rbv/wVGqnkpaJntgbfq5h/0RzkN3oNNa0PAueqXC1zH8R3FWyHTfg2CT9wsgCZWdwyORtluH/tPSC8DjIfh9Epx1GZ8KVHEwlfvdh+c2A/dZ5zefE6Hfgv9syktv9Ieos8TBpKX9N9ZcUfCZLIPz/2Tz/2Q0d+8vEbfPudYkaV5aUiNNS/DR954vHdeaGhPj+NCNYiGnoj31WwHTahocJcREkGtdQy/KWa8VWTBmIQuaPGOvH9ZtKMuR7rGPKhQKFx4UOfwnSsx/Sdyow/EAz19g+DGsyoSE4qPFaEW1XGgLGtoXl5KIlDFXAdDb2B7yrYEhvRUMLkTxN9+EeGhrLM6MIdx4bPmTlZ+UNHQnwfk4pF82AbxF1DQ3PjD2gayj2oiKV0j5KHlmto2JcPUX1d/UAHvdHkivxP3UfwXQWbYhP+oexeMPc2N7uF6RpKR+iC3j7d42SSm9Ednac5BEnogbxOyBPFE0mb8Su6hubHH1FuCJ1+edvT3004NnrVvnyT8FwWVUPF/xhfpsD/1G3NdxV+oJtnC/6hjnee2fWifaTbn/vY1HxRPlp2V9V1taOujXXnPRfpXa9IlXIRvyJHx/vGh+L1vxnhc0p/yXRajxdQy/+0IL4/28Gh/m7GPjv3kJ569Kwvn35PyXj2nzrHyI+HyFlHb9MttX5Lw99m+J9u0ncVfqDbB3PsAQG+qBsDfqDbBxoKGPBF3RCbWdABIkBDAQCgHGgoAACUAw0FAIByoKEAAFAONBQAAMqBhgIAQDm38g8d5g4vtfftsJnpKfAbvYffKFiAG/qHXnNZ+ix0FejawG/UOQe/UfiNflJutdZzV3dEQzW/zt7gs18SStZtOuc0P9DpK9JXNPRhomtD4TdaFt+fcPiNwm/0i7OmhlI3CtaXt/w6yfp13ilW/UBJYOEr6ow8FH6jZfFH4Dc6fAS/0a/MihoqnJZ8AmL7dQp9ZLZ1liOIYalnaSj8RgviD8BvNIgQB36jn5INaKg9MCruV0z+nqofqLqXKVS6hsJvdCb+APxGx4/gN/qVWbkvTyVr6stb3bneZJS8HaVL9QMdYxmhiEKSzBJ+o/Abhd8oeA/r3lNij/yo+ZCo2pcf7D7F7SPFD7QT0ZU+ftg1n97DbxR+o/AbBUVseo79u3zYwArAb3RjwG90fbaroSQX/AJT8T8s8BvdEJtZ0PGl2K6GAgDA9oGGAgBAOdBQAAAoBxoKAADlQEMBAKAcaCgAAJRzK//QrRH4mRbWf0VfVPhp9sBPE9yUG/qHLsI7fEKDZe+F9U9aPn8dP1P4ac5tB2Bp1u7Ld8QO1E/P1n0/ne3LqfqHGj6hsTiWn2kuVpxr1dMCfpoJ9QFgUVbVUGL30ctFYKvMfT9NX07bP1TN74w4pp9p/mEZca5TTxv4aSbUB4BFWde3KSIKod9SxJfT9g9VtMmKY3rxFRyWEecq9YwAP82E+gCwKBvWULN8zD9Uy++MOItr6JXqGQF+mvDTBLdm7b686L3rNvJ6+ZGof6jqE2pYVJp+ppkYca5WTxv4acJPE9yate8p0f6qfzpSxPdT9eU0/ENFMPa70f09bT/TPIw4V6unCvw04acJNgDm2IPPDPw0wdJAQ8Hn5YMt9AAfEmgoAACUAw0FAIByoKEAAFAONBQAAMqBhgIAQDnQUAAAKGcRDRU+lX4StWpq6Yy1ho0woDxP31L9Lq34/cRvH6qvG1tmzmGGHX4K+sH05cyNL5DPFs6fjhNd3ZTmi4pnFANQylJ5aPPA1hf6ZdF+DeLzUbFfY1ve3J6v3d4L78vA79KMf2avZwVOLCKk6w51X87M+BNsmSjZeM2J4Um+qGpFAACzrKGhXpKkBnGtUTT0OK7dpq9pTO53GYl/Ogx1aBKszn2FTwfd1EP1Q0qP70nJOfsFo32x0SDwQj9SFjMW+KIiFQWgiJvloV50PKqG9irZ21io3hlUzuLxmwe3Dzaq9BraBCabEV/OrPgjqckf83wKzFkucjigzBc12/AEAOAW1VA5Hso9KUJzNl1DiaPPpKGG32U8fnovu4/Tq7aa54Z5aFb8geShzzwNLfX0w7pIAApYIw/1TCp5Vnx9LA1158l2qH9h+V3G42dpqNdlMYBg+XJmxR+AhgLw8bmRhga+kC6ioSNq/91xv8tI/DINpd+K+HJmxR/J6MsPsiifoMI/1cIm+6KiLw9ACcvObQonJ9HBxNNheK3klcLXkrz9h+V3+duML6w240OW4aBnY81teiDPpEyOT8lIREcf0rb1jpjSd/Vdvqi4pwRAEZhjf1M2M6VoMxUB4IMBDb0xsiN+E5CEAlAKNBQAAMqBhgIAQDnQUAAAKAcaCgAA5UBDAQCgHGgoAACUk6ahOXNfLJ/NfiJ9v84nnMc+Tcsnjnbqmk4rjrXfCNaa0evAJ977CfminmwZgg6ZMU9awW+t2gudg088m8jXLkGshAaVk/jrznHvKLrfMP6wRFVEGUsq9azawJqKbNDLm/WJnweV06+7+5/T3/7lr1jptPZVL/LQKjdiqrt/5L+Xs7JTfb/zl1asveRr4zq02reHGIjVvX+Y1Y4F7VUGW4DSBRvzp0mn5qFZc7Atn03mASq20zWaD6YraDyO6e+ZXtvrQld/ntnPjK0lTannpa2qViyF5287f432W32T+SmoXT1dIpe2SlsDGq4ldV1dVRUJRAWUxh/f0Qh0SSmL7OPQb/J96eWN+kTOg8Xp149Jkl6+z2ioi7WvdR2ehAfukRUTfrjibXMwP6I79S483i/NItJebLEw/eVr12FK+9I1x2o7FrRXBHoEDC0dpMYVBYtNkvvymamo6m/0fHQnv4zdX1tzYqdqqBLH2K/2/439gxPxB9Omo55fhNt76PLWaftZtx+11uNH8DmCVM1AQ8l7fjUELZh4uaga2rY1FUhSxbkIpNi4ndf80lZ1NxSir63yVn2Mw5y9HnqonprY7RvxmX3WLmnVDzdLQ+lHSauNo+1laah6Hc61rxJfbUdth2Z7mb66wReUZJOnzPR4NfeJmYw4fTw0w5PC8tnsG35ofq9955k0UNfQMM6cv2d6/D4X1n1MtO3MIo/mlUIfx7e026X4S2mMrcwuuywNVS7owAJKRdfQy/htr1l2NBqBWgSEQwHD1rrro/WHQDVUKW/VxzgPSfx93D/9ni82177hdej/14pLTvXTWVZDo+1l/YNRr0OrfR3ty/PyajuO9Uptr4ifWVYeag5TTB9dR0MzvNFieahXPU1DGz5OJKLNxLlSHuqCPJFqqLI98Jearm/7N8by0NlxK3JZ0Svstho6XI5pGqqe+UgeSt2jk/LQsD72eZjNQ19fvjd/Zk9MrH3z8lDDD/eGGqprk3EdWu0rYgZ9+XflobF65mpoV5NjqXMHEJbVUIFv+NdH1zySvrylQUY0PU7pyOZqGqr35YO3Ieq9HScum9n867p9+bHbVLekL2+M9kwR6Aic1dfzv4yu60sGGirR65N5mJSkjryb78srkQ9Kt8O6t8l+CHzIi34krp+MvrzdXqo2Wdeh1b6cqR2sdpTlEo7gKhrKvpqWWFCW6surPpu04Rt+vzIylB7RUBFnxt8zrbYuV0OD+jdGX75R7yk518zkofLfNevb0nsC/LIJr8Ur3lNSnzXCL5FpbzSCqLNy3QfjdJaG+u1WfazzMENiR97F2te6DtVrMuKHS71r6b6uoKHR9tK0KXYdau3Lw9vjpKK9szTU8tWd9iBk3binZHqcj135SDWuf0/J8tmkczWc4+OGYpoI+T9szW0K48T8PQ3U+D5OP8Yfzi8R28P6D1cw3+i3h/WM5c5sto7jM5ocfa+PN9FswZnlLSJzm1gNSCi65+mnxPc4XO9KH63uxPFOb+v/quWj9YmchwipHfnk9vXXoeKrK3xyqR8un95HB9lFfHXXyePs8gT5k0ZPbvWvf5rX4X/09lUmPem3fKamyW4verVMvrrO0QqSOObNJn2+k/9gpiaLzG0CAICPT1Ln+/pz7AEA4OuAtZ4AAFAONPRro84cyRk9BOCLAw0FAIByoKEAAFAONBQAAMqBhgIAQDnQUAAAKAcaCgAA5UBDAQCgHGgoAACUAw0FAIByoKEAAFAONBQAAMqBhgIAQDn/BwzbSmfTAhT2AAAAAElFTkSuQmCC" alt="" />

增加
有两种方法:
1.直接使用Exec函数添加
  result, err := db.Exec("INSERT INTO userinfo (username, departname, created) VALUES (?, ?, ?)","lily","销售","2016-06-21")
2.首先使用Prepare获得stmt,然后调用Exec添加
  stmt, err := db.Prepare("INSERT userinfo SET username=?,departname=?,created=?")
  res, err := stmt.Exec("zhja", "研发", "2016-06-17")
另一个经常用到的功能,获得刚刚添加数据的自增ID
  id, err := res.LastInsertId()
相关代码截图:
 aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA+IAAAEvCAIAAABOkexfAAAgAElEQVR4nO3dP27rytkHYFbpUqS4VYAvqd2qCbIFV+lVpQigPaRg4+ZWdwuGFpAFnFobyB60hFvnK3REDznzDv+ItGn7eXBwYFPUcDikpZ9ejajmf//73//+978GAADYDzEdAAB2R0wHAIDdEdMBAGB3xHQAANgdMR0AAHZHTAcAgN0R0wEAYHfEdAAA2B0xHQAAdkdMBwCA3Vk9pv/hH//9y7/+uWKDAADw7aimAwDA7kyM6X/4x3//8u9f/zB5+Xv7+3/+8tt//vjRvQAAgHVMi+n//OW333/5+/Tl705MBwDgK5kU0//+n3LJfLD87//5v99+/7/ffu/NTf/rr3/+7T9/7G5Kw/R94f9lWf+P//q90FTT/PFfv//5H7/+kt7rr7/++f5r8S4AAPD5TIjpf/vTv4sl8/Ly4UdI//rrn5Po/Md/dT//85ff/vunvzb35W/xPVnnb3/69+9//sffmvSm5F5vVNMBAPhKxmP6xFL6XSmmJ8H67V7//OW3XgS/68X3wVb++K/iXcR0AAC+lrGYPq+U3pRjem+iy1vsTuarvIXvfBKLmA4AwHczEtOj+BvH4hkxvdzaP3+JA7eYDgDAt1CP6VEsDuPy9Jj+119/6Vroh+xkbnrT/PXXPyethdsdTK0BAIBPrRbTBwl7ZPnf/vTv/mSV2zpxNf0P//jvfc1hwn670ku/9F55eRBdHAYAAD6fSkxfUEoHAABWEMb0eaV0AABgPdO+hRQAAHhHYjoAAOyOmA4AALsjpm/reL5e2kPTNIf2cj0fP7o7m+r2lememubHzLu8Ns2PpvnRNE+b9IhNOF5fwxbH0SMnEBLTt/V9Yrqnmnfx3DSvH90HFhDTv4ZNjuOXf3YAFlsY04/n66yHlbnrfxmLY/rxfE3tfvCKKf3UNC9Zwfh0Lwbf/nWh80c/gKZPhy/J+s/JCum/l2D5zXO2/MfnzLunZE8Xmz6eX2bcVvFcGreJ3jmmL+jhdh4Zt40s7smU4xjtb/Hx8EaVAygT07f1UEzv1j+erzt/EC8/y1Selk5Z2stT4+3p8KUfTF/uy6Mn2nT5S7aVz16Nfjymzx3Pm88+bqvoxu15/lSl7xzTHxm3jWwa06P9rTweqqcDZbWYnhR03x5ADu3lei0Ueg/t5Xq5XK7X6/Xc3ta5tId4/UXeetRv5Hi+Xto2vzFaHju0l8cTcdfNS9v2YnrbDcZoV/ovbAYP4pX9HS6qbTc5Nv1dntF+sX93c2P6S7+4fns6fJ0Qx6Pl+aanx83BdtOn57yE3zU+qOKnG33J7lVc+TWoxg3ehYjebZi7X+kOrhLTtx63aHya/hB1G329z+Z/uf9wGtvuqIlxs+v5qd+l4nZf+/1PFfericen+IbSJxq35zn7W+lPtF/F8am0Ex3HuftbeTyU04GyOKb36qPHc5aLB48ph/ZyvbSHW/Q7H7P7P15NT9q4byy9qRSuo+WxYUzPX2WMZuxBP5OYHva/3kpTiun5fpXHJ97u8Rwenxntd7eV9mduTL89DXfF3a6aXkyQU2J6Xnt+PG6+9PPKc/Jzt5uDvXvup5xUPjivyZI81hT3KNpu0dzx7Layk3GLxuc5y5Hd+qf7OD8nO1Lc7lOW4aIXFaO12EH73ThE+/saLI/2q6meV3kPP9e4dVH4lN10Kq0/6E9lv27ynlTayY/jsv0V04HZqjE9jpLlmH4+Nm+Jbe2Y3k+Ctd+i+7yPoGeDZDvas+qkl9K9H9vu+HhW15g/0FFM72Loj6BaHM2lPpWW5wlmlbhZbOGlv7kf/epptNFiTI/aaUoxvbLdyKzxHN2Fga3HrT4++fKuP7clXZsLxq2Zc2WeqP1o+dz9aqoHpRjTP+O4pYr7O7E/g+X5+Mw9XnWzr+AkpgNFtUkv4ZyIj4jpeVl7nzG9ND2lMDd9UkwPC/iFe0fjU9nuYBP18ayO/4LnmCimN/cnwuLTYVrZGq2mP5XWWWXyRve++Wt//UHSXRzTo+02pZheX79uynh2a+5k3KZMqknbieJmZbsVj49DtN25+1XvTDGmf8ZxG22k0p9KP4vjM/e4VEzf35/EdKBo0kdI85D9MdX0sIXtYvr8SS9bVNPr2+iWldYPt9vfwKRqemW/Z490Jaaf7uXeelVsNKYXt7JK3Cxu62VmvLh5PKYvq/bl679DTE8XLh63SrX+pbS8UhXOtztlMsNElepscX+jane0X81KMX3n45aKqunF8ayMWxNU06N28uOy4v7eSOlAWRjTD+25ErLzydX1mB5Pxp5+EZNeLw7tZUJten5MX+EjpIvmpmfbnR3Tg/EJt5u2Mdz6jPard6moxPTuKbCLC51Z1fTir9PjZvo0f+rHmmLjg/mvg25vF9Mrc7uL5o5nt+ZOxm3K3PdT//wpxs3KdiuiK+08Z0dqytz0dLvR3PRov5rqQXnNwu7nGrdobnq+uag/lXFrSuMTtRMdx7q5V2RyQUagrFJNr8x5afKLftRjevUiLdMfn94aKVyZZC8xPRm56Vd6WSGmN8XxibfbO77taDU9aD9tbtq4Va6bnlZYozevo3e0i+002ZToWW9Gd42nT89P/eWp5+Ad9uJG8yu33Lo9N6YPmpq1X1PGs7ILo+1vMW7R+DwF243iZmW7FdPjZpMcl8qVXtIZQcXjGO1XUz0oz1lTn2jcZp0P0fqVcWtK41PZbnQcF+xvmVo6EPnobyH9thdUfy/v+ASgIMS39fLYnIemOif7C3t83L4Aj5xA6INj+uQSLAup08D2Xmd+JKDYwjeM6Y+PG8BX9tHVdDYmpsNn8D1jOgA1YjoAAOyOmA4AALszO6avNYkivkTj6rb7gI6P/gAAsImvH9M3jdJmfgMAsIXdxfTBN9iv8eWlm74aUFAHAGB9u4zpK9anN0/R6ukAAKyvHtOjb7U8Bt8pWvuq0UI7P3/pfZ/9+LdvtvlGouVRiK70c1778SYAAGC5Skw/nnupuj3+/CHJ1L1QnfzcK5XH7Vzaw629JOaOxfTS99SHy4vF9KifS9pvxHQAADYQx/Rgusgg2b6t1V8/Wt5v53y+xIX3Qfm90lY8taVwQ9TPRe03YjoAABsIY3qUPgfLuwB7q7LnAbvWzvV6uQxz+viklzkxOt961M9l7Rc3AQAAD1pUTS/F9OZ4LqfVsap8b07M2jG9cEvUz2XtS+kAAGxg0dz0YkzvB+xDe0nnrMdz04crrBzTyzm92M+12gcAgEctvNJLusagFF6YUj5ypZcm/Rxpdt30wUc8l0xKKX6KNOjno5NqAADgcbOvm/4JbVfwVkoHAGAT3yGmAwDAJyOmAwDA7ojpAACwO2I6AADsjpgOAAC7I6YDAMDuiOkAALA7YjoAAOyOmA4AALsjpgMAwO6I6QAAsDtiOgAA7I6YDgAAuyOmAwDA7ojpAACwO2I6AADsjpgOAAC7I6YDAMDuiOkAALA7YjoAAOyOmE7keL5e2sPiu782zfNjK+zHU9OcsiU3z03z4/7zj2Q57+/BMxYA9kVMp+zhyPNZUvhr0/zo/3vJlrw2zakfwV+b5qVpmqY59RN8t5wPcGgv1/Pxo3sBAOsQ0zdxPF9nxYXp6x/P176NUkkxpZ+a5qVpnpL6ccWKMX3Wdpe185L09hbHX5ObBjXyp/6tg93MY/rW/U9fYAzW715mpJ3v1s/3q7tpYn/y9ue2E/Unf/nU3VoZTwV1AL4OMX0T28b0d6gXltPOF47pr/GSPKanu/Zamujy0t/Epv1/7f/cJfV0Ns5L6cXDIBbfmn1O7lIXtT+3nag/g22lu1kZT/V0AL6Oekw/nq+Xtj1nhdtjvqi39NEnynL71f4Ul8cO7eX6aNmtuL+H9lIsdx/ay/VyuVyv1+u5va1zaQ/x+rWNltc4npM9OrSX0eOVLh8MRRB2ivFoMEWkmwHyek9yP/q5rUkKpYMcfwoKq1vH9Kd+yuw62e1gFMRvheS87vvcb+odXmbcPPe73R2L4l0Gg1yM8hVR+3PbifqTeu3PLKqNg5wOwJcxGtPzMJsExUN76W7u1V+P5+XPlEH7YX8qy2PDmJ6n5bHAXN3fPEzfd6XLz4P7r1JNv7fZWykaz0Gsb4+FhgbqMfGpn7Rek9WeS3cZlNufkyg2WH/rmJu+POhi7iCmF6NntHziducabeeU9GcwvHkIzieZpC+rRj8LG7U/t51KD2+Kx0tMB+Drm1BNP9SWvf3WS30PiNqP+lNbvqXq/pZj+vnY9KL00pieGnThfvNbY5XjFY/ZogHNS+an/q2VqSPF1t7tqikv91D+3I/saXZ/7u/OzalUSv+o670MXtvc+txNv8nfuyjOBS82VRS1P7edqD+deeV5MR2AL2N2TM/Lzv2JFsXwOEOl/X3F9Or+bhvTa2v2Z7vE41lPM/OzzmuWYkeruXlM/5Cwe7p3puln8bSaHnlNWuhW/pDr2zwH1fHOxGp68dbiR0Xr1fTp7VR6WF9eJqYD8GUsqqaPPQs+9DHHWvvbxfT5k176my9M+v6ImH5oL7ep772mi+vXx2zeiBbrnXNj+qCRd4vpXQ24SWJ6Opsliulppn+5L/mQqzHmGb1ZNDe9frwGKnPTZ7VTX/MUZPqIlA7A1zE/pveD4qG93D8iea6GzulzYsrtx/2pLI89/BHS+v4OJ9WPxfR8/aiftZj+dlu6VjSetbnpc4b0FExsWBDTu9h3mhzv1pprNYjppwnXKknj43Myc2aWx/tfzOhNf8LJlCu9pB8/nTJZJWp/bjtRf27yd2nqXJARgK9jQUxvgiuE1Oe8zIoj0RVIdhTTp+xvWpOvx/TwYizFmF6cE3Q8XwdT0vtJPRjPcA8O7WXa+AwmZw+u9NIZjelP/UbeOaYP+j+Y3ZE7lTq/oJT+eP8H4z+4cGFxkkk0uSi60k4kan9uO1F/ZqX8plFLB+Brea/rpr/T5b5Z0daFyTUurL7OefWUzS9P5VdGH3yc9JQU42eGdX8Xa1JKB+BLeaeYPrk0y/exwuzztc+rl9IVUV6zOdwv/WsODmZldJdUH8/r/i4AgIhvIeWdnaanWACAb0tMBwCA3RHTAQBgd2bH9LWupRBegnB9232wzEfWAADYxNeP6ZtGaReAAwBgC7uL6dl1wR/c2NYFbwV1AADWt8uYvmJ9evMUrZ4OAMD6Rr+FdPgtlbdYGnxnZrA4aufnL7ev8/x5j2pMP56vl7bNNxItj0J0pZ/z2o83AQAAy1Vieu9rzA9te/z5Q5Kpe6E6+blXKo/bubSHW3tJzB2L6cWvVo+WF4vpUT+XtN+I6QAAbCCO6cF0kUGyfVurv360vN/O+XyJC++D8nulrXhqS+GGqJ+L2m/EdAAANhDG9Ch9DpZ3AfZWZc8Ddq2d6/VyGeb08Ukvc2J0vvWon8vaL24CAAAetKiaXorpzfFcTqtjVfnenJi1Y3rhlqify9qX0gEA2MCiuenFmN4P2If2ks5Zj+emD1dYOaaXc3qxn2u1DwAAj1p4pZd0jUEpvDClfORKL036OdLsuumDj3gumZRS/BRp0M9HJ9UAAMDjZl83/RParuCtlA4AwCa+Q0wHAIBPRkwHAIDdEdMBAGB3xHQAANgdMR0AAHZHTAcAgN0R0wEAYHfEdAAA2B0xHQAAdkdMBwCA3RHTAQBgd8R0AADYHTEdAAB2R0wHAIDdEdMBAGB3xHQAANgdMR0AAHZHTAcAgN0R0wEAYHfEdAAA2J3RmH5oL9fzMbz5eL5e2sP6/eJ7K51X+TJnHwDwZT1aTReU2MLESD7yIhIA4NMS0z/YukHzeL4OWzu0l2vqXQ/X4v5k51V0ojkBAYCvSUz/YJvH9LfNfMCBWtyf4XkVnmfq6QDA11SL6cfzz4LnMAZ1N1za9qGY3jU02MTxfGt6eGO0PHZoLysUkCv9KXTlbemEHtZiZlJ4Tneh2P6wSD3YdhaLb9st7kDc/xnHa25/es1n51VllOR0AOBLWvAR0qRC+lAIHrSTBdFCu9HyevfTe+TpcUqYLm436H+v7ns8j7Udp8zjOW2n21a1/enV69tA3Ned0v6C4zWrml47rypv2ojpAMCXND+m9xPT8kkvtXb2NhF5/Lojb78dz7NeSUxMmRPbnxfTZ/V/yfGaE9OrLYrpAMB3MzumD35fHJzzsvbniumV/gdzVcoqKTOZfDK1/XkxPTiOxfYXHa91+pPfOmxJTAcAvpwPraaH6Wq7mL540kupmj52vzCkDjpUXKd/5+Ke5+2vFYsLrS05XqtV032EFAD4blafmz59zkcvwh3ay4Qa/fyYvuJHSKshtuv/oT2XZpSH/anF9H59+/Zbvf3wAiqTY3rc/oLjNaM/E86rXb3BAgCwrTimVy7V0d1UuNLLrKnZb9M6tspkG8b0Juh/dc5LMaaXh7nXTjLO9Tk12cVYguuUx9X0kTk1c47XjP70bipdQejQXny9EQDwfTx63fShKfM8YImJ30wKAPAVrBzTiyVPAABglrWr6QAAwMPEdAAA2B0xHQAAdmd2TF/r2hrhpfrWt90HDX2EEQCATXz9mL5plHZBQAAAtrC7mP52ne3h1dqX2brgraAOAMD6dhnTV6xPb56i1dMBAFhfPaYXvnXyFkuz75Ycrt9PrkE7yRdidveoxvTj+fYFlcONRMujEF3p57z2400AAMBylZh+PPdSdZt+1/s9l6ahOvm5VyqP27m0h1t7/W+tr8b0/BvsK8uLxfSon0vab8R0AAA2EMf0YLrIINm+rdVfP1reb+d8vsSF90H5vdJWPLWlcEPUz0XtN2I6AAAbCGN6lD4Hy7sAe6uy5wG71s71erkMc/r4pJc5MTrfetTPZe0XNwEAAA9aVE0vxfTmeC6n1bGqfG9OzNoxvXBL1M9l7UvpAABsYNHc9GJM7wfsQ3tJ56zHc9OHK6wc08s5vdjPtdoHAIBHLbzSS7rGoBRemFI+cqWXJv0caXbd9MFHPJdMSil+ijTo56OTagAA4HGzr5v+CW1X8FZKBwBgE98hpgMAwCcjpgMAwO6I6QAAsDtiOgAA7I6YDgAAuyOmAwDA7ojpAACwO2I6AADsjpgOAAC7I6YDAMDuiOkAALA7YjoAAOyOmA4AALsjpgMAwO6I6QAAsDtiOgAA7I6YDgAAuyOmAwDA7ojpAACwO2I6AADsznhMP7SX6/V6vV4v7eG9elVxaC/X8/Ghu/80u5XjuTAGI/3p36fYAgAADI3G9K+ZLBeE/WUDMbjXgy8yAAD4JsZi+sxceTxPrVIfz9fURtk16s/8uLzw5Up2t6/5sgcAgHV9aEzv1jyeN5pTs1pMX5qus/uppwMAMC6O6cks7nRu+qG9XC+Xy/V6vZ7b2yqX9lBYfSSM9gP0ILwez9dL254HLXUF+LTl2z2Pw3VH+pOH5aidaP2oP70bLm2bxXs5HQCAUbOr6Yf2cr20h1sMPh8H9eKF1fRCTI/K68MO3eL4fclw+9Or6aPtBMX0vKXkvof2ku2HmA4AwKhFMf18bN6S6xoxfTjppTLFpBTT42upzIvp1XamxvSxa7uI6QAAjPrQmB7OkJkZ04fTZZbG9LidOFvP60+1KQAA+Gkf1fTCjfuK6XGP5lbTpXQAAMatHNMHU0f6d5sUoO83rhPTw/5kmx+rgkddmjs33QUZAQAYt3JMTyezZHd7LKYHl26ZEK/L12O53/Bz9SmTVXpLKpeSSb64tZ06eQYAAN6MfgspnccL4UrpAABMIqYDAMDuiOkAALA7YjoAAOyOmA4AALsjpgMAwO6I6QAAsDtiOgAA7I6YDgAAuyOmAwDA7ojpAACwO2I6AADsjpgOAAC7I6YDAMDuiOkAALA7YjoAAOyOmA4AALsjpgMAwO6I6QAAsDtiOgAA7I6YDgAAu/NRMf3QXq4/nY/vv/ndOp6vl/bQ3AZopyPT9ZH9e2qaHzPv8to0P5rmR9M8Pbbp56Z5fayFr+Tx8eQ9pcfra5/Jn3fvtuv50/0x8EfTPMcrTF9/a89Nc8oWnqrj85yc5C+lu7OR2Qnqg6vpOw6jH2P/MV1I/9JWfOYTTFNG43MZHK/XD4pf7+BTn5lbH5e57X/UefLSNC/Jz7c+nO7h+1Qq1rz2j3u6wlc91fdibrrbaUw/nr9plX1xTD+er30bDV8xpZ+a5iUrMJySAsOPJPz96AfB9EnipVST+NH/9xIsv3nOlv8Yy52z+llv/5T159M5JSP8iM9botvIO4ehj6rq7c3icRgcr+nn82u/MPlcelSc8gIg7Xn60Bo9HjbB42ddcb+e57cTNb51O8X+F5+PKirrbxrT1+1nk4zG6z2j307F/CG9+EQ2+NedpWv1s3jSNsnzZnoon0o9yW+a2J9iEpjbTrH/lX5Wxm1etVNM35eHYvo7jFj57Kqcjvn7bnkK7953GzzlPN1XGH0ae8m2MjcmTu9n1H76fFx/t3HP1orp3kUdENM/xFoxfVZGSf/2Bw9rtxllp/6SuTG9uH70+FlX/Dvt2nmevNdR41u3Ez3pfKuY/nxPordbb+Wk53tMLz6eD7LmqX+yDXZhlX6+9n8uHtOXUm+Lf4npU39d1P7cdqL+R/1squM2L9/VY/rxfL207Tkr0B7zRb2lyeJBdwYxL+9sMmn98bJwuZ/V/Soujx3ay/XhSSBdNy9t24vpbTcYo12JY/rxnPTw0F5Gj2O6fLBrwck1N6a/9IvWt5N7ytNVtLz4yPV4TC/2M2p/8IQ3GssG+5uuH1Ud0hLIYPlrUkvL33DIt5tXpwbvKqT9eQmamr5377C/0X4Ndq3b6Os9M71k4Sna7lxdDwc11GL7r/G7McX+V8ZhcBy79vc2Ps9z9quy3aj/xXGotBMdr67BKQnsKTu3Bw9Tz9lT/ioxfdl0i/q9HozX79NOvgtbx/TKyZ+vP4ieaW5eq5/pH8jzhLeUX/s14HzNvNq91nh2/ez6kz5vFu8y+EssRvmKqP257aSK6SJ/xKiNw6ycPhrT8xCaBMJDe+lu7gXw4/neg7kxPdvGYkE/w/2qLI8NY3r+KmM0Yw/6mcT0sP/1Voo3XtrDYKVofAaxvj0WGhqYG9Ofk4lx3cn9EjwDRU9Lg4iZJ7zHY3qxn1H7gwfo0WfNKLa+9PPQc/JzN7yD3j73U1QqPyivyZL8aa84ktF2K0ZTzur7G+3Xc5Yvu/VPSXLqDuha74oM2un2N2r/NVge9b+pHvf8r2af45O+sT646VRaP99uZXya0jhU2iker870HNytmc8DfLn36ilbeWBuTI8eP+vy3ew8L2rw/dt5/5jexI3n6w/WzJ+2Huxnmstf7nXxU3bHtGx8q7hH1fT8DZbVY3r6LFMp3xSXDMoNo28ZRe3PbSfqf6Xn7xfTs1TWX/b2Wy/dhb15v5ge9bPQi6h37yLo2SCZj/ZsODd9sPb95rdBrRzHeEvzByiKv8VnrClz00+l5XlSWSumF/tZbH/wFPJITC/2vFKtr+xsMaZXqv75A9Dcdwmi1bbe3/p+5cu7/vy4v8/7OrbdWaJ2ouVz+99Uj3sxpu95fFLF/Zq43cHyfBzmHpfO9Jje/REN/pq6FtJtPTg3Pe3zgrnp0TBOz2R179DOsrcRJno8pqcL13pXIXW6/5++WK3E9Kf7/z+Cf89bjmeTDcJtcF7uC/NTN4/pxXJDJGp/bjtR/6N+jtg2pufl4v6EimFI/KiYXunnrmJ6ND71ccuNjVh/tks8PvWzZ/71Z6L429xP6+LJnf4lRE853fKn0jprxfSon9tV05vk/frBO5WDx9PFMb1Svchj+mi1o2jWpJdV9nfKpJq0nSiGVrY7S6WKU+/PxP5H49DdZfr472F8UtHxjbZb6U9xHOaO/2iHB7o/uvQu6WPI4F2UYrP5faM9yk2PHdHW5z5+VnqydTv7j+nd4d7uEzun+3tfgyJx9LKtuM4qf9d1z1nLy6rpxVu7yW+vE9af207U/0rPa7avpo+1nkbGj6ymj04Cmbp8uvmTXlaspo/E67bXZDQ+9S3NHqFK/D3dX+PWT/rRmF7cyooxvdjPvP0V56bnfbi1PyvW3Dwe05dVT/MnpK33t1Ktfyktr1SLV3nWr1Rto1gWrV/sf7NSTN/J+KSianpxu5XxaUrjUGmncp7PrQr/yF7b58HoZouYnvc/sl1wfB9rVesjq8T0pnQ+rCV9C+W1aZ76lfWbU9aryin0lP2wlmLGXTA3fVbZqDI3fW75qZLRJ7bQWf0jpMNQ1guEh/Zy+/nQntMEWJwCXfjAZZAu48nYwdyaYM28n/F+VZbHVvgI6aK56dl2azH97bZ0rWh8anPT5w9RJf5277t1saAzq5pe/HXFmD7oZ9R+2ucpc3bTeJHOhR1kjm6n8vcKK53pPB7T5+5X1KWt97cSQ7uH6VP/fCvG0Mp2m7FH6nzNfLtR+6/BOEf9b8ZKjBNfJn3s+KQVrPSmqI6Vb7cyPk1pHKJ2ouNV6VLFbSrXa3/J4GXA870Doy8/0vMhejyMHj/rov0qzr5t5hzfd2tn1nGZnh9uog8aRjE9Wv8lqM5G5vZzMOklL43n58xLabXbv+mv3Kb3Mzri6blaHL3KX+KU8zxqf1k7lTN21vm85gUZK3E2n0lSnPMyXLvNWrzfGiwuXYRk8v5FVyzZVUxPRm76lV6KMb04x+d47t2992tlfIrLf2552v6e+n/5xaeZQZU6XT96Rzt6unqZkOTW6mfUftrUFOnDYtf+U3956rk0PlM6kz5Sz43pC/aruW8of/tyu/2N9usp2G4UQyvbbWbGi1Npu1H7r8E4R/2PxiHfxG7HZ9bxjdavjE9xHCrbjY5XE4fp+q4Vc/lNlxjySTjpRvOF0ePh4KbpiSH/O20+T0yfe1zmxt8mG+focTVa/+a5tOaK/TzdS+a3IvFoNb2pvq00K25O7OdrfN5Gk0x+BKf0aeZ5HrU/q51K/6N+hj7Z1xvN9m0vqMaIvJIAAAdtSURBVL4jvoeUKeYWuj6FRy7jVbfpFNt3s934fKAveSZ3Zu3dWsd3lXbmH5cPyw8zJ+fM7uctcd6G9B1jujy2xOwE9cli+uRSLsDqiqXHtVr+AjF9u/FhD9Y6vh9znnxcfpj3smR+P5/60wUH08CKhfzKpJeph0Yeex+fLKYDfEVfI6YDqW6GFSwkpgMAwO6I6QAAsDuzY/r8L7iJ23mnaU3bfeTRhykBANjE14/pm0bptUYDAABSu4vp2fW/H/8y0k1fDSioAwCwvl3G9BXr05unaPV0AADWN/otpMNvo7zF0uA7QmtfHVpo5+cvty/h/HmPakw/nm9f1DncSLQ8CtGVfs5rP94EAAAsV4npva+BPbTt8ecPSabuherk516pPG7n0h5u7SUxdyymF7+aNlpeLKZH/VzSfiOmAwCwgTimB9NFBsn2ba3++tHyfjvn8yUuvA/K75W24qkthRuifi5qvxHTAQDYQBjTo/Q5WN4F2FuVPQ/YtXau18tlmNPHJ73MidH51qN+Lmu/uAkAAHjQomp6KaY3x3M5rY5V5XtzYtaO6YVbon4ua19KBwBgA4vmphdjej9gH9pLOmc9nps+XGHlmF7O6cV+rtU+AAA8auGVXtI1BqXwwpTykSu9NOnnSLPrpg8+4rlkUkrxU6RBPx+dVAMAAI+bfd30T2i7grdSOgAAm/gOMR0AAD4ZMR0AAHZHTAcAgN0R0wEAYHfEdAAA2B0xHQAAdkdMBwCA3RHTAQBgd8R0AADYHTEdAAB2R0wHAIDdEdMBAGB3xHQAANgdMR0AAHZHTAcAgN0R0wEAYHfEdAAA2B0xHQAAdkdMBwCA3RHTAQBgd0Zj+qG9XM/H8Obj+XppD+v367s7tJfrT5XRZ6nSeZsvc3YDAB/m0Wq6ILOpkRdJLDUxkht/AOCjiOm7FsXE43lqlX3doFnYblL3v16v1/c9HRb3JztvoxPZCQ4AfAwxfdc+QUx/28wHnAiL+zM8b8PzWD0dAPgYtZh+PAezo7sbLm2bxJtu8cPzqd9a6jd0PN82ObwxWh47tJcVCr+V/hS6UhyfQQwcxMU8JA6LxWN7W4uZSVvpRsN+VrabxeLbdosDEZ8nM4773P70mu+ft/VRktMBgA+x4COkSQUzDbu9gHk8L082g/azAFkI19Hy2DCm56lvStwvbjfofzA+c2N6to0JO1pe83hO+9O1Vz2O06vXtwG9rzul/QXHfVY1PThv807lLYnpAMC7mx/T+4nm7bfjeZ15yVH7+W/Rfd7P+PVCRsfn42J60OvqcZwX02edJ0uO+5yYXm1RTAcA9mZ2TK/EymAOxTx5WftzxfRK/4vj84ExPZl8Mt7Pke0Gk16K+xWOw+zjvk5/8luHLYnpAMC7W6+a3l9lebI5nuP7bhfTF096KVXTx+6Xjs+HxfR+ExOP41qxuNDakuO+WjXdR0gBgL1ZbW76oT2XZjr37jUtSvfufWgvY2Gvsjy24kdIq+Gz6384PsPMnsXHUkoML2SStVCL6f369pTjWN3upJget7/guM/oT31u+v7eqAEAvrs4plcupdHd1LtiRn3Oy6yp62/TMbbKUhvG9Cbofzg+6dpt1uL91mBx4QonWUwvH8Zef2Ydx147wXXK42r6yJyaOcd9Rn96N5XG+dBe8m2opQMAH+XR66ZP9dA8GHgH+YsBpXQA4MO8U0wvlioBAICi96qmAwAAk4npAACwO2I6AADsjpgOAAC7I6YDAMDuiOkAALA7YjoAAOyOmA4AALsjpgMAwO6I6QAAsDtiOgAA7I6YDgAAuyOmAwDA7ojpAACwO2I6AADsjpgOAAC7I6YDAMDuiOkAALA7YjoAAOzOeEw/tJfr9Xq9Xi/t4b16VXFoL9fz8aG7/zS7leO5MAYj/SneZ+FaAAB8G6Mx/WsmyAVhf9lATLzXgy8+AAD4YsZi+sz8eDxPrVIfz9fURhk16s/8WLzw5crku33Nl0MAACzzoTG9W/N43mhOzWoxfWmKnnw/9XQAAN7EMT2ZxZ3OTT+0l+vlcrler9dze1vl0h4Kq4+Ezn6AHoTU4/l6advzoKWuAJ+2fLvncbjuSH/yUBy1E60f9ad3w6Vtk5ievIFQGBs5HQCAzuxq+qG9XC/t4RaDz8dBvXhhNb0Q06Py+rBDtzh+XzLc/vRq+mg7QVE8bym576G9dPsxGKesV2I6AACdRTH9fGzeYucaMX046aUyVaQU05N1B/ecF9Or7UyN6f1V334bm9gjpgMA0PnQmB7OkJkZ04fTZZbG9LidOEPP6E8yD6ewd2I6AACdfVTTCzfuK6bHPZpcTe+vkvVKSgcA4M3KMX0wdaR/t0kB+n7jOjE97E+2+ZGYHnZp6tz0Q3uuvphxQUYAAN6sHNPTySzZ3R6L6cGlWybE6/LVVe43/Fx9rJ3m0F56SyqXkkm+uDW50kttzotaOgAAqdFvIaWzXcFbKR0AgB4xHQAAdkdMBwCA3RHTAQBgd8R0AADYHTEdAAB2R0wHAIDdEdMBAGB3xHQAANib/wew15KxYacJygAAAABJRU5ErkJggg==" alt="" />

删除
删除和上面的增加语法一样,只是把其中的INSERT语句改为DELETE语句
修改
修改和上面的增加语法一样,只是把其中的INSERT语句改为UPDATE语句

查询
查询单条数据,QueryEow 函数
  var username, departname, created string
  err := db.QueryRow("SELECT username,departname,created FROM userinfo WHERE uid=?", 3).Scan(&username, &departname, &created)
  代码截图:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAABBcAAAAwCAIAAADFOAX7AAAOPUlEQVR4nO2dv47jOBLGGV228QQb3GU7aGAjJzf3ADNBR5105GiwOMDh5DeAEieb9EWTG04X6AfoWMC8iB/h4r5ALbpI1ldiyZItu78fBpg2LRXJoiTWxz9yeH19fX19DYQQQgghhBBSCVUEIYQQQgghxAdVBCGEEEIIIcQHVQQhhBBCCCHEB1UEIYQQQgghxAdVBCGEEEIIIcQHVQQhhBBCCCHEB1UEIYQQQgghxAdVBCGEEEIIIcQHVQQhhBBCCCHEB1UEIYQQQgghxAdVBCGEEEIIIcQHVQQhhBBCCCHEB1XEgljvD22zunQpSC3nb69PIXw5Z36EEEIIIQCqiAVBFXFdsL0IIYQQ8m6hilgQZ45K1/vDYb8+W3aLZbQfTmyvjyH8MfpkQgghhJCLQhWxIKgiLgJVBCGEEEKIF6+KeHoO3357+/v3r+Hn9+NX336En8/h53P4+SP8Lk55+B7++hqent++ffqMra+aVsZzMkpb7w89WcR3/Cb9Yr0/tE2TfNnZ109YNW2fHDNdNe2hbdvD4XDYN933x7AR5eskmmmbJolKFfurpo0FyfPVym/5IaUztUT/CDuD9bLyReXX/GDZge2l00mF7t/HPvGDSOz+yd0OX0L4VJz1UTvyQ39APFjy2Cd+CuHRLiUhhBBCiBOviugkQce3H0dJ8PD9qC4evifq4uF7+Cm0hwVUEcmo73p/PEaMI6+aNgnq1vsi8Oyixv5sOQa93qfh7zGqbptVd95+Lcph5OsisxMN6faT8if56uVHflCPW6x/RNDfrNOvCsMoX8M/6lwEtqO3F+SPED70f2cbo9FcxJf0LMknTUXElC/g70eqCEIIIYRMjXtF0+d+quG38NdzeLCPCSGkwmMAS0WgQDgdvYefon37iDQ9lqdPyf+37QyD7IB0b/nt0ukqYsH+Gf6uLt8sXVERznYx6KYCVAwVgU5RVUTUGx+FWkDphBBCCCGTMGJfRLeoKVvOFD73y5mKRU1TqAiwYKdckTKsIoZXTB3toCjZzNcBKg+y7y0/8sPxlFJFLNg/RfG19gX5Yv/AORmX/xFy8VKmDaZSEdLgo5lOCCGEEDIVI1REpwrkcqYQwpPc8DD9XIQgifnWe3eUCec6kmVSw2Ptk+xLNsa8NftwrgCUX/mUZl6rIpbhn+HvUL6Wf8BcBLIzdo6l1AzzqYjAuQhCCCGEzMyYdzT10w5yOZPcdf3tx1gVkQR0Yt35qtmDVe3Jp1XT2hqkat9Fki+Ikq18A16AZVYY7YsQ9uG+CFB+5IdQGFiyf/C+iAGNeczX8o+6cQOV37cv4oPQA6Vm+AD2P0yiIrgvghBCCCGzMu5Nr0/P6XKm7n1N/XKmb19Hqwi58iR5Bw58A1F6xipNr1/RlNhvBsfarXyDJ0oWOeN3NCUBsP6OJr38yA9lFvIdTcvyj6d98fGGfxQ/WPnC9tKRb1tSBQN6R1PGo7ATX8dkr1ziO5oIIYQQMh/8vYgZUJbITIO5T+B6mM0/RIUrmgghhBAyOVQR07Nq2pGvJKqwfAPh93z+IZGP4ucpHvESKUIIIYSQcVBFXBO3oSLIeVCXSxFCCCGETAJVBCGEEEIIIcQHVQQhhBBCCCHEx02piPJ3DN4f438nmlyOlxDuLl0GUvLO2+UuhBfnKbsQXt6N3wb9s2Q/LLOnWGaprgP67jY44VepLgNVxE1xBVccUVhytPGeYbu4uA9hd+kyLIpFXz8L7CXZf50CvXcbZO24wPs0gyqiR/yiwNma7PiTBNPkqz5GNiFstWGzbT9q+BLCfZ/4kv7b9uk7cYwEHR/6HLt/mxBCCPfF8S8MO0IIZ482XkBr3iqj61vTLtn1vNESJRstPfu4W3gACtikTwAv2+L0+NTKnj/ROej5g/xvPK/moKYR5VNR1hE9t73E53z5pPWEnbKvmquD1MpziX55iVT44cwq4jpe2H6562e0f4p2XLo8pIqIp2q/CT0zyXXm+ik2ZE4xoPZGWYe9Fb2yGm8ZKkJNv0u/ynprjllmUEXMytwqojwmu/jj1X4vbsONSH8Rt9jde1URm+KxEB8UhooYfC5tUz+f88qvacTosfv0ET2Jitikfshap7qfzAKi9X6WDlLrv5YeQJ2LGj9QRZRc8PqZTkUsfTZihIpQf+g3vNW9Kb9E6RMRi5P/prL6G8/YiLYSDf+Wc/D5IbugertpcpqbGPsR8iarSpIErjW1N/KqAu/x235QVqVeRaDoIeABRTm2V2a6Tc/amWOBMT1muusjvG3/x0bYV/NFxJJs0ixUOzswho3KadRXHaa9oB/uPeU37KNyomFpZAe1C2JQRchbL7svZDQcY+htRdZz3xcBHIyuk03h51ieLTBVUj4WNlOoCOl/r4qo8XOG9/qJzKEiMvv5U7cyPDEPO3ZUSegjxoBjemcHdZxqLjWJsl8uu82ynIP9tVVOVK+2bQ+HQww7jr5A+fqATaDFPyhfKy7S6mX5J6UzdU1+Q9etFcfW+g35x7ID29GuxSLwqghjzH69LxrETC8pnT94CWXlEdG/Z24ha6T4ET+tvH5ILMWTExWhHyLtl7o6SQGyG81FqB3qVCoCHd9xuorYpmHrvfg7VjMb2rxPg91o/yU9IP690dK7aD7OtMSKGPmqZMfHeiE7O5COyonq21G22mX9ECOtTfHVRju+tG/4IWj1Neyo7WIwqCLkCH12PcePL70P73qD41TEVPdFRxnCouskWlali5qvkd22/2OTqv2IS0VsUmk0lYoImn/U60eu7bQ13hwrmiLlXER1dNKFOMqRyQT6qmmO/VcaDh6jzKOZfKxW7b+6U+yg6nhi1h+mY3L1/TUuJ65X26y6896GB2OXPc0aB9UPKP5B+eK4SK8X8o96XG5/8X7TrltUX1Qew2/qXAS2o7ejqMXtqAhr9ziaO5pzTsmYQ/DscgdTBZVPqyo/CFPH3JJ9EdmTTbO43kf10Tar/FegnY6u2RcRY4vKfREbkT63ilAtoLFelOkOHx+0dBn23QmbRr4q6HiU7i1nMJ2sqogl+EGilr/SfpZe1tfrf4PsFigTM4OGitj00wKnqIhJ7osOVUUY/ilVhNefL/2Crq6C8fRyTkndFyGfP8j/6CsVr4oYcf2odiYkahjlgeyITtR9EXVdTmW/rBh7SxL9nZgrUE5Eq4Kd/XVl/FCuWehT8v9tO8MAP0D7p8VFlaXWVcQV+g2UDqZVRrqKinC2V+SmVEQ5WXBZFYGeJuZKpGE7gypijB/iHYZnNGJeA/Va79u2bZsVKrYTOX6Gov+lzUUEEVjs0uPVaANlWrNiQdpB0bORr6teyI63nKi+8ZRSRSzBDxLUXsi+ka9aX6+fEeoxMcdsg5A9FxH/GK0iwkT3RRCFr8w3aCrC689dL6XuxR+GHfT8Qf5HxxvlcamIEddP8DwPT0FRmKO6jHQsGZyeDJAdqvrlwlo68iY6PMOOujDH21/XrZhS6pVFwWa+9bj9gPL11gv553iKuSbtWvxWVEu7HkB5sN/gXI2rXYqaLBH/XITH+2Z6iX9F00RzEZYdNObh9sPbF/mtlaxoEvICa9Zm3zar9b5tmqwU4/XaYK+8wH0Rahm2/qgUjelutXRjDN4VnRhj4cj/6Hi1nGEiFXFmP0jQXAS63pAfglZfw86IuYjBFU2xIsa+CFmeU1SEWgbvfSGLUZ/v6XMR2/7fXa98bHU3qCJCsYt9VhWh1rdmRdN5yMo/MjhBY6jJEcJw7ehe/jlf89GNnQ3bKYvg7K/NuQ6rXsqY+gTBH/SDFSdo+cK4CNRL+SRwqIhl+62oljYXoZbH8huYi0B2LI8vXEScsi8ihFXTVoz4zzgXUY7mSy0O19UpK8/W+no1WV207rDWD1G3Hr/NrjPxEZSnuxf23Y12vCmGs84pF0Z3TKUi7oogRlKvImR0KNepZyGjuv47FNV0qYgYDWy0aCaLno1847d3RUppH9lB+yJQOVF9o7Vyf8gF/YD2RZTlR/YNPwStvsgOaheDwQhefrwH7ehVEXPfF7IYEq+KQPVFbESx5TV/ioqQH70qAvm5o3JfxCDed1utq1/nJ81uitIa0+b5LIHeTaUlOa4vL2YH6qJ/TUYkfZ+25D6xvwd9q6+/rlrJrNUrj4atfHPvGUA/gPgH5QvjIlAv5J9QGLhGvynXLawvKI/lN3VDB6oXakejSAvipHc01VV1ZhfECYz6dzRp+1f0qdC0tugdCNVNvt4fkGyIn/tzRXmyVUvH1VZazap9rS5vyAbMsihW/rOPD+kIXBnD1c/gSyOxqLbxsl4oUxSd3IF8UfRs5Bu06DmI19oY72iSy1TUdzShcqL6lllc3A+u9kLHG35Q62vki9oFUaMi5GIStR29KiLMfF+U71yyVxbFs8poGL1bTEVeIdv0+YNUhPr8Qf43nlcI1c/IP8F//YQ5VUQ2DZIARzi1/lGu3CgH4Ir0pDdN++WBlRvKWo6+G2xElwf6ZdCLw3KqpTDKOVCvIho28g2edoR+UOMflC+Oi/R6If+UWagr3BbttzFxbO11jvxj5QvbcfEzETf2exFToCqMKY3PfD0sXba+S5S3ozix95lcC6f7gZB3j7JUYpyVBfYUyyzVPEzTjg6WH49WcXa/XZQruCOoIkpma7b3dfWTyK5uSNK2cAMq4nQ/EPLe8Uw4k+Vy/na8DRXB639pUEWch7dprOu/hclFuA0VQQgh5DLchoogS4MqghBCCCGEEOKDKoIQQgghhBDigyrixvjl3//79eGfly7FdfKv57//58+/XboU5FTSduQdQQghhMwCVcRNwTj4FOi92yBrx3/8+et/n3+5YHkIIYSQm+SVEEIIIYQQQjz8Hw39aRpm/BuOAAAAAElFTkSuQmCC" alt="" />
 
查询多条数据,并遍历
  Query 获取数据,for xxx.Next() 遍历数据

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAy4AAAC/CAIAAACXAx+HAAAbx0lEQVR4nO3dvY7cRtbG8boLX4IMARsx8l6AHChSooiRsVhgQl2AACYTayPlA6YClL3JxAScKHDgwIGDDfo69g26WayPcw5ZzY9ms/8/GLCGzS4Wi9PsZ4pFlnMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOxZ3Z66pnLOVU13autbV6eIrzvuyKtzb29dB+Qe/Li8de618C0vzr0+fLuh1Itz7+etMIpvxjt0v1GMX7f7xFfXPnFcirx37uXWdcA9mp+0xt3dtznmRbGq6U4Xmx93MYk9Ofcs/YH73P/9+hp8DF7j/5775dpHRVvf9Vs8//fknHPufbb+K+du59zmX/mvG5z49uTq/Z1yXJLf5ydpYehJWp78+HKfKfApPgOUes7e7s9ayfnHN452/tHa3zhfPZrwbBy2rfZ9UaqonAWjmLFdeiruzYwoVrc+gVVNt/GBl3/TxF/N5Kz3HJzaxI+EEcXE5W/jl5JTHn89J4hiq1o7iuXrJL/8/rf9ffAxfAqWvwYfsbePGsWestOCP1EYUWz0vPQct/ND/eYb/JF6H381HDiKbd0vVrenrmnatGum9kvCrJBUbFiUrz6jPmJBSj3V5bqq6U6zU4+vZtc0URRrfDfXeFXiMKRFumytye0TJD2Xlav8oom/mqXRqnT95757QDQ9immnYKf/aRv+tZdv9Dl+14v516Ff7jf60n9NPvf/eArKF7er8TV5ijchlvOi9KZo9TT2V+wwuGE7vC+pv1G+Vk+tg0QrRzsumtEoFn70ks9FGCl8EHmesOm1PxdOWVn7PXnK2tnX51kpKpefFp6WiGJh+5dGsQOff5IKh9tdL4qFvwxh5Y12eJEWOv28Z9V/4yxWt6c8mIi9NXkvSr8keqVur6+90Usk1tNYrkujWHCNcGDvQ1LPIEKV9HIlR9r/qEex0vaJSkqCmdL9anwk8rOSdqpaKrqdzY9iz/E56H3wb7+byR/Z7+MPvy//NV7B//tJWn6ORL7Pz++IsV1Rsr7fL62cF2W5Vk9tf8/yo3bbdvBn0qfspSdp/bx8ox2ctL9GOeJxMYxGsbCvKPl99j++9m34ti/wuii21OfiLP8+035PfMliLhG3a2zuuf/HUxxZvKIo9hTny0Wi2F2cf8IhInZw3P4CZfIbbv9euexAGJ/3fUWx7BtZ6a2pW9/Z0jWVc1XT+RcWubimbFetp7V8TUZv1oQah8WURbHy9gmKSrZW2nBTxoolf7XktPXtU94iUUwsQet10Db6oq/vpOXhd+fboExjuyJtfW15aT2d2chiFNtDO4TE+k8sP1me729p+xuSj0C+MCnQiGJPfcfJnCi2yOfiTIxiRvvkUay0PV/767PnHfRvz3s3xbFi4flHa3/tJdFRzz9n8/PW1fIPgl1/+2/7ifu7gyimRYHL8rrtuq5rqnC1oGfp+mCUd0/tM4qNtM/kmpX2il3TPj4eZq9f+3sW/lWhRai99Yq54Oz8Eq8vnrK1jU65APE64VRobLdov7RySuup7a9/Sx7F9tAOIe14aeUb2xX3t7SdNeI6fovJoEm7V8z/4+oo5hb6XLig8hO366QoVtqeL30efR/8wyhHO/9o7a+tb9TnkOcfo0obeMlC8OjvSX6iuGJ/dxDF1P6Wy3ikrqnqtmuaVqhn2vdSWhf1vetFsfILlAv1ihWPFbumfS4vCC9f33Kjp7bSKLbBWDGxDs/lX+3aX73P0nLjr9KiU7zRK6O1v7a+WE+3UBTbuB1CWq+Y9vumtYOT9tco54pesdELlH5HjLFiYX3mRDGxDqWfi7Aa07c7v1fsuf/vbR8v7Ig8GsVcdnvEUlFM3Nauzj9TLlBuL79P1pVHMfvzrrnJsP30C1kbk1S3p65rz50s566x8yptMFIsjzHTr19G766abkIfU3mgWGDY/lVjxYTtKu0cNkP0rivaxw/0F4/yxGbIBzGcLRXF3mZnqND0KBZ+5J7iU5VYh2TcQLKbRadC/xXyNOFUaGzXv/o2W5KXr5XzEq8vfrXnw/+1Rp7+V+k27eCXJGPF8vpr5Rvt4KT91crRjoth9Os5/PG9chxLo9jan4uwGqHSKKbtr+YpqHb4Oz8nioU/lkaxY5x/NPnxss0ft/SU/UadXRHFjM+7ZusLbsaFrbyDqGq603ARLUoFxvXJokMy3CGYpZb9RLFgj6ffQSluV2m5sBWatO+sqH36t0jx3g/2m0Ds3U3+hEqiQPifvb6L/ybLvwind4yHhfiq2oXn+6VtVDsFvFW2q50Kje36l5KFT1L5Wjkv8R1DnlZPbX/zTdy8HYqOl7a+0Q7i/hrb1Y6LZkoUC4cWicexNIq5lT8XYSVf43hUFMW0/dWEvyHP8flHi2Li+Udrf+N8pTnA+UezfRRLvke0scj5LrxIH5Ciz+khH/E665rlg1gkHlqFKweAp9jtkNgnX8QYU3VH5rcDgBu55ff+/BPgEb8ZS7peHtlqx54ofGdeJv+dapRwgCg2vx0A3MZNv/end/UBW7hczSSIPZhjRDEAmM5f3aY3HQAAAAAAALhXS907sOEM1+sNsjvi8D0AALBndxfFVo1LR7ypFQAA7NjaUWx4NNaUR9uPW7vjio4xAACwoS2i2IL9TKsnJfrFAADAWoSnt5+jx/BCFEOUxVo5fm6kYE4gM4pd5rnMNqIt14KSUc+y8vVNAAAAzBJNTVA1TTCtos8eYXAy5qZUyumaKpkkaTyKqbMnaX1s0nzm2lyQxeU7ohgAAFiFMf9kPOvh5ac6nQ1RXB6X07ad3oEmTKZYPNek8IJWz6vKd0QxAACwBi1hJMvrcLprKURZ5ZxOXZdmsfELlCVRKd+6Vs/ryhc3AQAAMJvRmyVFMVe3ciIZ611LpmhfNooJr2j1vK58khgAAFiHPsZLjGJxiKqaLhxDpo8VS1dYOIrJWUys51LlAwAALEO9gzJcI+nSEoZ4jdxB6cKx+9lzxZJh9ddcQBRH7iv1nHsBFAAAACEmPgIAAAAAAAAAAAAAAAAA7NKPH/J/AADgsbxx376737+737+6f9y6LvdFfI7G1GH+Pnv98df5mbTdX38QxQAAeDgfPrtvv926EvdIjF3TH37RR7Hqr/+e/v6TXjEAAB7Up6/uy7tbV2JByczeMx9HoT+Q9ppHoIX67FX/3feHEcUAAHhAh4xiQ35aK4rNfigsUQwAgAf36av7/XvwXzBW7Itf+Dl6y/lqpn91NMPV7alrGv/o+3CqpHiREGCGRfnq9iZPbRvOnCnOFhBPKCDMC5BPKx5u2whcE7PYJXv90fyXKAYAwAPLe8U+fB4S2Kev0UiyD5/d79/dpzdTC0+uFg4L23SiSn0IfPRK3Y6lnHPpfjYkeQ7NaFameFtxjNJ6xebPH/7jR/336XQ6tX9yByUAAA8sj2JfwrD1LuotKx3jLyWWrJ/KZ6a2DhaEYarkGuMlPPWBqNb7x6JC+/6yJEStGcXcjx/ux59tksYAAMBDSaPYG/ftu/vgf1w8imnTjV+W123XdV1ThasF1wrHM5kPT+eSo/L1ecijGcul0hKLXaBkrBgAAI9tL71i/biyrqnqtmuaVsgz+v2M0jpV0yWjxvT3Vk13apvksqW1RYbtAwCAJZSOFZsdxdQxW3V76rr2PGTr3DV2XqUNn0whDe5Ph32FpQe9X9G7q6YbShpeSbeQDiob2TVjeYooBgAAnPIwi+HmSukOyumUXBJcLAxyz3CJML5YaF6ftKJYftvAcAdl9OSxsBrJj/JNl5ct84hXAACAW1lm4qMff7ZMfAQAALAppgMHAAC4GaIYAADAzRDFAAAAAAAAgJ2ZOY06Nrb98frFuV+33B4AAA+FKHZfOF4AABzKxl/tU+ZReARXt8PM4/Wzc/+6+s0AAGBxRLGbIIoBAO5IOFfmP36LJgYYZgsIJtB0/WwBX75fXs2nGRho05a78AH86dem9mj+y/ya4Yvn8uU3SPMLVE136rrudDqdJ8vMZwyQKlTGF9M1TTpTaFq+n7VT2K46P4LSDrFgBtGdtY84W4OyX9Z2tfpL7WCVox4v2Tlvnf/7uV/4U7Dw/F84AuxX537J3vWztOZP/Qp+5dDHfuEvzn20awkAuB/hLEzh9E0fPg8RLZxP8/JjONm5QY1iUf9D3UozWWZTV6YTMLn+q7d/d9gbUrdxhhiiSddUw6RQvh7Gdouks3cKc3cG5Uf1T+YSleqvtYO43m7bJ0hOTR2/lBWsz7Wqto/YK2bM2SoeL9W/nPup/3cy4l7rFfs1flfoFymK+SW/Kv/+SBQDgCN513d6vXHfvrsP9jrOuaI5NK0opqWJuB9J/cmXb68RL/f16Zek/7fLGaeVoywvrb9dOzmK7bh9xl+btt1kuRDFCo+L4dwpJTKimPYWMYr50PZzELm05QCAAzhfo0yuTrp3/dXJ7BrlElFMuf6WX2Aaj2LjF0CHcrSoYW63gFYfrfzS+mvtMLwlj2I7bp+s+tLxVbart4/aO1jU/prwWmQSsJaKYmGBH83lAIBjOEer8Oqkc+5LOAhs+V6xQPTFWbfFX9Vqr1t01XO812eRAe9G74tUvtprpdRf+Cne+NQoto/2GX9N267VPkqvmFbOtb19efBaL4o5esUA4Nj6DrDw6mQ4nP/T12ujWPStGIzFqZpWGekT/VQ1nR3kJo1Fi7arRA1ru06/nmrusDZWLChfHSum1F9rB5cVsOf20ceKjQT1YbtW+4iD2bT6l40V+ykIVXnw+kkZE7ZIFGOsGAAc25fv8dXJ892U/dXJT79dHcXCC0nRHWrq/YHxO6p4+fQLlFH5zWivj7VdVxI1gi3rd1BGKUK+g1Kuv9YO+SbCOyj31T4lx1df32gfoR2s7arHSxbeCymmLu0OysTHoBx/s6R9IZI7KAEAj0q44rUMc+zU/VitfSDiAiUA4LFUTXflDYMTSj5AhlmvfeD9HDzG7KN+xRMAABQ4RhTDNsSrnwAAAAAAAAAAAPcpfb6r98Z9k6ahxG5d/yR80HbHsNTcEIeTnOfD2+TleVY0/W3HNCywhbLnVuDm+NqZg9Y7huQ4MiLTZkx5p6BFgU0lj+DHDOFMPWudxqQsETyB66HPnhPaYeModh/PALnd78/V7ZMdRzK2pTyK0Z7ApohiC0m+Vep2lTPZ+ITaj2tKOxDFcjf8/VkuitGLYyGKAbfnp/2Ox4p9+qpOB64RH3HuLp/bJn9RW66bMDXNBMp2g16rYCacpFbDonz1kYpbc2uaT4FPn85faw0tbmXKQmWa8Hwex6nH16qntl9d151OJz/5wNAW2nbLqIfAF6/PjhDOmKTMjmDMH6G0TyycHeE+2s2eNUH+vE9tN619rHLU46jvRdn5ZP3z22znUPVOGgGmnOeHdxVsRppZDMB82rD96b1iyVx+6ezM0idXW65LT535GXvKKU/crlj//I8/aUIgV7fTtilVTZuTMew3G+oWzVmZ9RqIf6ue32J/M8lzU0b7VXZ89Xrq+9U11fl9bS3PfTnvC0Bsh0lzhgbbVecMVfZLax9xvbT83bebPpfoxM+Xul/yz3Y55lyis6PYquc37TxWfH4732XVn8k/fJams5sXxdQTGYD5Zkcx654lY27Bm/xpNX4ZL/xCi6Zk9M+VL5p00Rean06ntYFfK/kWSN4tFHZZFNQ/6LUS3qjtV+Hxtesp75c49+VS98Ip7aCWrywv3S+71nIUu8N2U2qnLpt4RhCiWOHx8uZeobyT89sb9+27+/Sm//FdejVjfhRzzskZGcB8c6NY/ufbPk9V2na1aHJZXrdd13VNFa5mzGc+oQLydN3pSll7GhcWpdKCBedVR6OYsl+lx3faBVBhv5IoYW53uuJ20LZbul9a+wxvMS8x30u7Zbsl/T4o9dHbTe01LDou2Z5c417Ob0moWiuK3ezUDRzcEr1iJadmc/l0V1+gnPxXe30e79E1Vd12TSPt5RV/Imp/zWuF5r0g8p6kP6eXcM6BcrycvAqFx9fsdbP2S+jdWeDPb7UdrOMubVfttVL2S/gpUBDF9t1u2W5Jny91oJ7WbkqvmFaO1eKzh+2ve35b9gIlUQy4V4uOFXOuarqxL3pjuW7BYftG8Mi/gNrzt9vwTVQ1rS9B+MLI6pk1SDQeKOiRaobFcT/VtAglZbFoX6RhSFH52n6VHd9JY9Gk/cousBnbTVvPoLZDetz9SvJ21bFiyn5p7eOyAu6x3YTfW3V/lfpY7SYOctP2SzuORpXSvTBtcn6b7boo5tyX72V3yhPFgIWld0rGfx4VPcxiuNQw+Ty4nygW/WkanGf9gOjgX8naeWFSPcMLMVn75Muj8v0dYVMuxAiXZvrdaoJdCLca3HFm7FfB8dXrObJfWaQwtutKvkrVdhhe0O+gjNKCfAelvF9a++SbEC9Y77rdrvm8T/0919rH2q56HI0+sYJ22OL8NpsexezzvL+/cuIDvWf3MgLAoT3SH6xXXBue5yBfQZu3203pn4jHaodFXXLpw5xqAACivAtwgy0e4Lt7+3bbJ9oBAIA7c4woBgAAAAAAAAAAgPmC26f2MPhjuSdKFpey3rD9R7ohAAAAlDhmSrgi0K3aEIyUAgAAksKMMP0e9vBhYNd0Uc2rT3n0WTuSHjPyAgCAeVaNYvIDxpe0WBRbPSnRLwYAAELZLG3DU8i7rhseEX55IZ/UzQ4WcUiSnoXepM8D9x1pYcnnd+bPDrfrkwcfrRxt/bhGyYty/fXlxiYAAMAjywJCP3udn6wo6i+6sldMiGJaN1laoWjuwmz703vFRssRp7iR5tY06m/sF1EMAADkxCimzs231AVK43KgFMX0WQnLophZjjBvpLr+NXPnEcUAAEBm1SimXs0sjGL6NN5lUUwvR+tFyy/gmvUnigEAgCLb9IoJL+4rigk1qtvy+hfsFwAAQHEUSwdNRW+bFJL6F5eJYmp9ss2PRDE5iw3vqJrOevf4fvEwCwAAkCuMYupNhfOjmHJL5IQIJd/R2b9wWX2sHFc1nThyP7s6qdTfWk6fGAAAwAgmPgIAAAAAAAAAAAAAAAAAAACAPelv+ePOOAAAgNtQH2wFAACA1fGcAgAAgJshigEAANzM9FkZAQAAsIK6zabGAQAAwPoYtw8AAHAzjBUDAAC4GaIYAADAzRDFAAAAboWhYgAAALfAxEcAAAAAAAAAAAAAAAAAAAAAAKytH72/kxspq6abcyOB35srbkc43nM9jrdHAAAczTG/ra8IdIdsiJnBFgAArKzwu7pup/Y21e0ptFIe0OpTHkEOmcTccfcLAIBjWDWK+TXrdqXrn4tFscMmFvrFAADYp2BUVThWrGq6U9d1p9Pp1DbnVbqmElYf+YKPQ1ISCOr21DVNm5TkO9LCks/vrNN1R+qTBxCtHHv9uMbVsGtyG2jFC/tr1SfYN79R7biY25V3DQAA7Eb2Rd3PhFQ13fmLPeovurJXTAg2WjdZWqFzLOmXpNuf3is2Wk5SHTWKJe0xrBOUmU4nJeyvXp+6ldpbPy7GduWmAAAAuyFGsbZ2w1f9ElEsvUBpXA6UoliwbvLOsihmllMQxcTKx0VYP02oT16qelzGtkQUAwBgx1aNYurVzMIoplwoNOpTdMGxdH3p+qFwwXQ8io1fAB3K0Y6LuV151wAAwG5s0ysmvLivKJbXaGT9fOt1W7S/Zq9bdNVzvFfMOiIkMQAA9qwwikmDkfwLk0JS/+IyUUytT7b5sWglLYjvEegjUasE0+inqunsIDdpLFq0Xe24GNuVNw0AAHajMIqpN+vNj2LKLZETIpR882D/wmX10V6uqumSJUPRXdMM64vXJ/N3mDnPqk9UfjPaK2Ztlz4xAABwN47XgXS8PQIAAAAAAAAAAAAAAAAAAACAu+Nv2NvHAO+Z9/wFtx8Wl2INcn+MAfCPsZcAAOzJMb99rwh0dkMcs5kyPPwCAIBtFX73LjTx0WKmP21/QklW1to4ik1v5xW2/AiZEwCAnVg1iqnTgS9msSg2lkAeJorRLwYAwDayp9sPT3Xvuu50Op3a5rxK11Tqw/BVcZiQni3fpM/J9x1p+cRH+TP17fpoc1Bqz+aXA4hfO3rafvhCNOOQb7C0ePX5/EI7aPtl1V8qXzuOWv1HmgIAAKxCnPioa6rz13tbLzQdeB7FtG4yaQ7KoaR0+2XTgZvlZNUJ1ommdUqWBxMrScudq1u1/dR2yPdLr79cvn4c5fobTQcAAFZTOAflQhcoC6cDj/ujpsx0KUcxsxxhPklxfWW5Xf5oqflqRfXPy1eP41gNiGIAAGxo1SimXD0sjmL6NN5lUUwvZ/r6+QXEJPrk5SdNcX0UKylfO45a/Y2mAAAAq9mmV0x4cV9RTKiR0SumbVFbP3jDrF4xsf5K+VavmHUESWIAAGypMIpJg4v8C5NCUv/iMlFMrU+2+ZEoJmexsbFizlVNN4zNEsdghQWnraS2Q75fVhSTytePo1z/0SoBAIAVFEYx9ea7+VFMuXVwQoSSbwbsXwiG1VvluKrppBHslzK0OyijFCTfQRnd35iVo+WedL/0+svlm8dRqH+wF/SJAQCAG5jVIXSIEEOXGAAAuE+HiGIAAAD3iSgGAAAAAAAAAAAATBHcJriHAdszL/QFtxMWl3JPg9YnPp8MAADs3DG/xa8IdPfVEKOzBQAAgHtQ+B2+0MRHi5n+tP0JJd0giU1vz/yNY4+oBQAA+7dqFFOnA1/MYlHsRklmuShGvxgAAPcle7r98JT2rutOp5N/eHzXVOrD8FVxyJCeFd+kz8n3HWn5xEf5M/Xt+mhzUGrP5leCjPZUern+9lQESTlm/ZVy/OL0qf3GLgAAgD0TJz7qmuocFdp6oenA8yimdZNJc1AOJaXbL5sO3Cwnq07UlVc1TbLZ7A3JnJXBLEN6+0n118uR58RUdxkAAOxe4RyUC12gLJwOXL9XsCyKmeUIyUq9ZKkktwn3NI7XXytnrHyiGAAAd2jVKKZezSyMYvo03mVRTC9ndP1s59Spwz1h8u3sWmdef62cKdOZE8UAALg32/SKCS/uK4oJNbqiV0zc37iKk3rFtHKsXjGSGAAA96gwiiWX+eK3TQpJ/YvLRDG1Ptnmx3qVxCxmjBXLtxptsmq64WaEeKz+WP2VckbGivEwCwAA7lFhFLNvEpwVxZRbCidEKPEaqH/hsvqUC3ziyP38qqI5EixfP7p/MrvzUay/st1gYoRm7AIrAADAfbnfjqX7rTkAAAAAAAAAAAAAAACwe/9T/gMAAMDq/ufcf4J/E8UAAAC247PXP537D1EMAABgSz57/ZsoBgAAsDGiGAAAwM2EUezfRDEAAIAthUP1/8851/eNAQAAYHU+h/3HuX/SKwYAALAlxooBAADcDFEMAADgZohiAAAAN8MjXgEAAG6GiY8AAABuhunAAQAAboYoBgAAcDM/fsj/AQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANiP/wcN3jrr5PVSTQAAAABJRU5ErkJggg==" alt="" />

5.事务
在操作数据库之前执行,db.Begin()
例:tx, err := db.Begin()
保存到数据库:err := tx.Commit()
回滚:err := tx.Rollback()
注意设置事务以后操作数据库就不是db了,而是tx

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA14AAAChCAIAAABYlvn0AAAX/UlEQVR4nO3dPXLbOhfGcVTpUrhw5Zn3unbLJnO3oCo9qxSZ0R5SsFHjKlvQcAF3Aa65gexBS0j/FjQpfJwDAiRIff1/k8nYFAWCkC09PiRIYwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAN6BuT11TGWOqpju19eU6MmP7Y98jSwAAAJDsaqJhNjEG3txeAACAS6rbE9HBNjsa1u3JtvmgagVCCocAACAZ0dCzKBqO61dNt3EgUxMgdUMAAJCgarrTSSx01e3pHDOqplsQHs+lNLeJuj11TRM+qC2f2I2lKWzsZtc0TjRsxkGa7Iobsr1ApozD+BpY27XXtlfuW9QGNBIAyYYAACCVUjUcalCLiorWk/0qWt2exECnLdf50TBMvJO5zuunFQ3V/sdb8dbXxkHerr0jfjR047v9aOSwMdEQAACkUrPfUJ6aHyrctBL7TnvONpSeeWlwsmfOuYZeDBbbmRgRKRrq6xMNAQBAAXpZcNmRZKl8d53RMDz0K55rmBQNnarh53faOEy1L0VDfX0OKAMAgAK0aDieaTc/qdWtnkjWi4b5B5QLVg29swv7b7VxmFE1jERJpqEAAIDl5JPonFwTziBJjG9+HS2hBpcfDQtMQ5l1rmGw3XAayvCoNg755xrGRvCKCrEAAOB2BXNe69aps3nfZkRDp/G1ckyRGcrSTOGJGcpiNFQrlco4iDOUlanjkwe4q6bjktcAAGBbXAhxHSWKe9woDwAAbEssTWGeuh1C9vaXyAYAAMCV0a5gDQAAAAAAAAAAAADXqNSc1g1Pn1tvsgXTOAAAwGO7uWi4anzj4i8AAOChrR0N/ev/Ld3Y2oU9CocAAOCBbRENC9bhVk9u1A0BAMCjEO7S0Uch5aoq2sVWlHac+3tYN1uJ31u5CTeiLdeCW6Sfee3rmwAAALgrzi3vqqaxbuc7ZiE7yHn3/B2fqrfTNVXfnnejvVg0FG97py0Xi4ZaP+e0b4iGAADgISiHYr00dV7LXV9b7rbTtp1eYBRuKpx9b2XhAa2fs9o3REMAAPAItMTjLR9DU19NDENdrJ3Tqev8bDh9QDknuoVb1/o5r31xEwAAAHcnUu2ToqGpWzkhTVUfnePNpaOh8IjWz3ntkwwBAMBj0M8RFKOhG+qqprPPQdTPNfRXKBwN5Wwo9rNU+wAAAPdJnaFsr+GV/IRTBCdmKBt7LkpwXUNvmsicA77iTBSln0sPWAMAAOCacaM8AAAAAAAAAAAAAAAAAAAAAAAA4OoxWeeGvBnzkfmUozEfxnwY87Zs0ztjjstauCfLxxNbsl+v+/5Jvt29y+05n1zAavj1umsFPycIQzZG47Z4r9fRmN3F+rKum/7JzHtduDhdtuiFqQusv6bzrfK2jyzLx8G77uO1DKpKTIZ7Yw5BgWo/FJ/6f2Pg+HDDh/3GdLDW31kr2P8OyvLeLlj+MZV1svoZb38f9Ofm7K0RXuJ2SxEr2fgD+ON+o0yW2ePgvV7pP89HY/buE8N3xZTQaffcfmvV3g+N8v4ZJ+7XLr8drfG12xH7L34e9ahsZLrlaPjpIq95mWg4tuDdZPAKyaMc+VXcB7+6YfLr3ygPwdvc27DC5FvnIdhKbjRJ76fWvv0ZELZ2K0pFw4P7AQmi4UWUiobpJ2Z4v/ve21p/tsbeXZIbDcX1tffPOPH3dGxnl7zXWuNrt6N96GifR9QNJVaB6jw455qb+1jVdKeu606n06lt+nW6ptLXX9gjt5G6PXVNEz6oLR8fS05VVdMtS2H6OHg3EuziI+SGS+neNPI4+IuqphtfKH9orL4Kd4tJa1/s3yA3Gh7c4lz/FpbyFqktDzddJBqK/dTa995kJ6OAt7/2+mJJwLh/PXvLj1bNICyshtsN/wr3qqdaNTdR+Gquvb/afnm7Nm70OHxOH4IPbG27ucYeerUisf2jXnUW+x8ZB+91HNu/tvHZ5exXZLta/8VxiLSjvV5jgykp8y342fbepry3jlLRcN4h7/izFka6bdoJdyHyeUQ2DDnRqW6DLOaN13DjuzHbeM9fXjW02nDusvf5kBTctOWfjy2IhmHSSwq9yjgMfUkYpqloGO6vPG79DkjjWbfq65bRvrtjntxo2L85jkXBsWoovuulRMOw1lUkGor91Nr33qEm36m1qHRwP4N31tfj8Hq93bmf3LbwRTlaS8K3WnEkte1GTH6yFt9fbb92QaYZ199bn9bjC1qq+uu1M+6v1v5RWa7130Rf9/C35jrHZ/whCQ/C7qX1w+1GxsdI4xBpR3y9RunZa1wzPMfmMPTqLVjZkxsNtffPuHA3R7tZDW7fDtFwoejBSjkatrVxYk7RaBjcrVn9TntO+mOrUcdhqLtNDlL0gLK0T8pIeSkubQQz2o83q9Mil/gumXKu4V5aHn46loqGYj/F9r23rSXRUOx5pCoZ2VkxGkaqm2E0zK2Gaqutvb/x/QqXj/35GM4iPU5tN4vWjrY8t/8m+rqL0fCax8cm7lfidr3l4Tjkvi6j9Gg4/hJ5v01jC/a2Fp5raPd5xrmG2jDOuLKBaIN2mImymHpc8RLRMCzT3VU0nD6SbLWgFiqFfdLGTToUPZYNM8Y5+rrM+L3SIpcZ3pXE96ad+1YYf+t8k9YpFQ21fq5XNTTWsTDvwJP3qTA7GmrbNVI0jK+vyTqgXGR/Uw5Y2+1o0Sey3Sxaf7T2c/uvjcP4lPTxv4bxsWmvr7bdSH/Eccgd/8kOe8ZfOvsp9nuIVy2ePECcUjW0pR/A1bae+/4Z6cna7RANywkDzWWqhmoL20fDsgeUz2f+TXYpOpJKVU/bohj63A0kVQ0j+509ypHItR/+zI3/9T8ZDcWtFIyGYj/D9gueaxj2oW8/66O0tzwazqsShTWhtfc3UpU8SMsjVbHlB79MtDqlRQFtfbH/plA0vJLxsWlVQ+1AqjY+RhqHSDuRn/Pc6lf49+QuiKS9NaJh2H/NrU8Xy31dSIaBqmkjwS44qWwiGobrD9In2Tq9qJpOqXl5TykUDRdPQzk3E7Zy3rNgpIPtZkdDZdzUcw3tNvytZ7QffUpEJHK9BX+1j7KqhuK3BaOh10+tfe0cJo39kbZ3P6rDPnjtm2C41ouGufuldWnt/U05l3Hv/ryJ0Sey3fHRlA9db9zGZ2nta+caav03U6WUxGh+2fHRzjUM90vbbmR8jDQOWjva6xXpUkR/msTRXeJFz93QgcnIa/88aO+H2vtnnLZf2pUK0l/fzdrJel24eI0gcjzZhJNS49EwOrk4fezPjQgzZ5OjoX7AVFcoGgrjULcnr0wXTAhfFg2NOG76DGXndW9Sz+lUB7NqurRx82a8im9tXjUu5WiR9hZ5SEgPpfqpta/NMNWMK9sfRW/ucttOGp+UznzoH0WT0XDGfplhQ95b/6r7q+3Xm7JdLfpEtmsyP9L20na19o/KOGv918Yh3MTVjk/W66utHxkfcRwi29VeL6MHuPiuiVmwNya/8AC3vdFwofZ+6D2UnrrC31NzO9GQo8m34govePgYNvyh5w8vpCh1mtFVOSgfUcvlho/rtN74XNBd/iSPsvau1OtbpB1KhrcjuaSEwvh7CFifWGIp1fIdRMP1xgfXoNTry88JsAmiIXDL7iMaAgAAAAAAAACAO1TqQKR+OZvitj+ZlNNXAQDAY7i5aHiRmMaZfAAA4CGsHQ29iw4WvvVySefr/yn7QeEQAADcuy2iYcF62/oJTdkCdUMAAHBvtLto1Mq9TWK3PBHa+fzGuWfb9N0+mnAj2nItoEX6mde+0cMn2RAAANwT5xZ2VdOcb7d7Dkd2kLO+dkqCejtdU/XtubdDjkZD/a59qYd1tX7OaV/ZxNA20RAAANyJyIFS8a66tXK33Vg7bdvpBUbhPL68eyXLD2j9nNV+5DGiIQAAuB9asvGWj8HoPCnDDXWxdk6nrvOz4fQB5ZzoFm5d6+e89iOPEQ0BAMAdSZte4VQHxSQ0VX10jjeXjobCI1o/57XPNBQAAPAY9HMExWjohrqq6exzEPVzDf0VCkdDORuK/ZzXvvYYF68BAAD3Rp2hbK/hlfykS/3FZygbey5KcF1Db5pIdnSrmk6ciaL0M6N9r6v2GtQMAQAArhM3ygMAAAAAAAAAAAAAAAAAAAAAAAAWe5xJMwdj3owxxuyshd7Xx4R2+tX2JbuGDI/zEwsAwOYe7GP2aMybMQdjPqx/Y8jrHxrt3W9HY4L8ICBeBBeHAgAY41xH8Fo+FqIX6F60fnB9x5V2WUyG+6HA9hGs/+GW2WYT24lsN8tkO2P5cPx6b6VGb80w/O2G1d6sdjbo/5hlD8H6/XK75Plmrf/mrm8/lNifsP0Z7WT130TH88H+ogEAhOzbllhXyL6wdaPhBrsof8LeZTS0E95hSIF7KxrupGi4H/7/0P/trZXX6//R/Xrs585a7SCVOb1o+OYOvlgWtWnt57Yzo/+R8aRuCAC37VwCc9/N6/bUNU34oLbcfWJKzaBqOv+WJwt6b/WkajqxrFc13anrutPpdGqbfp2uqfT1YxuV1/BuPNi546aNs3j3F+0DVosmXiQa7ZTqkVglirSzarQav91Z0fBtKhqKtNU2q3ra50Qe3APiYpq3o6EYHyO09nPbsSX2PzYOZEMAuF1WyHHujvf5kHoLukigS/9Y8KNhmNCmQpqTQus2zFzukmEXx8zmPb9I1XBo01lJG2f5HtbCzp1lVQ3tqs9e+cjfBc+6yAHlw9CZ9GionW4ozlbZLBravTq6IxkePvaWHN0o760c0trPbWdG/4mGAHCXgrssq99pzxEe3fBDwUlW010ZP7Gs+DY3Gmp3aLYePjemjWx0LPPP2AojnXc23vjRfojO9i11YDrXW3I0HKubO/ekuv6UuJSJzCvZuVHpOOxRvzAc2DAajk/fJaRYrf3cdmb3X0Y0BIBbFZbplkXDaFJbh7UL/pbXjYaxNf3zLbVxjn+C5n++hp/c4QHit+ChMEhdKhr2KbaPg0fr60jV0O6nXRPNqpOVslOqgKPEqqH4qDgdJF41TG9ndv9lREMAuFl1O31gNGP5wlyYf0DZ23zKAeX1o2HVdP2pjE7T4vqTFdi8ARWrhpMhTyxlXSQaHob/39yvc6Ph7hKXrQlzlZl1rmFWFIuca5gb6eb1X0QyBICrk57SnJBjTzTOjIazcuHiaShV00aCnX/y5FQ0DNfX+hmLhufH7LW0cY6da5ifDcNLPYfHB3t2xhJrjVnRavlfBUdrNnGYAvfG7KPRcD80YjfYS6lyLe+/mKuMO/4pM5R3bsCdjGJa+/PamdF/ERevAYCrk/VRp82QzYiGQblvsxnKkePJJpwUHI+G6iRiMRqK+1u3/imGbjpUxlndg6rpcsZHnIwsTkewz88TLw0oTmrWFDmRwC4B7odjyt6FXcRoOGago7WbeytoTioVbe3zHe1OigdwtQP9e2lhROS6g1nTWXL7r6JmCADXZ9upIFjTLRRgyvy8jae12YeD7XPdxGj4YQXZ8DS+lOPp/L6UdQs/sQDwaDJLTcAihX7e9sNMWDv/7YZ/YoFz8pzCpJMm+X0BANy44HBmzkFcAAAAAAAAAAAAAMAjKjU3UL2MS3nbn7TOafIAAOAx3Fw0vEhM4+IaAADgIawdDYMJMAs3tmIytLoadpLCIQAAeABbRMOC9bbVEpp9Wxf/fsbDMuqGAADgngh30egjj3JPD2Wx1s7nN/3tRj6fEY2GdXvqmibciLZcC2iRfua17zwxvH0L2RAAANwL+d67To7T7uHrlAT1drqmCipuU9FQv1udUoMMFmv9nNO+GfYqjIFEQwAAcEeUQ7Femjqv5a6vLXfbadvgSKx/rqHz3Ix7LqsPaP2c1f7Y5TAEEg0BAMD90JKNt3wMTX01MQx1sXZOp67zs+H0AeWc6BZuXevnvPa9mmh80wAAADcrUu2ToqGpWzkJTVUfvWxVNhoKj2j9nNO+mgtJhgAA4M7o5wiK0dANddYE3vi5hv4KhaOhnA3Ffua2H8mF8S4BAADcJHWGsr2GV/ITThGcmKHsXP0luK6hN00k+1zAqunEmShKP1PbDw5MOytQMwQAALhO3CgPAAAAAAAAAAAAAAAAAAAAAAAAj+rL9z///PyR9ZSvP/++fP8WXwIAAIAH8O9///x6/+ItfH1/+f3f14v0BwAA3K4v3/8IwUJfvsyP599///f77/9+b17T+ve/f0pEpS/f//T9/+f3n6fX5d1KpvdfKxBSOAQAALl+PP/++/xv+vIlvj39GsPNGu1HlYiGX77/sRr58Zx52HcRtf8/npWQOuPANAAAeGzisUhp+defn9U+L218/fn35fv7WAsc05623H1iSk3r29Ovv4vql6/vL0M3vF34+tNq+fX9ZSKtqiHMroaex+f1/eX3n5dff//3++/z9/eXsdCoLTfG/PufMMh6/4dHlcjLMWUAAJDj29MvMQz5y7/+HOPIt6dfTqT7+lM+tKotH6RXDf1oOB7Stf9NN6VU3YaEmtAfPWnJ4/P6/vL7z9Prudb4uS1tubWDQrVPqxpq4T7aYQAAgEBqydCtlrmP5p7o1ge7Iqf95YkdkBWqoZktSOMzJrNhiRUNpeUDoiEAANheaslQOKC5IBoOfjxvPBNFP9fQPYNQpyUtb/nG0ZADygAAoIBIFcpf/uNZTxjzp8dGyl1RZQ8o9/npKWk6tnau4UWrhkxDAQAAy2VFOutcOmNe31+swJHRzuv783nJt6dfCcdwxzWXX0ZnOMPPdT7F0NlHZbvaDGX9XMNy0VDu/+fWuXgNAABYIPHYqOU8QzmYuZyeS+yCX3JBq1A0FCZZ/3h2uuF9K29Xua7ht6df4gzlrGh4bmTYhPNaaJPEzev7C5e8BgAAs1FnujPcKA8AAMyVXzIEAAAAAAAAAAAAAAAAAADAhKrpTp/aOmG5qZrOWzJ/w11TxVapW3+NcAkAAABK0wJfuHyzaCjGwFJbBwAASFa3Q8Vs6xpV3fpVujktWBIbu75oqBUIKRwCAIAtVU03Rp/lSS1TmWjo9D8pSF1dNFQTIHVDAACQ6lwyc9ND3Z66pgkf1Ja7T0ypUVVNt6zGaJ3c5/XGyXdV08XDoxsu3SBlVRS9JjKjYTN2VjtB0R0KoQxrRcP+aUFLyl6SDQEAQAorFPklqbqVDw5ry4UmJ/jRMEx6SUd3lQ0OCTWhP84qToyKjE9mNJTbqdtzk3YvvGjbuE+Vs24kkhMNAQBAAjdNxL7TnnM2BLvNI4ia/Ya622SPnHMNvXisj0heNMwaWWWNqulOXdsqNVCiIQAAWCQs0y2Ihtbj20560MuCk0eSwxacp3iJalE0VNrxZsD0y2Mtn05dJ+8VB5QBAMAydasnhvnTXedOiC17QPl8ht9kZ4IDysMz1q4aul1PqxoOB8nDFZiGAgAAlvFDkV4jiy2vmtY7YzApiCyehnJuRsxJn70IomOwXW8N69vYuYZqJpU3KLVjj6XTq/i5hv4K1oa5eA0AAFhEuyBhVs5wCn6pBapC0VCYZF23J68c509BjkVDJ3eptzixN+zvhLdcn6HszE9u/Bql/7o46VSK4FXTcclrAAAA9LhRHgAAAAAAAAAAAAAAAAAAAAAA2FKpOa3yZWVWsf1kC6Z3AACAx3Bz0fAiMY2LwgAAgIewdjT07g63+L7LayZD7bKPa28XAADgSmwRDQvW29ZLaPb9YYROUzcEAAD3RrnrRlsH9xjx13dTUfzuHc694qLRsG77G4P4G9GWawEt0s+89p0n+ncIJBsCAID7od+r9xyO7CCn3VM4fs9f/55uU9FQvH2etlwsGkbufZzdfqTTREMAAHBHlEOxXpo6r1X7d/kVl7vttG1wr1//XEPnuVn3blYe0Po5p/3hNsdSBCQaAgCA+6ElG2/5GJqGlOSHulg7p1PX+dlw+oByTjQMt671c177Vqc5oAwAAO5YpNonRUNTt3ISmqo+erGqbDQUHtH6Oa99dQ2SIQAAuCv6OYJiNHRDnTV/N36uob9C4WgoZ0Oxn3ntV017XuKfMBnvEgAAwE1SZyjba3glP+lCf/EZyk60Cq5r6E0Tya7qVU0nzkRR+pnevnNomkvXAAAA3ARulAcAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAwGL/B/xCsGB8ke0OAAAAAElFTkSuQmCC" alt="" />

下面是写文章时测试文件的源代码,//注释的内容请自行删除测试

package main

import (
//"fmt"
"database/sql"
_"github.com/Go-SQL-Driver/MySQL"
) type userinfo struct {
username string
departname string
created string
} func main(){
db, err := sql.Open("mysql", "root:111111@tcp(127.0.0.1:3306)/test?charset=utf8") checkErr(err) //insert
//stmt, err := db.Prepare("INSERT userinfo SET username=?,departname=?,created=?")
//checkErr(err) //res, err := stmt.Exec("zhja", "研发", "2016-06-17")
//checkErr(err) //id, err := res.LastInsertId()
//checkErr(err) //fmt.Println(id) //result, err := db.Exec("INSERT INTO userinfo (username, departname, created) VALUES (?, ?, ?)","lily","销售","2016-06-21")
//checkErr(err) //ids, err := result.LastInsertId() //fmt.Println(ids) //db.Exec("DELETE FROM userinfo WHERE uid=?", 1)
//checkErr(err) //stmt, err := db.Prepare("DELETE FROM userinfo WHERE uid=?")
//stmt.Exec(2) //var username, departname, created string
//err = db.QueryRow("SELECT username,departname,created FROM userinfo WHERE uid=?", 3).Scan(&username, &departname, &created)
//fmt.Println(username)
//fmt.Println(departname)
//fmt.Println(created) rows, err := db.Query("SELECT username,departname,created FROM userinfo WHERE username=?", "zhja")
checkErr(err)
for rows.Next() {
var username, departname, created string
if err := rows.Scan(&username, &departname, &created); err == nil {
fmt.Println(err)
}
fmt.Println(username)
fmt.Println(departname)
fmt.Println(created)
} tx, err := db.Begin()
checkErr(err)
stmt, err1 := tx.Prepare("INSERT INTO userinfo (username, departname, created) VALUES (?, ?, ?)")
checkErr(err1)
_, err2 := stmt.Exec("test", "测试", "2016-06-20")
checkErr(err2)
//err3 := tx.Commit()
err3 := tx.Rollback()
checkErr(err3)
} func checkErr(err error){
if err != nil {
panic(err)
}
}