course 系统1.2
来源:互联网 发布:网易邮箱大师mac版 编辑:程序博客网 时间:2024/06/06 01:18
create table grade(
id int primary key auto_increment,
gno int,
gcno int not null,
ggrade float(3,1));
alter table grade change gno gno int not null;
insert into grade values(null,1,2017001,98),(null,2,2017001,95),(null,3,2017001,91),(null,1,2017002,88),(null,2,2017002,85),(null,3,2017002,81),(null,1,2017003,78),(null,2,2017003,75),(null,3,2017003,71);
select * from grade where gcno=2017002;
select * from course inner join grade on course.cno=grade.gno;
create table student(
sno int primary key,
sname varchar(20));
insert into student values(2017001,"tom"),(2017002,"jerry"),(2017003,"jack");
select * from student inner join grade on student.sno=grade.gcno;
阅读全文
0 0
- course 系统1.2
- course 系统
- course系统1.4
- Course
- course
- 【Course Schedule】Course Schedule
- Course Summarize
- famous course
- course-book
- Train Course
- FPGA course
- MIT course
- good-course
- SD-Course
- Course Schedule
- Course Schedule
- Course Schedule
- Course Schedule
- MySQL与Oracle 差异比较之二基本语法
- Leetcode 107
- 用C语言实现的学生管理系统
- 插入排序
- ROS消息的创建
- course 系统1.2
- KMP算法 (c++ 构造完整的DFA)
- 递归
- Exchange Seats
- 勾股定理及其逆定理的一种简单证明方法
- 线程、进程和通信
- leetcode之二叉树类之最小公共祖先-----236/235. Lowest Common Ancestor of a Binary/Binary Search Tree
- mybatis学习三之mapper.xml开发方法
- Bode Plot