我的编程空间,编程开发者的网络收藏夹
学习永远不晚

【学生成绩管理】数据库示例数据(MySQL代码)

短信预约 -IT技能 免费直播动态提醒
省份

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号立即预约

请填写图片验证码后获取短信验证码

看不清楚,换张图片

免费获取短信验证码

【学生成绩管理】数据库示例数据(MySQL代码)

【学生成绩管理】数据库示例数据(MySQL代码)

一、创建数据库

mysql> drop database if exists mydb;Query OK, 5 rows affected (0.03 sec)mysql> create database mydb;Query OK, 1 row affected (0.00 sec)mysql> use mydb;Database changed

二、创建dept(学院)表

1、创建表结构
mysql> create table dept(    -> dept_id char(3) primary key,    -> dept_name char(50),    -> phone char(20),    -> address varchar(20)    -> );Query OK, 0 rows affected (0.01 sec)
2、添加示例数据
3、查看表中数据
mysql> select * from dept;+---------+--------------+--------------+----------------+| dept_id | dept_name    | phone        | address        |+---------+--------------+--------------+----------------+| D01     | 经济学院     | 0373-3025111 | 10号教学楼1101 || D02     | 管理学院     | 0373-3025122 | 12号教学楼602  || D03     | 生命科技学院 | 0373-3025133 | 8号教学楼204   || D04     | 农学院       | 0373-3025144 | 7号教学楼612   || D05     | 化工学院     | 0373-3025211 | 9号教学楼411   || D06     | 外国语学院   | 0373-3025222 | 6号教学楼312   || D07     | 数学学院     | 0373-3025333 | 5号教学楼205   || D08     | 文法学院     | 0373-3025555 | 0号教学楼703   || D09     | 教育学院     | 0373-3025666 | 11号教学楼806  || D10     | 艺术学院     | 0373-3025999 | 13号教学楼605  |+---------+--------------+--------------+----------------+10 rows in set (0.00 sec)

三、创建stu(学生)表

