12.17mysq代码
/*create view view_after as
select*
from t_reader
where reader_birthday between '1990-1-1' and '1999-12-31';
select *from view_after;*/
/*create view view_qinghua
as
select a.* from t_book a,t_press b
where a.press_id=b.press_id
and b.press_name='清华大学出版社';
select * from view_qinghua;*/
ALTER VIEW view_after
AS
SELECT*
FROM t_reader
WHERE reader_birthday BETWEEN "1990-1-1" AND "2009-12-31";
SELECT *FROM view_after;
DROP VIEW view_after;*/
CREATE VIEW view_basic_info AS
SELECT stu_id,stu_name,stu_sex,stu_birthday
FROM t_student;
SELECT *FROM view_basic_info
CREATE VIEW view_req_course AS
SELECT*
FROM t_course
WHERE course_type='必修课';
SELECT * FROM view_req_course;
SELECT * FROM view_optional;
CREATE VIEW view_optional AS
SELECT a.stu_name,c.* FROM
t_student a,t_score b,t_course c
WHERE a.stu_id=b.stu_id
AND a.stu_sex='女' AND c.course_type='选修课';
ALTER VIEW view_optional AS
SELECT a.stu_name,c.* FROM
t_student a,t_score b,t_course c
WHERE a.stu_id=b.stu_id
AND c.course_type='选修课';
DROP VIEW view_optional;
符攀飞
接近 3 年前
511