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

扫描下方二维码手机阅读文章

1 0