1、创建表结构
mysql> create table stu(    -> s_id char(11) primary key,    -> s_name char(20),    -> gender char(2),    -> birth date,    -> phone char(20),    -> dept_id char(3),    -> foreign key(dept_id) references dept(dept_id)    -> );Query OK, 0 rows affected (0.01 sec)
2、添加示例数据
3、查看表中数据
mysql> select * from stu;+-------------+--------+--------+------------+-------------+---------+| s_id        | s_name | gender | birth      | phone       | dept_id |+-------------+--------+--------+------------+-------------+---------+| 20220124001 | 薛智玲 || 2000-01-15 | 13637358097 | D01     || 20220124002 | 杨铭华 || 2001-03-06 | 13637381407 | D01     || 20220124003 | 张从超 || 2003-12-09 | 13637389129 | D01     || 20220124004 | 孙金航 || 2003-03-07 | 13637387244 | D01     || 20220124005 | 张赞聪 || 2002-11-10 | 13637346329 | D01     || 20220124006 | 陈柏媛 || 2003-07-18 | 13637357663 | D01     || 20220124007 | 赵俊彦 || 2003-05-15 | 13637356250 | D01     || 20220124008 | 饶麒圭 || 2003-08-13 | 13637354890 | D01     || 20220124009 | 刘旭俊 || 2002-06-05 | 13637385794 | D01     || 20220124010 | 许滟钗 || 2001-10-19 | 13637343935 | D01     || 20220124011 | 刘弈俊 || 2003-07-15 | 13637317133 | D01     || 20220124012 | 李耀炫 || 2002-05-08 | 13637315100 | D01     || 20220124013 | 单新阳 || 2004-09-26 | 13637312764 | D01     || 20220214001 | 谭宝名 || 2002-08-05 | 13637332439 | D02     || 20220214002 | 赵文瀚 || 2001-03-25 | 13637381710 | D02     || 20220214003 | 裴天馨 || 2003-04-15 | 13637381374 | D02     || 20220214004 | 董天邦 || 2000-02-18 | 13637317690 | D02     || 20220214005 | 李振彬 || 2001-03-28 | 13637355457 | D02     || 20220214006 | 钱鹏琪 || 2003-10-27 | 13637318606 | D02     || 20220214007 | 陈翡   || 2001-10-17 | 13637318317 | D02     || 20220214008 | 葛伟花 || 2004-08-03 | 13637367011 | D02     || 20220214009 | 吴馨瑞 || 2002-01-16 | 13637333823 | D02     || 20220214010 | 王惠基 || 2001-10-02 | 13637371200 | D02     || 20220214011 | 龚海珂 || 2004-12-08 | 13637360494 | D02     || 20220214012 | 韩凤仿 || 2002-02-22 | 13637390290 | D02     || 20220214013 | 马明杰 || 2000-02-10 | 13637347762 | D02     || 20220214014 | 覃柄苑 || 2003-02-20 | 13637319961 | D02     || 20220325101 | 董雯林 || 2003-12-27 | 13637357085 | D03     || 20220325102 | 周宜可 || 2002-07-04 | 13637333898 | D03     || 20220325103 | 张春晶 || 2001-06-21 | 13637340698 | D03     || 20220325104 | 曹哓明 || 2001-12-13 | 13637351720 | D03     || 20220325105 | 王泰骧 || 2001-10-07 | 13637377971 | D03     || 20220325106 | 黄雍军 || 2000-09-01 | 13637342838 | D03     || 20220325107 | 周聪   || 2003-11-17 | 13637320247 | D03     || 20220325108 | 段义华 || 2001-05-06 | 13637343972 | D03     || 20220325109 | 唐金琴 || 2001-01-11 | 13637329007 | D03     || 20220325110 | 谭榕   || 2002-04-19 | 13637349912 | D03     || 20220325111 | 吴文真 || 2003-04-18 | 13637354698 | D03     || 20220325112 | 彭志丹 || 2001-01-12 | 13637391633 | D03     || 20220325113 | 古鹏为 || 2001-08-05 | 13637355739 | D03     || 20220325114 | 薛玉龙 || 2003-07-11 | 13637349887 | D03     || 20220410101 | 夏飞研 || 2002-09-02 | 13637326693 | D04     || 20220410102 | 聂小龙 || 2002-12-04 | 13637331432 | D04     || 20220410103 | 赵晨祥 || 2002-05-22 | 13637388564 | D04     || 20220410104 | 江沐洪 || 2002-02-12 | 13637345052 | D04     || 20220410105 | 潘玟君 || 2001-05-02 | 13637383612 | D04     || 20220410106 | 段奕宏 || 2004-10-14 | 13637382026 | D04     || 20220410107 | 肖青枝 || 2001-08-05 | 13637319418 | D04     || 20220410108 | 李昕泽 || 2002-07-07 | 13637389104 | D04     || 20220410109 | 田晓宇 || 2003-07-05 | 13637357040 | D04     || 20220410110 | 李昌镐 || 2001-05-17 | 13637382453 | D04     || 20220410111 | 刘长浩 || 2002-09-22 | 13637379833 | D04     || 20220410112 | 梁文音 || 2000-06-08 | 13637338905 | D04     || 20220410113 | 李博宇 || 2000-02-09 | 13637364489 | D04     || 20220410114 | 彭靖开 || 2004-11-09 | 13637341846 | D04     || 20220410115 | 侯弈劭 || 2003-10-10 | 13637365164 | D04     || 20220410116 | 陈美西 || 2003-04-06 | 13637386537 | D04     || 20220522101 | 王俊博 || 2003-09-08 | 13637328551 | D05     || 20220522102 | 阮建惠 || 2003-05-09 | 13637356754 | D05     || 20220522103 | 高炫开 || 2000-06-16 | 13637361567 | D05     || 20220522104 | 粱宣景 || 2001-04-14 | 13637354909 | D05     || 20220522105 | 蔡思迪 || 2001-10-10 | 13637326462 | D05     || 20220522106 | 宋昶钦 || 2001-07-11 | 13637337840 | D05     || 20220522107 | 沈厚捷 || 2003-11-11 | 13637358553 | D05     || 20220522108 | 董彦舒 || 2003-02-22 | 13637323877 | D05     || 20220522109 | 姜俞然 || 2003-10-07 | 13637385118 | D05     || 20220522110 | 龚军皓 || 2001-06-07 | 13637364996 | D05     || 20220522111 | 丘玟涵 || 2002-01-25 | 13637319822 | D05     || 20220522112 | 冯奕焜 || 2001-04-03 | 13637361185 | D05     || 20220522113 | 康弈琇 || 2002-01-13 | 13637349947 | D05     || 20220522114 | 贺垚珺 || 2004-09-17 | 13637377303 | D05     || 20220522115 | 夏冠尧 || 2000-05-21 | 13637387222 | D05     || 20220522116 | 严拓斐 || 2001-04-16 | 13637339832 | D05     || 20220610101 | 廖亮喻 || 2004-11-20 | 13637367768 | D06     || 20220610102 | 贺勇杰 || 2002-11-03 | 13637346860 | D06     || 20220610103 | 陶波韧 || 2003-11-21 | 13637380211 | D06     || 20220610104 | 阎飞为 || 2000-09-16 | 13637335583 | D06     || 20220610105 | 郭昱皓 || 2002-06-27 | 13637386149 | D06     || 20220610106 | 孟俊钦 || 2004-11-27 | 13637345788 | D06     || 20220610107 | 牛军焜 || 2003-11-19 | 13637373857 | D06     || 20220610108 | 周奕博 || 2000-11-07 | 13637373974 | D06     || 20220610109 | 邓弈迪 || 2000-09-08 | 13637359764 | D06     || 20220610110 | 许思韧 || 2001-08-01 | 13637373482 | D06     || 20220610111 | 胡宣为 || 2002-02-27 | 13637372561 | D06     || 20220610112 | 习炫渊 || 2000-03-08 | 13637342032 | D06     || 20220610113 | 汤昶捷 || 2000-05-11 | 13637359714 | D06     || 20220610114 | 莫俞惠 || 2000-05-26 | 13637381480 | D06     || 20220610115 | 朱彦竣 || 2002-07-14 | 13637386772 | D06     || 20220610116 | 杜建轶 || 2001-07-06 | 13637328733 | D06     || 20220610117 | 马厚策 || 2003-11-09 | 13637364688 | D06     || 20220610118 | 庞拓景 || 2002-04-06 | 13637378295 | D06     || 20220714101 | 何玺皓 || 2001-02-13 | 13637324918 | D07     || 20220714102 | 凌韬博 || 2001-08-26 | 13637369542 | D07     || 20220714103 | 白烁渊 || 2002-06-10 | 13637337634 | D07     || 20220714104 | 姚际惠 || 2001-07-24 | 13637316005 | D07     || 20220714105 | 伊韵迪 || 2002-07-26 | 13637367799 | D07     || 20220714106 | 秦卓珈 || 2002-10-08 | 13637377879 | D07     || 20220714107 | 韩一芳 || 2001-01-28 | 13637384835 | D07     || 20220714108 | 刘志宝 || 2001-09-10 | 13637373444 | D07     || 20220714109 | 申莹洋 || 2003-04-26 | 13637388716 | D07     || 20220714110 | 周岚青 || 2003-03-15 | 13637367051 | D07     || 20220714111 | 徐如华 || 2000-04-03 | 13637388342 | D07     || 20220714112 | 张淑馨 || 2004-02-19 | 13637336095 | D07     || 20220714113 | 郭银汝 || 2001-04-19 | 13637356116 | D07     || 20220714114 | 屈语盼 || 2004-09-28 | 13637360546 | D07     || 20220714115 | 柳泳辉 || 2003-04-14 | 13637316131 | D07     || 20220714116 | 王语勇 || 2000-07-09 | 13637381460 | D07     || 20220820101 | 陶颢瑶 || 2002-02-20 | 13637385998 | D08     || 20220820102 | 许丽生 || 2004-04-16 | 13637357115 | D08     || 20220820103 | 张欣盛 || 2002-04-25 | 13637357139 | D08     || 20220820104 | 李士浚 || 2001-09-11 | 13637321159 | D08     || 20220820105 | 王瑜铭 || 2000-02-14 | 13637314225 | D08     || 20220820106 | 邹家轩 || 2001-11-22 | 13637337596 | D08     || 20220820107 | 向靖辉 || 2000-03-04 | 13637382013 | D08     || 20220820108 | 肖浩平 || 2004-06-28 | 13637331655 | D08     || 20220820109 | 张菲丽 || 2004-02-06 | 13637318255 | D08     || 20220820110 | 王安青 || 2004-10-14 | 13637381170 | D08     || 20220930111 | 周星利 || 2001-05-26 | 13637331407 | D09     || 20220930112 | 张鸣云 || 2004-02-20 | 13637330474 | D09     || 20220930113 | 纪冉久 || 2003-03-03 | 13637313600 | D09     || 20220930114 | 贾炳麟 || 2003-02-12 | 13637350928 | D09     || 20220930115 | 陈丽濠 || 2003-03-28 | 13637376055 | D09     || 20220930116 | 喻武琰 || 2000-05-17 | 13637312126 | D09     || 20220930117 | 涂彩珩 || 2001-03-20 | 13637321286 | D09     || 20220930118 | 冉惠弘 || 2003-03-03 | 13637313899 | D09     || 20220930119 | 王雪凡 || 2003-03-11 | 13637360598 | D09     || 20220930120 | 陈露程 || 2001-10-07 | 13637345077 | D09     || 20220930121 | 曾嘉伊 || 2002-09-03 | 13637323247 | D09     || 20220930122 | 申仔霁 || 2000-07-21 | 13637357170 | D09     || 20220930123 | 刘炫玉 || 2002-10-16 | 13637364086 | D09     || 20220930124 | 钟仁婷 || 2003-09-15 | 13637379257 | D09     || 20220930125 | 吴姗峰 || 2002-11-18 | 13637350770 | D09     || 20220930126 | 刘姿凡 || 2003-08-02 | 13637315098 | D09     || 20220930127 | 林晓凤 || 2000-11-19 | 13637347620 | D09     || 20220930128 | 赵翊祺 || 2002-08-24 | 13637364551 | D09     || 20221012101 | 白建屏 || 2002-10-05 | 13637345427 | D10     || 20221012102 | 魏恬伟 || 2000-10-14 | 13637383372 | D10     || 20221012103 | 葛卓涵 || 2000-02-13 | 13637387435 | D10     || 20221012104 | 蒋玉东 || 2001-04-05 | 13637314258 | D10     || 20221012105 | 曾莘琳 || 2004-09-25 | 13637363443 | D10     || 20221012106 | 胡本洱 || 2001-10-02 | 13637362524 | D10     || 20221012107 | 高芳宇 || 2003-04-26 | 13637315050 | D10     || 20221012108 | 卢琛平 || 2003-03-11 | 13637316052 | D10     || 20221012109 | 魏宗灵 || 2002-05-13 | 13637346458 | D10     || 20221012110 | 唐丽冰 || 2004-05-19 | 13637324777 | D10     || 20221012111 | 龚修东 || 2004-11-08 | 13637358603 | D10     || 20221012112 | 庞新涵 || 2003-03-17 | 13637318266 | D10     || 20221012113 | 方键   || 2000-07-21 | 13637318190 | D10     || 20221012114 | 汤豫毅 || 2004-03-02 | 13637376468 | D10     || 20221012115 | 龚照东 || 2001-09-08 | 13637378473 | D10     || 20221012116 | 周二智 || 2001-10-28 | 13637353275 | D10     || 20221012117 | 刘昊恒 || 2004-04-12 | 13637384973 | D10     || 20221012118 | 徐川廷 || 2003-06-26 | 13637327921 | D10     || 20221012119 | 阎栖晨 || 2002-01-22 | 13637374839 | D10     || 20221012120 | 颜子洋 || 2001-02-06 | 13637331614 | D10     || 20221012121 | 李俊威 || 2003-03-19 | 13637379108 | D10     || 20221012122 | 任玉罕 || 2001-02-15 | 13637376859 | D10     || 20221012123 | 黄莱赫 || 2002-11-13 | 13637360030 | D10     || 20221012124 | 方欣英 || 2004-04-26 | 13637343776 | D10     || 20221012125 | 李凌添 || 2002-08-10 | 13637352757 | D10     || 20221012126 | 余玉一 || 2002-02-01 | 13637316981 | D10     || 20221012127 | 吴熙达 || 2003-02-07 | 13637377512 | D10     |+-------------+--------+--------+------------+-------------+---------+162 rows in set (0.00 sec)

