¸ÅÄî
ÊÓͼÊÇÒ»ÖÖÐéÄâ´æÔÚµÄ±í£¬¶ÔÓÚʹÓÃÊÓͼµÄÓû§À´Ëµ£¬»ù±¾ÉϸúʹÓÃÕý³£µÄ±íÒ»Ñù¡£ÊÓͼÔÚÊý¾Ý¿âÖÐÊDz»´æÔڵģ¬ÊÓͼÖеÄÊý¾ÝÊǶ¯Ì¬Éú³ÉµÄ¡£
ÊÓͼÏà¶ÔÓÚÆÕͨ±íµÄÓÅÊÆ£º
¼òµ¥£ºÊ¹ÓÃÊÓͼ²»ÐèÒª¹ØÐĺóÃæµÄ±íµÄ¶ÔÓ¦½á¹¹Ìõ¼þ£¬¶ÔÓÚʹÓÃÕßÀ´Ëµ£¬ÊÓͼÊǹýÂ˺õĽá¹û¼¯¡£ °²È«£ºÊ¹ÓÃÕßÖ»ÄÜ·ÃÎÊËûÃDZ»ÔÊÐí²éѯµÄ½á¹û¼¯¡£ Êý¾Ý¶ÀÁ¢£ºÒ»µ©ÊÓͼ½á¹¹È·¶¨£¬¶Ôʵ¼Ê±íµÄ¸Ä±ä¶ÔÊÓͼʹÓÃÕßÊÇûÓÐÓ°ÏìµÄ¡£
ÊÓͼ²Ù×÷
ÊÓͼ²Ù×÷·ÖΪ´´½¨ÊÓͼ¡¢ÐÞ¸ÄÊÓͼ¡¢É¾³ýÊÓͼ¡¢²é¿´ÊÓͼ¶¨Òå¡£
´´½¨ÊÓͼ£¬ÐÞ¸ÄÊÓͼ
#´´½¨ÊÓͼ
create [or replace] [algorithm={undefined|merge|temptable}]
view view_name[(column_list)]
as select_statement
[with[cascaded|local] check option]
#ÐÞ¸ÄÊÓͼ
alter [algorithm={undefined|merge|temptable}]
view view_name[(column_list)]
as select_statement
[with[cascaded|local] check option]
¾ÙÀý£º
create view view_test as select t1.sid,t1.username,t2.department from test1 t1 left join test2 t2 on t1.sid=t2.sid;

<??http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4NCjxwPjxjb2RlIGNsYXNzPQ=="language-sql hljs ">˵Ã÷£º
from¹Ø¼ü×ÖºóÃæ²»Äܰüº¬×Ó²éѯ£» ²»ÄܸüеÄÊÓͼ£º°üº¬¾ÛºÏº¯Êý/group/distinct/having/union£¬³£Á¿ÊÓͼ£¬selectÖаüº¬×Ó²éѯ£¬jion£¬fromÒ»¸ö²»ÄܸüеÄÊÓͼ£¬whereÖÐ×Ó²éѯÒýÓÃfrom×Ó¾äÖÐµÄ±í¡£ with[cascaded|local] check option ¾ø¶ÔÊÇ·ñÔÊÐí¸üÐÂÊý¾Ýʹ¼Ç¼²»ÔÙÂú×ãÊÓͼÌõ¼þ¡£ÆäÖÐlocal-Ö»ÐèÂú×ã±¾ÊÓͼÌõ¼þ¾Í¿ÉÒÔ¸üС¢cascaded-±ØÐëÂú×ãËùÓÐÕë¶Ô¸ÃÊÓͼµÄËùÓÐÊÓͼµÄÌõ¼þ²Å¿ÉÒÔ¸üС£Ä¬ÈÏΪcascaded¡£
²é¿´ÊÓͼÊý¾Ý
ͬÆÕͨ±í
select * from view_test;
£»
ɾ³ýÊÓͼ
#ɾ³ýÊÓͼ drop view [if exists] view_name [,view_name2]...[restrict|cascade] #¾ÙÀý drop view view_test;
²é¿´ÊÓͼ״̬
´ÓMySQL5.1¿ªÊ¼£¬Ê¹ÓÃshow tablesÃüÁîµÄʱºò²»½öÏÔʾ±íÃû»¹ÏÔʾÊÓͼÃû³Æ¡£