返回顶部
首页 > 资讯 > 数据库 >【学生成绩管理】数据库示例数据(MySQL代码)
  • 876
分享到

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

数据库mysql 2023-12-23 08:12:02 876人浏览 独家记忆
摘要

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

【学生成绩管理】数据库示例数据(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

您可能感兴趣的文档:

--结束END--

本文标题: 【学生成绩管理】数据库示例数据(MySQL代码)

本文链接: https://lsjlt.com/news/551596.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

猜你喜欢
  • 【学生成绩管理】数据库示例数据(MySQL代码)
    【学生成绩管理】数据库示例数据(MySQL代码) 目录 【学生成绩管理】数据库示例数据(MySQL代码)一、创建数据库二、创建dept(学院)表1、创建表结构2、添加示例数据3、查看表中数据 三、创建stu(学生)表1...
    99+
    2023-12-23
    数据库 mysql
  • mysql数据库学生成绩管理系统
    学生成绩管理系统课程设计 需求分析E-R图逻辑关系 物理设计和实施创建包、Add、Del、Update、Sel idea链接数据库简单SQL语句答辩 需求分析 1 信息需求 对学校而言,学生成绩管理是管...
    99+
    2023-12-22
    数据库 mysql database java
  • 基于学生成绩管理系统(附源代码及数据库)
    基于Ecplise,jsp的学生成绩管理系统 目录 登录页面 系统主页 管理员账号管理 学生查询 课程管理 成绩管理 后台数据库 源代码下载(含数据库) 毕设项目专栏 分为以下四大板块: 系统用户管理:   包含管理员账号管...
    99+
    2023-09-06
    html java mysql jsp css
  • C语言代码实现学生成绩管理系统
    某班有最多不超过 30 人(具体人数由键盘输人)参加期未考试,考试科目 最多不超过 6 门(具体门数由键盘输入,但不少于 3 门),学生成绩管理系统是一 个非常实用的程序,如果能够把...
    99+
    2024-04-02
  • mongodb 数据生成Insert 语句的示例代码
    执行:  db.getCollection('cap.published').find({}).forEach(function(item){   ...
    99+
    2024-04-02
  • python使用mysql数据库示例代码
    一,安装mysql 如果是windows 用户,mysql 的安装非常简单,直接下载安装文件,双击安装文件一步一步进行操作即可。 Linux 下的安装可能会更加简单,除了下载安装包进行安装外,一般的li...
    99+
    2022-06-04
    示例 代码 数据库
  • 基于PHP和MySql的学生成绩管理系统(附完整版代码)
    系统开发运行环境 操作系统:win10 软件:AppServ(php+apache+mysql),nginx(代理) 2.2 功能要求 2.2.1 教职工 对学生成绩有一个整体的了解,在今后的教学中能有所改进。同时可 以对自己教...
    99+
    2023-09-05
    php mysql apache Powered by 金山文档
  • SQL学习之创建学生管理数据库
    1、首先,学习创建数据库之前,如下图所示,我们先介绍一下数据库的类型:从数据库的应用管理角度来看,SQL server数据库分为系统数据库和用户数据库其次,那什么是系统数据库和用户数据库呢?它们分别有什么作...
    99+
    2024-04-02
  • 用java实现学生成绩管理系统(附有详细代码)
    1.需求 添加学生:通过键盘录入学生信息,添加到集合中删除学生:通过键盘录入需要删除学生的学号,将该学生对象从集合中删除修改学生:通过键盘录入需要修改学的学号,将该学生对象的其他信息进行修改查看学生:将集合中的学生对象信息进行展示退出系统:...
    99+
    2023-09-09
    数据结构 java 算法
  • 学生信息管理系统的数据库设计MySQL
    学生信息管理系统的数据库设计 1.课程设计目的 学生信息管理系统是一个教育单位不可缺少的部分。一个功能齐全、简单易用的信息管理系统不但能有效地减轻学校相关工作人员的工作负担,它的内容对于学校的决策者和...
    99+
    2023-10-23
    数据库 mysql
  • 数据库中cdc.lsn_time_mapping的示例代码
    小编给大家分享一下数据库中cdc.lsn_time_mapping的示例代码,希望大家阅读完这篇文章之后都有所收获,下面让我们一起去探讨吧! 代码如下 SELECT&nb...
    99+
    2024-04-02
  • Mysql示例数据库
    官方提供了多个示例数据库: 下载地址: https://dev.mysql.com/doc/index-other.html github示例数据库: 下载地址:https://github.com...
    99+
    2024-04-02
  • MySQL数据库管理
    SQL语句概述 SQL语言 是Structured Query Language的缩写,即结构化查询语言 是关系型数据库的标准语言 用于维护管理数据库,如数据查询、数据更新、访问控制、对象管理等功能 S...
    99+
    2024-04-02
  • 怎么使用C语言代码实现学生成绩管理系统
    这篇文章主要介绍“怎么使用C语言代码实现学生成绩管理系统”,在日常操作中,相信很多人在怎么使用C语言代码实现学生成绩管理系统问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”怎么使用C语言代码实现学生成绩管理系统...
    99+
    2023-06-30
  • 数据库中tmstamp monitor的示例代码
    这篇文章主要介绍了数据库中tmstamp monitor的示例代码,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。USE [DBCe...
    99+
    2024-04-02
  • 数据库中AGStatus SQL的示例代码
    小编给大家分享一下数据库中AGStatus SQL的示例代码,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧! ...
    99+
    2024-04-02
  • mysql数据库应用管理+乱码+字符集的示例分析
    这篇文章主要为大家展示了“mysql数据库应用管理+乱码+字符集的示例分析”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“mysql数据库应用管理+乱码+字符集的...
    99+
    2024-04-02
  • 数据库学习之四:数据库用户管理
    四、数据库用户管理 1、用户定义 用户定义: mysql> select user,host,password from mysql.user; +------+--------------+--------------...
    99+
    2022-01-11
    数据库学习之四:数据库用户管理
  • MySQL示例数据库(MySQL Sample Databases) 之 sakila数据库
    文章目录 MySQL示例数据库(MySQL Sample Databases) 之 sakila数据库官方示例数据介绍sakila数据库sakila数据库安装sakila/sakila-schema.sql的脚本内容sakila的结...
    99+
    2023-08-17
    数据库 mysql sql
  • MySQL数据库管理2
    te  database   db102; create  table db102.t1(name char(6),age  int(3));in...
    99+
    2024-04-02
软考高级职称资格查询
编程网,编程工程师的家园,是目前国内优秀的开源技术社区之一,形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容,为IT开发者提供了一个发现、使用、并交流开源技术的平台。
  • 官方手机版

  • 微信公众号

  • 商务合作