四、创建course(课程)表

1、创建表结构
mysql> create table course(    -> c_id char(6) primary key,    -> c_name char(50),    -> credit decimal(4,2)    -> );Query OK, 0 rows affected (0.01 sec)
2、添加示例数据
3、查看表中数据
mysql> select * from course;+--------+----------------+--------+| c_id   | c_name         | credit |+--------+----------------+--------+| C01001 | 微观经济学     |   4.00 || C01002 | 宏观经济学     |   3.00 || C01003 | 财务管理       |   3.00 || C01004 | 计量经济学     |   4.00 || C01005 | 数据分析       |   4.00 || C01006 | 大数据概论     |   4.00 || C02101 | 企业管理概论   |   3.00 || C02102 | 管理学原理     |   3.00 || C02103 | 管理信息系统   |   4.00 || C02104 | 数据库系统原理 |   3.00 || C02105 | 信息组织       |   3.00 || C03201 | 遗传学         |   3.00 || C03202 | 药物学         |   3.00 || C03203 | 药理学         |   3.00 || C04111 | 农业环境学     |   3.00 || C04112 | 土壤肥料学     |   4.00 || C04113 | 作物学         |   4.00 || C04114 | 植物学         |   4.00 || C04115 | 病虫害防治     |   3.00 || C05121 | 无机化学       |   3.00 || C05122 | 有机化学       |   3.00 || C05123 | 生理学         |   3.00 || C05124 | 生物化学       |   3.00 || C06311 | 大学英语       |   4.00 || C06312 | 翻译           |   4.00 || C06313 | 外国语言文学   |   4.00 || C06314 | 英语语法       |   3.00 || C06315 | 日语           |   2.00 || C06316 | 法语           |   2.00 || C06317 | 俄语           |   2.00 || C07111 | 线性代数       |   3.00 || C07112 | 高等数学       |   3.00 || C07113 | 运筹学         |   4.00 || C07114 | 概率与数理统计 |   4.00 || C07115 | 离散数学       |   4.00 || C07116 | 复变函数       |   3.00 || C08101 | 古代汉语       |   3.00 || C08102 | 现代汉语       |   2.00 || C08103 | 诗歌           |   3.00 || C08104 | 刑法           |   2.00 || C08105 | 民法           |   3.00 || C08106 | 行政诉讼法     |   3.00 || C08107 | 刑事诉讼法     |   4.00 || C09111 | 心理学         |   3.00 || C09112 | 教育学         |   2.00 || C09113 | 幼儿心理学     |   3.00 || C10121 | 音乐           |   4.00 || C10122 | 书法           |   2.00 || C10123 | 舞蹈           |   4.00 || C10124 | 钢琴           |   2.00 || C10125 | 电子琴         |   2.00 |+--------+----------------+--------+51 rows in set (0.00 sec)

四、创建xk(选课)表

