数据库 视图
来源：互联网 发布：mac能用latex吗 编辑：程序博客网 时间：2024/06/08 10:33
use test1;
CREATE VIEW resulet1
AS
SELECT stu.StudentNo,stu.StudentName from grade g,result r,student stu,`subject` sub
where g.GradeId=stu.GradeId AND stu.StudentNo=r.StudentNo
AND r.SubjectId=sub.SubjectId AND g.GradeId=sub.GradeId;
SELECT * from resulet1;
CREATE VIEW resulet1
AS
SELECT stu.StudentNo,stu.StudentName from grade g,result r,student stu,`subject` sub
where g.GradeId=stu.GradeId AND stu.StudentNo=r.StudentNo
AND r.SubjectId=sub.SubjectId AND g.GradeId=sub.GradeId;
SELECT * from resulet1;
阅读全文
0 0
