mysql基础知识课件 21.49MB

qq_45688811需要积分:2(1积分=1元)

资源文件列表:

mysql基础课件pdf版.zip 大约有18个文件

第04章_运算符.pdf 2.25MB
第05章_排序与分页.pdf 255.71KB
第06章_多表查询.pdf 1.46MB
第07章_单行函数.pdf 1.47MB
第08章_聚合函数.pdf 528.77KB
第09章_子查询.pdf 563.27KB
第10章_创建和管理表.pdf 625.55KB
第11章_数据处理之增删改.pdf 516.84KB
第12章_MySQL数据类型精讲.pdf 1.19MB
第13章_约束.pdf 978.51KB
第14章_视图.pdf 603KB
第15章_存储过程与函数.pdf 567.64KB
第16章_变量、流程控制与游标.pdf 867.34KB
第17章_触发器.pdf 381.2KB
第18章_MySQL8其它新特性.pdf 1.1MB
第01章_数据库概述.pdf 3.58MB
第02章_MySQL环境搭建.pdf 5.87MB
第03章_基本的SELECT语句.pdf 655.5KB

资源介绍:

第01章_数据库概述.pdf 第02章_MySQL环境搭建.pdf 第03章_基本的SELECT语句.pdf 第04章_运算符.pdf 第05章_排序与分页.pdf 第06章_多表查询.pdf 第07章_单行函数.pdf 第08章_聚合函数.pdf 第09章_子查询.pdf 第10章_创建和管理表.pdf 第11章_数据处理之增删改.pdf 第12章_MySQL数据类型精讲.pdf 第13章_约束.pdf 第14章_视图.pdf 第15章_存储过程与函数.pdf 第16章_变量、流程控制与游标.pdf 第17章_触发器.pdf 第18章_MySQL8其它新特性.pdf