1、创建表结构
mysql> create table xk(    -> s_id char(11),    -> c_id char(6),    -> score decimal(5,2),    -> primary key(s_id,c_id),    -> foreign key(s_id) references stu(s_id),    -> foreign key(c_id) references course(c_id)    -> );Query OK, 0 rows affected (0.01 sec)
2、添加示例数据
3、查看表中的数据如下
mysql> select * from xk;+-------------+--------+--------+| s_id        | c_id   | score  |+-------------+--------+--------+| 20220124001 | C01001 |  63.00 || 20220124001 | C01002 |  68.00 || 20220124001 | C01003 |  92.00 || 20220124001 | C01004 |  99.00 || 20220124001 | C01005 |  72.00 || 20220124001 | C01006 |  97.00 || 20220124002 | C01001 |  88.00 || 20220124002 | C01002 |  69.00 || 20220124002 | C01003 |  69.00 || 20220124002 | C01004 |  97.00 || 20220124002 | C01005 |  77.00 || 20220124002 | C01006 |  80.00 || 20220124003 | C01001 |  95.00 || 20220124003 | C01003 |  94.00 || 20220124003 | C01004 |  68.00 || 20220124003 | C01005 |  76.00 || 20220124003 | C01006 |  65.00 || 20220124004 | C01001 |  81.00 || 20220124004 | C01003 |  96.00 || 20220124004 | C01004 |  90.00 || 20220124004 | C01005 |  99.00 || 20220124004 | C01006 |  79.00 || 20220124005 | C01001 |  88.00 || 20220124005 | C01003 |  69.00 || 20220124005 | C01004 |  70.00 || 20220124005 | C01005 |  95.00 || 20220124005 | C01006 |  77.00 || 20220124006 | C01001 |  90.00 || 20220124006 | C01004 |  77.00 || 20220124006 | C01005 |  63.00 || 20220124007 | C01001 |  71.00 || 20220124007 | C01002 |  74.00 || 20220124007 | C01004 |  61.00 || 20220124007 | C01005 |  97.00 || 20220124008 | C01001 |  94.00 || 20220124008 | C01002 |  72.00 || 20220124008 | C01004 |  83.00 || 20220124008 | C01005 |  76.00 || 20220124009 | C01001 |  86.00 || 20220124009 | C01002 |  79.00 || 20220124009 | C01004 |  79.00 || 20220124009 | C01005 |  60.00 || 20220124010 | C01001 |  82.00 || 20220124010 | C01002 |  61.00 || 20220124010 | C01003 |  93.00 || 20220124010 | C01004 |  62.00 || 20220124010 | C01005 | 100.00 || 20220124010 | C01006 |  80.00 || 20220124011 | C01001 |  96.00 || 20220124011 | C01002 |  63.00 || 20220124011 | C01003 |  72.00 || 20220124011 | C01004 |  66.00 || 20220124011 | C01005 |  81.00 || 20220124011 | C01006 |  95.00 || 20220124012 | C01001 | 100.00 || 20220124012 | C01002 |  93.00 || 20220124012 | C01003 |  99.00 || 20220124012 | C01004 |  87.00 || 20220124012 | C01005 |  97.00 || 20220124012 | C01006 |  83.00 || 20220124013 | C01001 |  92.00 || 20220124013 | C01002 |  97.00 || 20220124013 | C01003 |  98.00 || 20220124013 | C01004 |  88.00 || 20220124013 | C01005 |  97.00 || 20220124013 | C01006 |  88.00 || 20220214001 | C02101 |  80.00 || 20220214001 | C02102 |  80.00 || 20220214001 | C02103 |  97.00 || 20220214001 | C02104 |  96.00 || 20220214001 | C02105 |  82.00 || 20220214002 | C02101 |  63.00 || 20220214002 | C02102 |  67.00 || 20220214002 | C02103 |  74.00 || 20220214002 | C02104 |  79.00 || 20220214002 | C02105 |  65.00 || 20220214003 | C02101 |  72.00 || 20220214003 | C02102 |  96.00 || 20220214003 | C02103 |  94.00 || 20220214003 | C02104 |  93.00 || 20220214003 | C02105 |  67.00 || 20220214004 | C02101 |  77.00 || 20220214004 | C02103 |  65.00 || 20220214004 | C02104 |  73.00 || 20220214004 | C02105 |  81.00 || 20220214005 | C02101 |  89.00 || 20220214005 | C02103 |  76.00 || 20220214005 | C02104 |  67.00 || 20220214006 | C02101 |  74.00 || 20220214006 | C02103 |  63.00 || 20220214006 | C02104 |  85.00 || 20220214007 | C02101 |  65.00 || 20220214007 | C02103 |  92.00 || 20220214007 | C02104 |  62.00 || 20220214008 | C02101 |  70.00 || 20220214008 | C02103 |  86.00 || 20220214008 | C02104 |  70.00 || 20220214009 | C02101 |  90.00 || 20220214009 | C02102 |  71.00 || 20220214009 | C02103 |  76.00 || 20220214009 | C02104 |  84.00 || 20220214009 | C02105 |  77.00 || 20220214010 | C02101 |  99.00 || 20220214010 | C02102 |  80.00 || 20220214010 | C02103 |  62.00 || 20220214010 | C02104 |  73.00 || 20220214010 | C02105 |  75.00 || 20220214011 | C02101 |  88.00 || 20220214011 | C02102 |  61.00 || 20220214011 | C02103 |  72.00 || 20220214011 | C02104 | 100.00 || 20220214011 | C02105 |  87.00 || 20220214012 | C02101 |  95.00 || 20220214012 | C02102 |  64.00 || 20220214012 | C02104 |  89.00 || 20220214012 | C02105 |  70.00 || 20220214013 | C02101 |  93.00 || 20220214013 | C02102 |  69.00 || 20220214013 | C02104 |  73.00 || 20220214013 | C02105 |  82.00 || 20220214014 | C02101 |  68.00 || 20220214014 | C02102 |  80.00 || 20220214014 | C02104 |  86.00 || 20220214014 | C02105 |  75.00 || 20220325101 | C03201 |  83.00 || 20220325101 | C03202 |  83.00 || 20220325101 | C03203 |  74.00 || 20220325102 | C03201 |  90.00 || 20220325102 | C03202 |  84.00 || 20220325102 | C03203 |  67.00 || 20220325103 | C03201 |  65.00 || 20220325103 | C03202 |  77.00 || 20220325103 | C03203 |  66.00 || 20220325104 | C03201 |  86.00 || 20220325104 | C03202 |  87.00 || 20220325104 | C03203 |  81.00 || 20220325105 | C03201 |  68.00 || 20220325105 | C03202 |  70.00 || 20220325105 | C03203 |  94.00 || 20220325106 | C03201 |  65.00 || 20220325106 | C03202 |  87.00 || 20220325107 | C03201 |  86.00 || 20220325107 | C03202 |  82.00 || 20220325108 | C03201 |  72.00 || 20220325108 | C03202 |  84.00 || 20220325109 | C03201 |  91.00 || 20220325109 | C03202 |  99.00 || 20220325110 | C03201 |  90.00 || 20220325110 | C03202 |  87.00 || 20220325110 | C03203 |  64.00 || 20220325111 | C03201 |  92.00 || 20220325111 | C03202 |  76.00 || 20220325111 | C03203 |  97.00 || 20220325112 | C03201 |  96.00 || 20220325112 | C03202 |  94.00 || 20220325112 | C03203 |  68.00 || 20220325113 | C03201 |  84.00 || 20220325113 | C03202 |  66.00 || 20220325113 | C03203 |  69.00 || 20220325114 | C03201 |  94.00 || 20220325114 | C03202 |  99.00 || 20220325114 | C03203 |  67.00 || 20220410101 | C04111 |  68.00 || 20220410101 | C04112 |  97.00 || 20220410101 | C04113 |  83.00 || 20220410101 | C04114 | 100.00 || 20220410101 | C04115 |  81.00 || 20220410102 | C04111 |  62.00 || 20220410102 | C04112 |  78.00 || 20220410102 | C04113 |  72.00 || 20220410102 | C04114 |  72.00 || 20220410102 | C04115 |  97.00 || 20220410103 | C04111 |  64.00 || 20220410103 | C04112 |  82.00 || 20220410103 | C04113 |  62.00 || 20220410103 | C04115 |  97.00 || 20220410104 | C04111 |  64.00 || 20220410104 | C04112 |  75.00 || 20220410104 | C04115 |  78.00 || 20220410105 | C04111 |  92.00 || 20220410105 | C04112 | 100.00 || 20220410105 | C04115 |  76.00 || 20220410106 | C04111 |  75.00 || 20220410106 | C04112 |  73.00 || 20220410107 | C04111 |  63.00 || 20220410107 | C04112 |  65.00 || 20220410107 | C04114 |  97.00 || 20220410108 | C04111 |  61.00 || 20220410108 | C04112 |  96.00 || 20220410108 | C04114 |  63.00 || 20220410109 | C04111 |  89.00 || 20220410109 | C04112 |  96.00 || 20220410109 | C04113 |  70.00 || 20220410109 | C04114 |  86.00 || 20220410110 | C04111 |  81.00 || 20220410110 | C04112 |  70.00 || 20220410110 | C04113 |  61.00 || 20220410110 | C04114 |  84.00 || 20220410110 | C04115 |  66.00 || 20220410111 | C04111 |  85.00 || 20220410111 | C04112 |  69.00 || 20220410111 | C04113 |  84.00 || 20220410111 | C04114 |  96.00 || 20220410111 | C04115 |  70.00 || 20220410112 | C04111 |  72.00 || 20220410112 | C04112 |  62.00 || 20220410112 | C04113 |  98.00 || 20220410112 | C04114 |  90.00 || 20220410112 | C04115 |  62.00 || 20220410113 | C04111 |  61.00 || 20220410113 | C04112 |  98.00 || 20220410113 | C04113 |  75.00 || 20220410113 | C04114 |  95.00 || 20220410113 | C04115 |  75.00 || 20220410114 | C04111 |  89.00 || 20220410114 | C04112 |  98.00 || 20220410114 | C04113 |  71.00 || 20220410114 | C04114 |  62.00 || 20220410114 | C04115 |  76.00 || 20220410115 | C04111 |  72.00 || 20220410115 | C04112 |  92.00 || 20220410115 | C04113 |  71.00 || 20220410115 | C04114 |  60.00 || 20220410115 | C04115 |  80.00 || 20220410116 | C04111 |  74.00 || 20220410116 | C04112 |  95.00 || 20220410116 | C04113 |  63.00 || 20220410116 | C04114 |  65.00 || 20220410116 | C04115 |  98.00 || 20220522101 | C05121 |  73.00 || 20220522101 | C05122 |  88.00 || 20220522101 | C05123 |  72.00 || 20220522101 | C05124 |  94.00 || 20220522102 | C05121 |  77.00 || 20220522102 | C05122 |  61.00 || 20220522102 | C05123 |  92.00 || 20220522102 | C05124 |  63.00 || 20220522103 | C05121 |  77.00 || 20220522103 | C05124 |  66.00 || 20220522104 | C05121 |  61.00 || 20220522104 | C05124 |  60.00 || 20220522105 | C05121 |  94.00 || 20220522105 | C05124 | 100.00 || 20220522106 | C05121 |  78.00 || 20220522107 | C05121 |  80.00 || 20220522107 | C05122 |  73.00 || 20220522108 | C05121 |  63.00 || 20220522108 | C05122 |  65.00 || 20220522108 | C05123 |  98.00 || 20220522109 | C05121 |  72.00 || 20220522109 | C05122 |  84.00 || 20220522109 | C05123 |  62.00 || 20220522109 | C05124 |  64.00 || 20220522110 | C05121 |  92.00 || 20220522110 | C05122 |  83.00 || 20220522110 | C05123 |  69.00 || 20220522110 | C05124 |  98.00 || 20220522111 | C05121 |  77.00 || 20220522111 | C05122 |  70.00 || 20220522111 | C05123 |  70.00 || 20220522111 | C05124 |  64.00 || 20220522112 | C05121 |  62.00 || 20220522112 | C05122 |  97.00 || 20220522112 | C05123 |  99.00 || 20220522112 | C05124 |  93.00 || 20220522113 | C05121 |  94.00 || 20220522113 | C05122 |  66.00 || 20220522113 | C05123 |  73.00 || 20220522113 | C05124 |  95.00 || 20220522114 | C05121 |  74.00 || 20220522114 | C05122 |  91.00 || 20220522114 | C05123 |  70.00 || 20220522114 | C05124 |  65.00 || 20220522115 | C05121 |  98.00 || 20220522115 | C05122 |  84.00 || 20220522115 | C05123 |  62.00 || 20220522115 | C05124 |  79.00 || 20220522116 | C05121 |  65.00 || 20220522116 | C05122 |  63.00 || 20220522116 | C05123 |  77.00 || 20220522116 | C05124 |  68.00 || 20220610101 | C06311 |  90.00 || 20220610101 | C06312 |  93.00 || 20220610101 | C06314 |  72.00 || 20220610101 | C06315 |  72.00 || 20220610101 | C06317 |  86.00 || 20220610102 | C06311 |  73.00 || 20220610102 | C06312 |  75.00 || 20220610102 | C06314 |  99.00 || 20220610102 | C06315 |  87.00 || 20220610102 | C06317 |  78.00 || 20220610103 | C06311 |  82.00 || 20220610103 | C06312 |  80.00 || 20220610103 | C06314 |  80.00 || 20220610103 | C06315 |  99.00 || 20220610103 | C06316 |  69.00 || 20220610103 | C06317 |  64.00 || 20220610104 | C06311 |  94.00 || 20220610104 | C06312 |  80.00 || 20220610104 | C06314 |  91.00 || 20220610104 | C06315 |  68.00 || 20220610104 | C06316 |  71.00 || 20220610104 | C06317 |  76.00 || 20220610105 | C06311 |  60.00 || 20220610105 | C06312 |  88.00 || 20220610105 | C06314 |  66.00 || 20220610105 | C06315 |  61.00 || 20220610105 | C06316 |  80.00 || 20220610105 | C06317 |  68.00 || 20220610106 | C06311 |  65.00 || 20220610106 | C06312 |  85.00 || 20220610106 | C06313 |  71.00 || 20220610106 | C06314 |  70.00 || 20220610106 | C06315 |  70.00 || 20220610106 | C06316 |  70.00 || 20220610107 | C06311 |  68.00 || 20220610107 | C06312 |  91.00 || 20220610107 | C06313 |  90.00 || 20220610107 | C06314 |  67.00 || 20220610107 | C06315 |  63.00 || 20220610107 | C06316 |  91.00 || 20220610108 | C06311 |  93.00 || 20220610108 | C06312 |  82.00 || 20220610108 | C06313 | 100.00 || 20220610108 | C06314 |  84.00 || 20220610108 | C06315 |  78.00 || 20220610108 | C06316 |  90.00 || 20220610109 | C06311 |  65.00 || 20220610109 | C06312 |  71.00 || 20220610109 | C06313 |  82.00 || 20220610109 | C06314 |  61.00 || 20220610109 | C06315 |  95.00 || 20220610109 | C06316 |  75.00 || 20220610110 | C06311 |  70.00 || 20220610110 | C06312 |  71.00 || 20220610110 | C06313 |  94.00 || 20220610110 | C06314 |  75.00 || 20220610110 | C06315 |  75.00 || 20220610110 | C06316 |  66.00 || 20220610111 | C06311 |  91.00 || 20220610111 | C06312 |  75.00 || 20220610111 | C06313 |  89.00 || 20220610111 | C06314 |  64.00 || 20220610111 | C06315 |  63.00 || 20220610111 | C06316 |  77.00 || 20220610111 | C06317 |  61.00 || 20220610112 | C06311 |  76.00 || 20220610112 | C06312 |  70.00 || 20220610112 | C06313 |  78.00 || 20220610112 | C06315 |  98.00 || 20220610112 | C06316 |  79.00 || 20220610112 | C06317 |  92.00 || 20220610113 | C06311 |  90.00 || 20220610113 | C06312 |  69.00 || 20220610113 | C06313 |  68.00 || 20220610113 | C06315 |  87.00 || 20220610113 | C06316 |  96.00 || 20220610113 | C06317 |  85.00 || 20220610114 | C06311 |  71.00 || 20220610114 | C06312 |  72.00 || 20220610114 | C06313 |  70.00 || 20220610114 | C06315 |  85.00 || 20220610114 | C06316 |  85.00 || 20220610114 | C06317 |  92.00 || 20220610115 | C06311 |  97.00 || 20220610115 | C06312 |  83.00 || 20220610115 | C06313 |  61.00 || 20220610115 | C06315 |  76.00 || 20220610115 | C06316 |  99.00 || 20220610115 | C06317 |  85.00 || 20220610116 | C06311 | 100.00 || 20220610116 | C06312 |  61.00 || 20220610116 | C06313 | 100.00 || 20220610116 | C06315 |  97.00 || 20220610116 | C06316 |  69.00 || 20220610116 | C06317 |  95.00 || 20220610117 | C06311 |  76.00 || 20220610117 | C06313 |  90.00 || 20220610117 | C06314 |  98.00 || 20220610117 | C06316 |  81.00 || 20220610117 | C06317 |  62.00 || 20220610118 | C06311 |  72.00 || 20220610118 | C06313 |  96.00 || 20220610118 | C06314 |  67.00 || 20220610118 | C06316 |  72.00 || 20220610118 | C06317 |  79.00 || 20220714101 | C07111 |  80.00 || 20220714101 | C07112 |  71.00 || 20220714101 | C07114 |  84.00 || 20220714101 | C07115 |  76.00 || 20220714102 | C07111 |  79.00 || 20220714102 | C07112 | 100.00 || 20220714102 | C07114 |  91.00 || 20220714102 | C07115 |  78.00 || 20220714103 | C07111 |  63.00 || 20220714103 | C07112 |  82.00 || 20220714103 | C07113 |  91.00 || 20220714103 | C07114 |  94.00 || 20220714103 | C07115 |  98.00 || 20220714104 | C07111 |  80.00 || 20220714104 | C07112 |  76.00 || 20220714104 | C07113 |  67.00 || 20220714104 | C07115 |  79.00 || 20220714105 | C07111 |  85.00 || 20220714105 | C07112 |  87.00 || 20220714105 | C07113 |  80.00 || 20220714105 | C07115 |  62.00 || 20220714106 | C07111 |  73.00 || 20220714106 | C07112 |  83.00 || 20220714106 | C07113 |  70.00 || 20220714106 | C07115 |  67.00 || 20220714106 | C07116 |  63.00 || 20220714107 | C07111 |  96.00 || 20220714107 | C07112 |  69.00 || 20220714107 | C07113 |  93.00 || 20220714107 | C07115 |  76.00 || 20220714107 | C07116 |  96.00 || 20220714108 | C07111 |  70.00 || 20220714108 | C07112 |  89.00 || 20220714108 | C07113 |  66.00 || 20220714108 | C07115 |  90.00 || 20220714108 | C07116 |  80.00 || 20220714109 | C07111 |  89.00 || 20220714109 | C07112 |  61.00 || 20220714109 | C07113 |  70.00 || 20220714109 | C07115 |  77.00 || 20220714109 | C07116 |  93.00 || 20220714110 | C07111 |  98.00 || 20220714110 | C07112 |  71.00 || 20220714110 | C07113 |  67.00 || 20220714110 | C07114 |  61.00 || 20220714110 | C07115 |  86.00 || 20220714110 | C07116 |  66.00 || 20220714111 | C07111 |  92.00 || 20220714111 | C07112 |  89.00 || 20220714111 | C07113 |  86.00 || 20220714111 | C07114 |  79.00 || 20220714111 | C07115 |  63.00 || 20220714111 | C07116 |  66.00 || 20220714112 | C07111 |  95.00 || 20220714112 | C07112 |  81.00 || 20220714112 | C07113 |  97.00 || 20220714112 | C07114 |  96.00 || 20220714112 | C07115 |  69.00 || 20220714112 | C07116 |  90.00 || 20220714113 | C07111 |  72.00 || 20220714113 | C07112 |  93.00 || 20220714113 | C07113 |  97.00 || 20220714113 | C07114 |  65.00 || 20220714113 | C07116 |  65.00 || 20220714114 | C07111 |  65.00 || 20220714114 | C07112 |  98.00 || 20220714114 | C07113 |  83.00 || 20220714114 | C07114 |  60.00 || 20220714114 | C07116 |  60.00 || 20220714115 | C07111 |  96.00 || 20220714115 | C07113 |  65.00 || 20220714115 | C07114 |  67.00 || 20220714115 | C07116 |  92.00 || 20220714116 | C07111 |  85.00 || 20220714116 | C07113 |  95.00 || 20220714116 | C07114 |  68.00 || 20220714116 | C07116 |  69.00 || 20220820101 | C08101 |  67.00 || 20220820101 | C08102 |  65.00 || 20220820101 | C08103 |  65.00 || 20220820101 | C08105 |  91.00 || 20220820101 | C08106 |  66.00 || 20220820102 | C08101 |  91.00 || 20220820102 | C08102 |  88.00 || 20220820102 | C08103 |  61.00 || 20220820102 | C08105 |  85.00 || 20220820102 | C08106 |  81.00 || 20220820103 | C08101 |  62.00 || 20220820103 | C08102 |  74.00 || 20220820103 | C08103 |  61.00 || 20220820103 | C08105 |  88.00 || 20220820103 | C08106 |  95.00 || 20220820103 | C08107 |  71.00 || 20220820104 | C08101 |  72.00 || 20220820104 | C08102 |  60.00 || 20220820104 | C08103 |  82.00 || 20220820104 | C08104 |  85.00 || 20220820104 | C08105 |  93.00 || 20220820104 | C08106 |  72.00 || 20220820104 | C08107 |  78.00 || 20220820105 | C08101 |  63.00 || 20220820105 | C08102 |  61.00 || 20220820105 | C08103 |  90.00 || 20220820105 | C08104 |  93.00 || 20220820105 | C08105 |  77.00 || 20220820105 | C08106 |  68.00 || 20220820105 | C08107 |  95.00 || 20220820106 | C08101 |  77.00 || 20220820106 | C08102 |  60.00 || 20220820106 | C08103 | 100.00 || 20220820106 | C08104 |  86.00 || 20220820106 | C08105 |  82.00 || 20220820106 | C08106 |  79.00 || 20220820106 | C08107 |  69.00 || 20220820107 | C08101 |  89.00 || 20220820107 | C08102 |  94.00 || 20220820107 | C08104 |  87.00 || 20220820107 | C08105 |  63.00 || 20220820107 | C08106 |  71.00 || 20220820107 | C08107 |  65.00 || 20220820108 | C08101 |  84.00 || 20220820108 | C08102 |  83.00 || 20220820108 | C08104 |  92.00 || 20220820108 | C08105 |  71.00 || 20220820108 | C08107 |  94.00 || 20220820109 | C08101 |  99.00 || 20220820109 | C08102 |  87.00 || 20220820109 | C08104 |  65.00 || 20220820109 | C08105 |  96.00 || 20220820109 | C08107 |  99.00 || 20220820110 | C08101 |  82.00 || 20220820110 | C08102 |  88.00 || 20220820110 | C08104 |  94.00 || 20220820110 | C08105 |  60.00 || 20220820110 | C08107 |  80.00 || 20220930111 | C09111 |  81.00 || 20220930111 | C09112 |  65.00 || 20220930112 | C09111 |  97.00 || 20220930112 | C09112 |  79.00 || 20220930113 | C09111 |  73.00 || 20220930113 | C09112 |  73.00 || 20220930114 | C09111 |  79.00 || 20220930114 | C09112 |  67.00 || 20220930115 | C09111 |  83.00 || 20220930115 | C09112 |  72.00 || 20220930116 | C09111 |  63.00 || 20220930116 | C09112 |  86.00 || 20220930116 | C09113 |  74.00 || 20220930117 | C09111 |  94.00 || 20220930117 | C09112 |  66.00 || 20220930117 | C09113 |  79.00 || 20220930118 | C09111 |  82.00 || 20220930118 | C09112 |  67.00 || 20220930118 | C09113 |  70.00 || 20220930119 | C09111 |  81.00 || 20220930119 | C09112 |  64.00 || 20220930119 | C09113 |  80.00 || 20220930120 | C09111 |  90.00 || 20220930120 | C09112 |  90.00 || 20220930120 | C09113 |  82.00 || 20220930121 | C09111 |  65.00 || 20220930121 | C09112 |  99.00 || 20220930121 | C09113 |  94.00 || 20220930122 | C09111 |  95.00 || 20220930122 | C09112 |  79.00 || 20220930122 | C09113 |  79.00 || 20220930123 | C09111 |  66.00 || 20220930123 | C09112 |  96.00 || 20220930123 | C09113 |  88.00 || 20220930124 | C09111 |  94.00 || 20220930124 | C09112 |  91.00 || 20220930124 | C09113 |  77.00 || 20220930125 | C09111 |  88.00 || 20220930125 | C09113 |  64.00 || 20220930126 | C09111 |  97.00 || 20220930126 | C09113 |  75.00 || 20220930127 | C09111 |  76.00 || 20220930127 | C09113 | 100.00 || 20220930128 | C09111 |  74.00 || 20220930128 | C09113 |  99.00 || 20221012101 | C10121 |  92.00 || 20221012101 | C10122 |  73.00 || 20221012101 | C10124 |  89.00 || 20221012102 | C10121 |  99.00 || 20221012102 | C10122 |  85.00 || 20221012102 | C10124 |  84.00 || 20221012103 | C10121 |  81.00 || 20221012103 | C10122 |  92.00 || 20221012103 | C10124 |  64.00 || 20221012104 | C10121 |  65.00 || 20221012104 | C10122 |  78.00 || 20221012104 | C10124 |  91.00 || 20221012105 | C10121 |  99.00 || 20221012105 | C10122 |  96.00 || 20221012105 | C10123 |  89.00 || 20221012105 | C10124 |  86.00 || 20221012106 | C10121 |  77.00 || 20221012106 | C10122 |  85.00 || 20221012106 | C10123 |  79.00 || 20221012106 | C10124 |  77.00 || 20221012107 | C10121 |  81.00 || 20221012107 | C10122 |  65.00 || 20221012107 | C10123 |  71.00 || 20221012107 | C10124 |  98.00 || 20221012108 | C10121 |  66.00 || 20221012108 | C10122 |  78.00 || 20221012108 | C10123 | 100.00 || 20221012108 | C10124 |  77.00 || 20221012108 | C10125 |  88.00 || 20221012109 | C10121 |  77.00 || 20221012109 | C10122 |  98.00 || 20221012109 | C10123 |  98.00 || 20221012109 | C10124 |  98.00 || 20221012109 | C10125 |  99.00 || 20221012110 | C10121 |  80.00 || 20221012110 | C10122 |  98.00 || 20221012110 | C10123 |  82.00 || 20221012110 | C10124 |  82.00 || 20221012110 | C10125 |  77.00 || 20221012111 | C10121 |  61.00 || 20221012111 | C10122 |  98.00 || 20221012111 | C10123 |  72.00 || 20221012111 | C10124 |  78.00 || 20221012111 | C10125 |  67.00 || 20221012112 | C10121 |  83.00 || 20221012112 | C10122 |  68.00 || 20221012112 | C10123 |  75.00 || 20221012112 | C10124 |  89.00 || 20221012112 | C10125 |  78.00 || 20221012113 | C10121 |  86.00 || 20221012113 | C10122 |  64.00 || 20221012113 | C10123 |  92.00 || 20221012113 | C10124 |  90.00 || 20221012113 | C10125 |  68.00 || 20221012114 | C10121 |  91.00 || 20221012114 | C10122 |  75.00 || 20221012114 | C10123 |  86.00 || 20221012114 | C10124 |  95.00 || 20221012114 | C10125 |  69.00 || 20221012115 | C10121 |  90.00 || 20221012115 | C10122 |  75.00 || 20221012115 | C10123 |  82.00 || 20221012115 | C10124 |  83.00 || 20221012115 | C10125 |  91.00 || 20221012116 | C10121 |  75.00 || 20221012116 | C10122 |  67.00 || 20221012116 | C10123 |  73.00 || 20221012116 | C10124 |  68.00 || 20221012116 | C10125 |  78.00 || 20221012117 | C10121 |  90.00 || 20221012117 | C10122 |  79.00 || 20221012117 | C10123 |  95.00 || 20221012117 | C10124 |  65.00 || 20221012117 | C10125 |  82.00 || 20221012118 | C10121 |  93.00 || 20221012118 | C10122 |  71.00 || 20221012118 | C10123 |  73.00 || 20221012118 | C10124 |  73.00 || 20221012118 | C10125 |  92.00 || 20221012119 | C10121 |  82.00 || 20221012119 | C10122 |  65.00 || 20221012119 | C10123 |  76.00 || 20221012119 | C10124 |  76.00 || 20221012119 | C10125 |  83.00 || 20221012120 | C10121 |  79.00 || 20221012120 | C10123 |  69.00 || 20221012120 | C10124 |  89.00 || 20221012120 | C10125 |  95.00 || 20221012121 | C10121 |  97.00 || 20221012121 | C10123 |  62.00 || 20221012121 | C10124 |  83.00 || 20221012121 | C10125 |  68.00 || 20221012122 | C10121 |  98.00 || 20221012122 | C10123 |  65.00 || 20221012122 | C10124 |  74.00 || 20221012122 | C10125 |  61.00 || 20221012123 | C10121 |  64.00 || 20221012123 | C10123 |  69.00 || 20221012123 | C10125 |  96.00 || 20221012124 | C10121 |  61.00 || 20221012124 | C10123 |  74.00 || 20221012124 | C10125 |  63.00 || 20221012125 | C10121 |  63.00 || 20221012125 | C10123 |  67.00 || 20221012125 | C10125 |  91.00 || 20221012126 | C10121 |  86.00 || 20221012126 | C10123 |  74.00 || 20221012126 | C10125 |  80.00 || 20221012127 | C10121 |  70.00 || 20221012127 | C10123 |  63.00 || 20221012127 | C10125 |  78.00 |+-------------+--------+--------+677 rows in set (0.00 sec)

