2023-7mysql期末复习题.zip 327.19KB

2403_85962182

资源文件列表:

2023-7mysql期末复习题.zip 大约有7个文件

2023-7mysql期末复习题/操作复习题/
2023-7mysql期末复习题/操作复习题/2023：Mysql操作复习题.docx 16.93KB
2023-7mysql期末复习题/操作复习题/bookstore.sql 4.84KB
2023-7mysql期末复习题/操作复习题/xsgl.sql 2.48KB
2023-7mysql期末复习题/操作复习题/操作题参考答案.docx 303.2KB
2023-7mysql期末复习题/理论复习题.wps 39KB
2023-7mysql期末复习题/

资源介绍:

2023-7mysql期末复习题.zip

<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/90150415/2/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/90150415/bg1.jpg"/><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">《<span class="ff2 sc1">Mysql<span class="_ _0"> </span></span>数据库应<span class="_ _1"></span>用》期末<span class="_ _1"></span>复习题</div><div class="t m0 x2 h3 y2 ff1 fs1 fc0 sc0 ls0 ws0">适用班级：移<span class="_ _1"></span>动互联<span class="_ _2"> </span><span class="ff2 sc1">2101</span>、移动互联<span class="_ _2"> </span><span class="ff2 sc1">2102</span>、大数据技<span class="_ _1"></span>术<span class="_ _2"> </span><span class="ff2 sc1">2201</span>、智能控制<span class="_ _2"> </span><span class="ff2 sc1">2101</span></div><div class="t m0 x3 h4 y3 ff1 fs2 fc0 sc0 ls0 ws0">【总体要求】</div><div class="t m0 x3 h4 y4 ff1 fs2 fc0 sc0 ls0 ws0">按如下要求在<span class="_ _3"> </span><span class="ff2 sc1">navicat for mysql<span class="_ _2"> </span></span>界面中操<span class="_ _1"></span>作，<span class="_ _4"></span>把操作成功的<span class="_ _1"></span>命令截图，<span class="_ _4"></span>粘贴到<span class="_ _1"></span>题单</div><div class="t m0 x3 h4 y5 ff1 fs2 fc0 sc0 ls0 ws0">相应题目的下<span class="_ _1"></span>面。最后将本<span class="_ _1"></span>题单文件上<span class="_ _1"></span>传至考试卷中<span class="_ _1"></span>。</div><div class="t m0 x3 h5 y6 ff1 fs3 fc0 sc0 ls0 ws0">一、<span class="_"> </span>建库、建表<span class="_ _1"></span>、建约束</div><div class="t m0 x4 h4 y7 ff3 fs2 fc0 sc1 ls0 ws0">1<span class="ff4">、<span class="_ _2"> </span>创建名为”</span>xscj<span class="ff4">”数据库</span></div><div class="t m0 x4 h4 y8 ff3 fs2 fc0 sc1 ls0 ws0">2<span class="ff4">、<span class="_ _2"> </span>在<span class="_ _2"> </span></span>xscj<span class="_ _3"> </span><span class="ff4">数据库中创建表及表的约束</span></div><div class="t m0 x4 h4 y9 ff4 fs2 fc0 sc1 ls0 ws0">（<span class="ff3">1</span>）创建名为<span class="_ _2"> </span><span class="ff3">xs<span class="_ _2"> </span></span>的表</div><div class="t m0 x5 h4 ya ff4 fs2 fc0 sc1 ls0 ws0">表结构如下：</div><div class="c x6 yb w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">列名</div></div><div class="c x8 yb w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">类型</div></div><div class="c x9 yb w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">是否允许空值</div></div><div class="c xa yb w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">约束键</div></div><div class="c x6 yd w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">学号</div></div><div class="c x8 yd w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">字符串定长<span class="_ _2"> </span><span class="ff3">10</span></div></div><div class="c x9 yd w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">不允许</div></div><div class="c xa yd w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">主键</div></div><div class="c x6 ye w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">姓名</div></div><div class="c x8 ye w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">字符串变长<span class="_ _2"> </span><span class="ff3">20</span></div></div><div class="c x9 ye w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">不允许</div></div><div class="c x6 yf w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">出生日期</div></div><div class="c x8 yf w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">日期型</div></div><div class="c x9 yf w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">允许</div></div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,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/90150415/bg2.jpg"><div class="t m0 x4 h4 y10 ff4 fs2 fc0 sc1 ls0 ws0">（<span class="ff3">2</span>）创建名为<span class="_ _2"> </span><span class="ff3">kc<span class="_ _2"> </span></span>的表</div><div class="t m0 x5 h4 y11 ff4 fs2 fc0 sc1 ls0 ws0">表结构如下：</div><div class="c x6 y12 w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">列名</div></div><div class="c x8 y12 w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">类型及长度</div></div><div class="c x9 y12 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">是否允许空值</div></div><div class="c xa y12 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">约束键</div></div><div class="c x6 y13 w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">课程号</div></div><div class="c x8 y13 w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">字符串定长<span class="_ _2"> </span><span class="ff3">10</span></div></div><div class="c x9 y13 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">不允许</div></div><div class="c xa y13 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">主键</div></div><div class="c x6 y14 w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">课程名</div></div><div class="c x8 y14 w2 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">字符串变长<span class="_ _2"> </span><span class="ff3">20</span></div></div><div class="c x9 y14 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">不允许</div></div><div class="t m0 x4 h4 y15 ff4 fs2 fc0 sc1 ls0 ws0">（<span class="ff3">3</span>）创建名为<span class="_ _2"> </span><span class="ff3">cj<span class="_ _2"> </span></span>的表</div><div class="t m0 x5 h4 y16 ff4 fs2 fc0 sc1 ls0 ws0">表结构如下：</div><div class="c x6 y17 w4 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">列名</div></div><div class="c xb y17 w5 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">类型</div></div><div class="c x9 y17 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">是否允许空值</div></div><div class="c xa y17 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">约束键</div></div><div class="c x6 y18 w4 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">成绩编号</div></div><div class="c xb y18 w5 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">整形<span class="_ _2"> </span><span class="ff3">5</span></div></div><div class="c x9 y18 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">不允许</div></div><div class="c xa y18 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">主键</div></div><div class="c x6 y19 w4 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">学号</div></div><div class="c xb y19 w5 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">字符串定长<span class="_ _2"> </span><span class="ff3">10</span></div></div><div class="c x9 y19 w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">不允许</div></div><div class="c x6 y1a w4 h7"><div class="t m0 x7 h4 y1b ff4 fs2 fc0 sc1 ls0 ws0">课程号</div></div><div class="c xb y1a w5 h7"><div class="t m0 x7 h4 y1b ff4 fs2 fc0 sc1 ls0 ws0">字符串定长<span class="_ _2"> </span><span class="ff3">10</span></div></div><div class="c x9 y1a w3 h7"><div class="t m0 x7 h4 y1b ff4 fs2 fc0 sc1 ls0 ws0">不允许</div></div><div class="c xa y1a w3 h8"><div class="t m0 x7 h4 y1c ff4 fs2 fc0 sc1 ls0 ws0">外<span class="_ _1"></span>键<span class="_ _1"></span>：<span class="_ _1"></span>删<span class="_ _5"></span>除<span class="_ _1"></span>和<span class="_ _1"></span>修</div><div class="t m0 x7 h4 y1d ff4 fs2 fc0 sc1 ls0 ws0">改<span class="_ _6"> </span>都<span class="_ _6"> </span>设<span class="_ _6"> </span>定<span class="_ _6"> </span>为</div><div class="t m0 x7 h9 y1e ff3 fs2 fc0 sc1 ls0 ws0">cascade</div></div><div class="c x6 y1f w4 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">成绩</div></div><div class="c xb y1f w5 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">数值浮点型（<span class="ff3">4,1</span>）</div></div><div class="c x9 y1f w3 h6"><div class="t m0 x7 h4 yc ff4 fs2 fc0 sc1 ls0 ws0">允许</div></div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,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/90150415/bg3.jpg"><div class="t m0 x3 h5 y20 ff1 fs3 fc0 sc0 ls0 ws0">二、表数据<span class="_ _1"></span>的增、删、<span class="_ _1"></span>改操作</div><div class="t m0 x2 h4 y21 ff4 fs2 fc0 sc1 ls0 ws0">导入<span class="_ _2"> </span><span class="ff2">xsgl.sql<span class="_ _2"> </span></span>数据库，对其中的数据按如下要求进行更新操作</div><div class="t m0 x4 h4 y22 ff3 fs2 fc0 sc1 ls0 ws0">1<span class="ff4">、向表<span class="_ _2"> </span></span>student<span class="_ _3"> </span><span class="ff4">表中插入如下一行数据记录：</span></div><div class="t m0 xc h4 y23 ff3 fs2 fc0 sc1 ls0 ws0">006<span class="ff4">，王林，男，</span>2001-02-10<span class="ff4">，移动互联</span></div><div class="t m0 x4 h4 y24 ff3 fs2 fc0 sc1 ls0 ws0">2<span class="ff4">、替换学号为<span class="_ _2"> </span></span>006<span class="_ _2"> </span><span class="ff4">的记录值为</span></div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div>

100+评论昵称:

captcha

类型	标题	大小	时间
	Ziperello压缩包密码破解	1.25MB	4月前

	PDF解密工具（非常好用）	2.76MB	4月前
	windows自带防火墙卸载工具	193.43KB	4月前
	2_算法课课件.zip	20.18MB	4月前
	chromedriver-win32-133.0.6900.0.zip	8.31MB	4月前

	chromedriver-win32-133.0.6899.0.zip	8.34MB	4月前
	winf实验十(1).zip	6.32KB	4月前
	zj1111111111111111	1003B	4月前