<link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89697664/raw.css" rel="stylesheet"/><div id="sidebar" style="display: none"><div id="outline"></div></div><div class="pf w0 h0" data-page-no="1" id="pf1"><div class="pc pc1 w0 h0"><img alt="" class="bi x0 y0 w1 h1" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89697664/bg1.jpg"/><div class="c x1 y1 w2 h2"><div class="t m0 x2 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">第<span class="ff2">02</span>章<span class="ff2">_MySQL</span>环境搭建<span class="_ _0"> </span><span class="ff2 fc1"> </span></div><div class="t m0 x2 h4 y3 ff3 fs1 fc0 sc0 ls0 ws0">讲师：尚硅谷<span class="ff4"> <span class="_ _1"></span></span>宋红康（江湖人称：康师傅）</div><div class="t m0 x2 h4 y4 ff3 fs1 fc0 sc0 ls0 ws0">官网：<span class="_ _2"> </span><span class="ff5 fc1">http://www<span class="_ _3"></span>.at<span class="_ _4"></span>guigu.c<span class="_ _4"></span>om</span></div><div class="t m0 x2 h5 y5 ff6 fs2 fc0 sc0 ls0 ws0">1. MySQL<span class="ff1">的卸载<span class="_ _5"> </span></span> </div><div class="t m0 x2 h6 y6 ff1 fs3 fc0 sc0 ls0 ws0">步骤<span class="ff7">1</span>：停止<span class="ff7">MySQL</span>服务<span class="_ _6"> </span><span class="ff7"> </span></div><div class="t m0 x2 h4 y7 ff3 fs1 fc0 sc0 ls0 ws0">在卸载之前，先停止<span class="ff4">MySQL8.0</span>的服务。按键盘上的<span class="ff4">“C<span class="_ _4"></span>trl <span class="_ _1"></span>+ <span class="_ _1"></span>Alt <span class="_ _1"></span>+ <span class="_ _1"></span>Delete<span class="_ _4"></span>”<span class="ff3">组合键，打开</span>“<span class="ff3">任务管理器</span>”<span class="ff3">对话</span></span></div><div class="t m0 x2 h4 y8 ff3 fs1 fc0 sc0 ls0 ws0">框，可以在<span class="ff4">“</span>服务<span class="ff4">”</span>列表找到<span class="ff4">“MySQL8.0”</span>的服务，如果现在<span class="ff4">“</span>正在运行<span class="ff4">”</span>状态，可以右键单击服务，选择<span class="ff4">“</span>停</div><div class="t m0 x2 h4 y9 ff3 fs1 fc0 sc0 ls0 ws0">止<span class="ff4">”</span>选项停止<span class="ff4">MySQL8.0</span>的服务，如图所示。</div><div class="t m0 x2 h6 ya ff1 fs3 fc0 sc0 ls0 ws0">步骤<span class="ff7">2</span>：软件的卸载<span class="_ _7"> </span><span class="ff7"> </span></div><div class="t m0 x3 h7 yb ff1 fs1 fc2 sc0 ls0 ws0">方式<span class="ff5">1</span>：通过控制面板方式</div><div class="t m0 x2 h4 yc ff3 fs1 fc0 sc0 ls0 ws0">卸载<span class="ff4">MySQL8.0</span>的程序可以和其他桌面应用程序一样直接在<span class="ff4">“</span>控制面板<span class="ff4">”</span>选择<span class="ff4">“</span>卸载程序<span class="ff4">”</span>，并在程序列表中</div><div class="t m0 x2 h4 yd ff3 fs1 fc0 sc0 ls0 ws0">找到<span class="ff4">MySQL8.0</span>服务器程序，直接双击卸载即可，如图所示。这种方式删除，数据目录下的数据不会跟着</div><div class="t m0 x2 h4 ye ff3 fs1 fc0 sc0 ls0 ws0">删除。</div></div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611792,0.000000,0.000000,1.611792,0.000000,0.000000]}'></div></div><div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89697664/bg2.jpg"><div class="c x1 y1 w2 h2"><div class="t m0 x3 h7 yf ff1 fs1 fc2 sc0 ls0 ws0">方式<span class="ff8">2</span>：通过<span class="ff8">360</span>或电脑管家等软件卸载</div><div class="t m0 x2 h4 y10 ff3 fs1 fc0 sc0 ls0 ws0">略</div><div class="t m0 x3 h7 y11 ff1 fs1 fc2 sc0 ls0 ws0">方式<span class="ff8">3</span>：通过安装包提供的卸载功能卸载</div><div class="t m0 x2 h4 y12 ff3 fs1 fc0 sc0 ls0 ws0">你也可以通过安装向导程序进行<span class="ff9">MySQL8.0</span>服务器程序的卸载。</div><div class="t m0 x2 h4 y13 ff3 fs1 fc0 sc0 ls0 ws0">①<span class="ff9"> <span class="_ _1"></span></span>再次双击下载的<span class="ff9">mysql-inst<span class="_ _4"></span>aller<span class="_ _4"></span>-c<span class="_ _4"></span>ommunity-8.0.26.0.msi<span class="ff3">文件，打开安装向导。安装向导会自动检测已</span></span></div><div class="t m0 x2 h4 y14 ff3 fs1 fc0 sc0 ls0 ws0">安装的<span class="ff9">MySQL</span>服务器程序。</div><div class="t m0 x2 h4 y15 ff3 fs1 fc0 sc0 ls0 ws0">②<span class="ff9"> <span class="_ _1"></span></span>选择要卸载的<span class="ff9">MySQL</span>服务器程序，单击<span class="ff9">“Remove<span class="_ _4"></span>”<span class="ff3">（移除），即可进行卸载。</span></span></div></div></div><div class="pi" data-data='{"ctm":[1.611792,0.000000,0.000000,1.611792,0.000000,0.000000]}'></div></div><div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89697664/bg3.jpg"><div class="c x1 y16 w2 h2"><div class="t m0 x2 h4 y17 ff3 fs1 fc0 sc0 ls0 ws0">③<span class="ffa"> <span class="_ _1"></span></span>单击<span class="ffa">“Nex<span class="_ _4"></span>t”<span class="ff3">（下一步）按钮，确认卸载。</span></span></div><div class="t m0 x2 h4 y18 ff3 fs1 fc0 sc0 ls0 ws0">④<span class="ffa"> <span class="_ _1"></span></span>弹出是否同时移除数据目录选择窗口。如果想要同时删除<span class="ffa">MySQL</span>服务器中的数据，则勾选<span class="ffa">“Remove <span class="_ _1"></span>the</span></div><div class="t m0 x2 h4 y19 ffa fs1 fc0 sc0 ls0 ws0">dat<span class="_ _4"></span>a <span class="_ _1"></span>direc<span class="_ _4"></span>tory”<span class="ff3">，如图所示。</span></div></div></div><div class="pi" data-data='{"ctm":[1.611792,0.000000,0.000000,1.611792,0.000000,0.000000]}'></div></div><div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89697664/bg4.jpg"><div class="c x1 y1a w2 h8"><div class="t m0 x2 h4 y1b ff3 fs1 fc0 sc0 ls0 ws0">⑤<span class="ffb"> <span class="_ _1"></span></span>执行卸载。单击<span class="ffb">“E<span class="_ _4"></span>xecut<span class="_ _4"></span>e”<span class="ff3">（执行）按钮进行卸载。</span></span></div><div class="t m0 x2 h4 y1c ff3 fs1 fc0 sc0 ls0 ws0">⑥<span class="ffb"> <span class="_ _1"></span></span>完成卸载。单击<span class="ffb">“Finish”</span>（完成）按钮即可。如果想要同时卸载<span class="ffb">MySQL8.0</span>的安装向导程序，勾选<span class="ffb">“Y<span class="_ _8"></span>es<span class="ff3">，</span></span></div><div class="t m0 x2 h4 y1d ffb fs1 fc0 sc0 ls0 ws0">Uninst<span class="_ _8"></span>all <span class="_ _1"></span>MySQL <span class="_ _1"></span>Inst<span class="_ _8"></span>aller<span class="_ _1"></span>”<span class="ff3">即可，如图所示。</span></div></div></div><div class="pi" data-data='{"ctm":[1.611792,0.000000,0.000000,1.611792,0.000000,0.000000]}'></div></div><div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89697664/bg5.jpg"><div class="c x1 y1a w2 h8"><div class="t m0 x2 h6 y1e ff1 fs3 fc0 sc0 ls0 ws0">步骤<span class="ffc">3</span>：残余文件的清理<span class="_ _9"> </span><span class="ffc"> </span></div><div class="t m0 x2 h4 y1f ff3 fs1 fc0 sc0 ls0 ws0">如果再次安装不成功，可以卸载后对残余文件进行清理后再安装。</div><div class="t m0 x2 h4 y20 ff3 fs1 fc0 sc0 ls0 ws0">（<span class="ffd">1</span>）服务目录：<span class="ffd">mysql</span>服务的安装目录</div><div class="t m0 x2 h4 y21 ff3 fs1 fc0 sc0 ls0 ws0">（<span class="ffd">2</span>）数据目录：默认在<span class="ffd">C:\Progr<span class="_ _8"></span>amData\MySQL</span></div><div class="t m0 x2 h4 y22 ff3 fs1 fc0 sc0 ls0 ws0">如果自己单独指定过数据目录，就找到自己的数据目录进行删除即可。</div><div class="t m0 x4 h4 y23 ff3 fs1 fc3 sc0 ls0 ws0">注意：请在卸载前做好数据备份</div><div class="t m0 x4 h4 y24 ff3 fs1 fc3 sc0 ls0 ws0">在操作完以后，需要重启计算机，然后进行安装即可。<span class="_ _a"></span><span class="ff1 fc2">如果仍然安装失败，需要继续操作如下步</span></div><div class="t m0 x4 h7 y25 ff1 fs1 fc2 sc0 ls0 ws0">骤<span class="ffe">4</span>。</div><div class="t m0 x2 h6 y26 ff1 fs3 fc0 sc0 ls0 ws0">步骤<span class="ffc">4</span>：清理注册表（选做）<span class="_ _b"> </span><span class="ffc"> </span></div><div class="t m0 x2 h4 y27 ff3 fs1 fc0 sc0 ls0 ws0">如果前几步做了，再次安装还是失败，那么可以清理注册表。</div><div class="t m0 x2 h4 y28 ff3 fs1 fc0 sc0 ls0 ws0">如何打开注册表编辑器：在系统的搜索框中输入<span class="_ _c"> </span><span class="fff fs4 fc4">regedit</span></div></div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611792,0.000000,0.000000,1.611792,0.000000,0.000000]}'></div></div>

100+评论昵称:

captcha

类型	标题	大小	时间
	图形化编程/Scratch角色素材分享21炸弹合集素材	884.19KB	8月前

	图形化编程/Scratch角色素材分享22战斗机合集素材	885.36KB	8月前
	图形化编程/Scratch角色素材分享24英文字母合集素材	1.06MB	8月前
	图形化编程/Scratch角色素材分享25各类小道具合集素材	1.35MB	8月前
	c++做的小游戏.zip	18.06KB	8月前

	java-fx17的sdk	46.07MB	8月前
	QT音乐播放器实战项目资源	4.24MB	8月前
	java 后端 class 修改编译文件	53.99MB	8月前