来源地址:https://blog.csdn.net/weixin_44377973/article/details/134607856

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

【学生成绩管理】数据库示例数据(MySQL代码)

下载Word文档到电脑,方便收藏和打印~

下载Word文档

猜你喜欢

【学生成绩管理】数据库示例数据(MySQL代码)

【学生成绩管理】数据库示例数据(MySQL代码) 目录 【学生成绩管理】数据库示例数据(MySQL代码)一、创建数据库二、创建dept(学院)表1、创建表结构2、添加示例数据3、查看表中数据 三、创建stu(学生)表1
【学生成绩管理】数据库示例数据(MySQL代码)
2023-12-23

mysql数据库学生成绩管理系统

学生成绩管理系统课程设计 需求分析E-R图逻辑关系 物理设计和实施创建包、Add、Del、Update、Sel idea链接数据库简单SQL语句答辩 需求分析 1 信息需求 对学校而言,学生成绩管理是管
mysql数据库学生成绩管理系统
2023-12-22

python使用mysql数据库示例代码

一,安装mysql如果是windows 用户,mysql 的安装非常简单,直接下载安装文件,双击安装文件一步一步进行操作即可。Linux 下的安装可能会更加简单,除了下载安装包进行安装外,一般的linux 仓库中都会有mysql ,我们只需
2022-06-04

