·¢²¼Ê±¼ä : ÐÇÆÚÈÕ ÎÄÕÂÊý¾Ý¿âʵÑ鱨¸æ(7¸öʵÑéÍêÕû¸½½Øͼ)¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ171d0eef27d3240c8447eff6
£¨2£©
£¨3£©
Áù¡¢×ܽá
ͨ¹ýÕâ´ÎʵÑ飬ÕÆÎÕÁË select Óï¾äµÄ»ù±¾Ê¹Ó÷½·¨£¬¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐÐ
²éѯ·½·¨ÓÐÁ˽øÒ»²½µÄÁ˽⣬¹®¹ÌÁË×Ó²éѯºÍÁ¬½Ó²éѯµÄʹÓÃÒÔ¼° GROUP BY¡¢ ORDER BYºÍLIMIT×Ó¾äµÄʹÓã¬ÎªÒÔºó×öÊý¾Ý¿âÊý¾ÝµÄ²éѯµì¶¨»ù´¡¡£
˵Ã÷£º¿ÉÒÔÒ»´Î²åÈë¶àÌõ¼Ç¼
ʵÑéËÄ£ºÊý¾Ý¿âµÄÊÓͼ²Ù×÷ʵÑé
Ò»¡¢ÊµÑéÄ¿µÄºÍÒªÇó
1¡¢ÊìϤÊÓͼµÄ¸ÅÄîºÍ×÷Óã» 2¡¢ÕÆÎÕÊÓͼµÄ´´½¨·½·¨£»
3¡¢ÕÆÎÕÈçºÎ²éѯºÍÐÞ¸ÄÊÓͼ¡£
¶þ¡¢ÊµÑéÄÚÈݺÍÔÀí
1¡¢´´½¨ÊÓͼ£º
£¨1£©´´½¨zhzÊý¾Ý¿âÉϵÄÊÓͼ student_view£¬ÊÓͼ°üº¬Ñ§ºÅ¡¢ÐÕÃû¡¢Ïµ£» £¨2£©´´½¨zhzÊý¾Ý¿âÉϵÄÊÓͼ sc_view£¬ÊÓͼ°üº¬ sc±íµÄÈ«²¿ÁС£ 2¡¢²éѯÊÓͼ£º
£¨1£©´ÓÊÓͼsc_view Öв鿴ѡÐÞÁË3ºÅ¿Î³ÌµÄѧÉúµÄѧºÅ£» £¨2£©´ÓÊÓͼstudent_view ÖвéѯÐÕÃûΪ¡°ÍõÃô¡±µÄѧÉúËùÔÚµÄϵ¡£ 3¡¢¸üÐÂÊÓͼ£º
£¨1£©ÏòÊÓͼsc_view ÖвåÈëÒ»ÐÐÊý¾Ý£º2008005£¬5£¬87£» £¨2£©½«ÊÓͼstudent_view ÖÐѧºÅ=2008002 µÄѧÉúµÄϵ¸ÄΪMA£» £¨3£©É¾³ýÊÓͼstudent_view ÖÐѧºÅ=2008007 µÄѧÉúµÄÐÅÏ¢¡£ 4¡¢É¾³ýÊÓͼ£º
£¨1£©É¾³ýÊÓͼsc_view£» 5¡¢ÔÚ½çÃ湤¾ßÖвÙ×÷ÊÓͼ
Èý¡¢ÊµÑé»·¾³ Ó²¼þ£ºPC»ú
Èí¼þ£ºWindows²Ù×÷ϵͳ¡¢ MySQL Server 6.0 ºÍNavicat for MySQL 9.0
ËÄ¡¢Ëã·¨ÃèÊö¼°ÊµÑé²½Öè
1¡¢´´½¨ÊÓͼ£º
£¨1£©´´½¨zhzÊý¾Ý¿âÉϵÄÊÓͼ student_view£¬ÊÓͼ°üº¬Ñ§ºÅ¡¢ÐÕÃû¡¢Ïµ£º
CREATE VIEW student_view AS
SELECT Sno,Sname,Sdept
FROM student
£¨2£©´´½¨zhzÊý¾Ý¿âÉϵÄÊÓͼ sc_view£¬ÊÓͼ°üº¬ sc±íµÄÈ«²¿ÁУº CREATE VIEW sc_view AS SELECT * FROM sc
2¡¢²éѯÊÓͼ£º
£¨1£©´ÓÊÓͼsc_view Öв鿴ѡÐÞÁË3ºÅ¿Î³ÌµÄѧÉúµÄѧºÅ£º SELECT Sno FROM sc_view WHERE Cno='3'
£¨2£©´ÓÊÓͼstudent_view ÖвéѯÐÕÃûΪ¡°ÖÜËï±ò¡±µÄѧÉúËùÔÚµÄϵ£º SELECT Sname,Sdept FROM student_view