通过DML更新MySQL数据库数据的示例代码

本文介绍了使用DML语句(UPDATE、INSERT和DELETE)更新MySQL数据库数据的示例代码,包括语法、示例和最佳实践。UPDATE语句用于更新记录,INSERT语句用于插入新记录,DELETE语句用于删除记录。务必小心使用DML语句,测试并使用事务以确保数据完整性,并优化语句以提高性能。
通过DML更新MySQL数据库数据的示例代码
2024-04-02

mysql数据库空间统计sql代码示例

目录说明一、数据库存储代码二、查询某个数据库的所有表的 代码三、列出所有已经产生碎片的表总结说明INFORMATION_SCHEMA Table Reference 表参考information_schema是‌mysql中的
mysql数据库空间统计sql代码示例
2024-08-09

MySQL数据库多表联合查询代码示例

MySQL多表联合查询允许从多个表中提取数据。语法为SELECT...FROMtable1JOINtable2ON...。示例:获取每个客户的订单总金额:SELECTc.name,SUM(o.total_amount)FROMcustomerscJOINordersoONc.id=o.customer_idGROUPBYc.name;。其他联合类型包括INNERJOIN、LEFTJOIN、RIGHTJOIN和FULLOUTERJOIN。性能提示包括使用索引、优化连接条件、避免模糊查询和考虑使用子查询。
MySQL数据库多表联合查询代码示例
2024-04-02

Java读取数据库表的示例代码

这篇文章主要介绍了Java读取数据库表,本文通过示例代码给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下
2023-05-18

编程热搜

目录