mysqlÊý¾Ý¿âÔõôÓÅ»¯
MySQLÊý¾Ý¿âÓÅ»¯µÄ°ËÖÖ·½Ê½:
1¡¢°ÎÈ¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
MySQL¿ÉÒԺܺõÄÖ§³Å´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»Ñù˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÊ©ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´Á¢±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄ»úÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡´ó¸ÅС¡£
ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬¼ÙÈ罫ÆäÉ趨ΪCHAR(255),Ã÷ÏÔ¸øÊý¾Ý¿âÔöÌíÁ˲»±ØÒªµÄ¿Õ¼ä£¬ÄËÖÁʹÓÃVARCHARÕâÆ·ÖÖÐÍÒ²ÊÇÓàÍâµÄ£¬ÓÉÓÚCHAR(6)¾Í¿ÉÒԺܺõÄÍê³ÉÈÎÎñÁË¡£Ò»ÑùµÄ£¬¼ÙÈç¿ÉÒԵĻ°£¬ÎÒÃÇÓ¦µ±Ê¹ÓÃMEDIUMINT¶ø²»ÊÇBIGINÀ´¶¨ÒåÕûÐÍ×ֶΡ£
±ðµÄÒ»¸öÌá¸ßЧÁ¦µÄ°ì·¨ÊÇÔÚ´ó¸ÅµÄ×´¿öÏ£¬Ó¦µ±¾¡Á¿°Ñ×Ö¶ÎÉ趨ΪNOTNULL£¬ÕâÑùÔÚδÀ´Ê©ÐвéѯµÄʱºò£¬Êý¾Ý¿â²»ÏûÈ¥±ÈÁ¦NULLÖµ¡£
¹ØÓÚijЩÎı¾×ֶΣ¬ÀýÈç¡°Ê¡·Ý¡±»òÕß¡°ÐԱ𡱣¬ÎÒÃÇ¿ÉÒÔ½«ËüÃǶ¨ÒåΪENUMÀàÐÍ¡£ÓÉÓÚÔÚMySQLÖУ¬ENUMÀàÐͱ»µ±×÷ÊýÖµÐÍÊý¾ÝÀ´´¦Ö㬶øÊýÖµÐÍÊý¾Ý±»´¦ÖÃÆðÀ´µÄËÙ¶ÈÒª±ÈÎı¾ÀàÐÍ¿ìµÃ¶à¡£ÕâÑù£¬ÎÒÃÇÓÖ¿ÉÒÔÌá¸ßÊý¾Ý¿âµÄ»úÄÜ¡£
2¡¢Ê¹ÓÃÁ¬½Ó£¨JOIN£©À´´úÌæ×Ó²éѯ(Sub-Queries)
MySQL´Ó4.1¿ª¶ËÖ§³ÅSQLµÄ×Ó²éѯ¡£Õâ¸ö¼¼Êõ¿ÉÒÔʹÓÃSELECTÓï¾äÀ´´´Á¢Ò»¸öµ¥ÁеIJéѯ½á¹û£¬È»ºó°ÑÕâ¸ö½á¹û×÷Ϊ¹ýÂËÇ°ÌáÓÃÔÚÁíÒ»¸ö²éѯÖС£ÀýÈ磬ÎÒÃÇÒª½«¿Í»§¸ù±¾ÐÅÏ¢±íÖÐûÓÐÈκζ©µ¥µÄ¿Í»§É¾³ýµô£¬¾Í¿ÉÒÔÀûÓÃ×Ó²éѯÏÈ´ÓÁãÊÛÐÅÏ¢±íÖн«ËùÓз¢³ö¶©µ¥µÄ¿Í»§IDÈ¡³öÀ´£¬È»ºó½«½á¹û´«µÝ¸øÖ÷²éѯ£¬ÈçÏÂËùʾ£º
DELETE FROM customerinfo WHERE CustomerID NOT IN (SELECT CustomerID FROM salesinfo)
ʹÓÃ×Ó²éѯ¿ÉÒÔÒ»´ÎÐÔµÄÍê³ÉÐí¶àÂß¼ÉÏÐèÒª¶à¸ö²½Öè²ÅÄÜÍê³ÉµÄSQL²Ù×Ý£¬Í¬Ê±Ò²¿ÉÒÔÐÒÃâÊÂÎñ»òÕß±íËøËÀ£¬²¢ÇÒдÆðÀ´Ò²ºÜÈÝÒס£µ«ÊÇ£¬ÓÐЩ״¿öÏ£¬×Ó²éѯ¿ÉÒÔ±»¸üÓÐЧÁ¦µÄÁ¬½Ó£¨JOIN£©..Ìæ»»¡£ÀýÈ磬¼ÙÉèÎÒÃÇÒª½«ËùÓÐûÓж©µ¥¼ÇÔصĻáԱȡ³öÀ´£¬¿ÉÒÔÓÃÏÂÃæÕâ¸ö²éѯÍê³É£º
SELECT * FROM customerinfo WHERE CustomerID NOT IN (SELECTC ustomerID FROM salesinfo)
¼ÙÈçʹÓÃÁ¬½Ó£¨JOIN£©..À´Íê³ÉÕâ¸ö²éѯ¹¤×÷£¬ËٶȽ«»á¿ìÐí¶à¡£ÌرðÊǵ±salesinfo±íÖжÔCustomerID½¨ÓÐË÷ÒýµÄ»°£¬»úÄܽ«»á¸üºÃ£¬²éѯÈçÏ£º
SELECT * FROM customerinfo LEFT JOIN salesinfo ON customerinfo.CustomerID=salesinfo.CustomerID WHERE salesinfo.CustomerID ISNULL
Á¬½Ó£¨JOIN£©..Ö®ËùÒÔ¸üÓÐЧÁ¦Ò»Ð©£¬ÊÇÓÉÓÚMySQL²»ÐèÒªÔÚÄÚ´æÖд´Á¢ÔÝʱ±íÀ´Íê³ÉÕâ¸öÂß¼ÉϵÄÐèÒªÁ½¸ö²½ÖèµÄ²éѯ¹¤×÷¡£
3¡¢Ê¹ÓýáºÏ(UNION)À´´úÌæÊÖ¶¯´´Á¢µÄÔÝʱ±í
MySQL´Ó4.0µÄ°æ±¾¿ª¶ËÖ§³Åunion²éѯ£¬Ëü¿ÉÒÔ°ÑÐèҪʹÓÃÔÝʱ±íµÄÁ½Ìõ»ò¸ü¶àµÄselect²éѯºÏ²¢µÄÒ»¸ö²éѯÖС£ÔÚ¿Í»§¶ËµÄ²éѯ»á»°Íê±ÏµÄʱºò£¬ÔÝʱ±í»á±»Ö÷¶¯É¾³ý£¬´Ó¶ø°ü¹ÜÊý¾Ý¿âÕû½à¡¢¸ßЧ¡£Ê¹ÓÃunionÀ´´´Á¢²éѯµÄʱºò£¬ÎÒÃÇÖ»ÐèÒªÓÃUNION×÷Ϊ¹Ø¼ü×ְѶà¸öselectÓï¾äÁ¬½ÓÆðÀ´¾Í¿ÉÒÔÁË£¬ÒªÁôÒâµÄÊÇËùÓÐselectÓï¾äÖеÄ×Ö¶ÎÊýÄ¿ÒªÏëͬ¡£ÏÂÃæµÄÀý×Ó¾ÍÑÝʾÁËÒ»¸öʹÓÃUNIONµÄ²éѯ¡£
SELECT Name,Phone FROM client UNION SELECT Name,BirthDate FROM author UNION SELECT Name,Supplier FROM product
4¡¢ÊÂÎñ
¾¡¹ÜÎÒÃÇ¿ÉÒÔʹÓÃ×Ó²éѯ£¨Sub-Queries£©¡¢Á¬½Ó£¨JOIN£©ºÍ½áºÏ£¨UNION£©À´´´Á¢ÐíÐí¶à¶àµÄ²éѯ£¬µ«²»ÊÇËùÓеÄÊý¾Ý¿â²Ù×ݶ¼¿ÉÒÔÖ»ÓÃÒ»Ìõ»òÉÙÊý¼¸ÌõSQLÓï¾ä¾Í¿ÉÒÔÍê³ÉµÄ¡£¸ü¶àµÄʱºòÊÇÐèÒªÓõ½Ò»ÏµÁеÄÓï¾äÀ´Íê³ÉijÖÖ¹¤×÷¡£µ«ÊÇÔÚÕâÖÖ×´¿öÏ£¬µ±Õâ¸öÓï¾ä¿éÖеÄijһÌõÓï¾äÔËת³ö´íµÄʱºò£¬Õû¸öÓï¾ä¿éµÄ²Ù×ݾͻá±äµÃ²»¿Ï¶¨ÆðÀ´¡£ÉèÏëһϣ¬Òª°Ñij¸öÊý¾Ýͬʱ²åÈëÁ½¸öÏà¹ØÁªµÄ±íÖУ¬´ó¸Å»áÏÔÏÖÕâÑùµÄ×´¿ö£ºµÚÒ»¸ö±íÖгɹ¦¸üкó£¬Êý¾Ý¿âºöÈ»ÏÔÏÖ²»²âÇé¿ö£¬Ôì³ÉµÚ¶þ¸ö±íÖеIJÙ×ÝûÓÐÍê³É£¬ÕâÑù£¬¾Í»áÔì³ÉÊý¾ÝµÄ²»ÍêÈ«£¬ÄËÖÁ»á»Ù»µÊý¾Ý¿âÖеÄÊý¾Ý¡£ÒªÐÒÃâÕâÖÖ×´¿ö£¬¾ÍÓ¦µ±Ê¹ÓÃÊÂÎñ£¬ËüµÄ×÷ÓÃÊÇ£ºÒªÄ©Óï¾ä¿éÖÐÿÌõÓï¾ä¶¼²Ù×ݳɹ¦£¬ÒªÄ©¶¼Ê§°Ü¡£»»¾ä»°Ëµ£¬¾ÍÊÇ¿ÉÒÔ±£³ÖÊý¾Ý¿âÖÐÊý¾ÝµÄÒ»ÖÂÐÔºÍÍêÈ«ÐÔ¡£ÊÂÎïÒÔBEGIN¹Ø¼ü×Ö¿ª¶Ë£¬COMMIT¹Ø¼ü×ÖÍê±Ï¡£ÔÚÕâÖ®¼äµÄÒ»ÌõSQL²Ù×Ýʧ°Ü£¬ÄÇô£¬ROLLBACKÃüÁî¾Í¿ÉÒÔ°ÑÊý¾Ý¿â¸´Ôµ½BEGIN¿ª¶Ë´ËÇ°µÄ״̬¡£
BEGIN; INSERT INTO salesinfo SET CustomerID=14; UPDATE inventory SET Quantity=11 WHERE item='book'; COMMIT;
ÊÂÎñµÄÁíÒ»¸öÖØÒª×÷ÓÃÊǵ±¶à¸ö»áԱͬʱʹÓÃÀ×ͬµÄÊý¾ÝԴʱ£¬Ëü¿ÉÒÔÀûÓÃËø¶¨Êý¾Ý¿âµÄ°ì·¨À´Îª»áÔ±¹©¸øÒ»ÖÖƽ°²µÄ°Ý·Ã·½Ê½£¬ÕâÑù¿ÉÒÔ°ü¹Ü»áÔ±µÄ²Ù×ݲ»±»ÆäËüµÄ»áÔ±Ëù¸ÉÈÅ¡£
5¡¢Ëø¶¨±í
¾¡¹ÜÊÂÎñÊDZ£»¤Êý¾Ý¿âÍêÈ«ÐÔµÄÒ»¸ö·Ç³£ºÃµÄ°ì·¨£¬µ«È´ÓÉÓÚËüµÄ¶ÀÕ¼ÐÔ£¬ÓÐʱ»áÓ°ÏìÊý¾Ý¿âµÄ»úÄÜ£¬ÌرðÊÇÔںܴóµÄÀûÓÃϵͳÖС£ÓÉÓÚÔÚÊÂÎñÊ©ÐеÄÀú³ÌÖУ¬Êý¾Ý¿â½«»á±»Ëø¶¨£¬Òò´ËÆäËüµÄ»áÔ±¿ÒÇóÖ»ÄÜÁÙʱµÈºòÖ±µ½¸ÃÊÂÎñÍê±Ï¡£¼ÙÈçÒ»¸öÊý¾Ý¿âϵͳֻҪÉÙÊý¼¸¸ö»áÔ±À´Ê¹Óã¬ÊÂÎñÔì³ÉµÄÓ°Ïì²»»á³ÉΪһ¸öÌ«´óµÄÎÊÌ⣻µ«¼ÙÉèÓгÉǧÉÏÍòµÄ»áԱͬʱ°Ý·ÃÒ»¸öÊý¾Ý¿âϵͳ£¬ÀýÈç°Ý·ÃÒ»¸öµç×ÓÉÌÎñÍøÕ¾£¬¾Í»á·¢Éú±ÈÁ¦ÑϾþµÄÏìÓ¦ÑÓ³Ù¡£
Æäʵ£¬ÓÐЩ״¿öÏÂÎÒÃÇ¿ÉÒÔͨ¹ýËø¶¨±íµÄ°ì·¨À´»ñµÃ¸üºÃµÄ»úÄÜ¡£ÏÂÃæµÄÀý×Ó¾ÍÓÃËø¶¨±íµÄ°ì·¨À´Íê³ÉÇ°ÃæÒ»¸öÀý×ÓÖÐÊÂÎñµÄ¹¦Ð§¡£
LOCK TABLE inventory WRITE SELECT Quantity FROM inventory WHERE Item='book'; ... UPDATE inventory SET Quantity=11 WHERE Item='book'; UNLOCKTABLES
ÕâÀÎÒÃÇÓÃÒ»¸öselectÓï¾äÈ¡³ö³õʼÊý¾Ý£¬Í¨¹ýһЩÔËË㣬ÓÃupdateÓï¾ä½«ÐÂÖµ¸üе½±íÖС£°üÀ¨ÓÐWRITE¹Ø¼ü×ÖµÄLOCKTABLEÓï¾ä¿ÉÒÔ°ü¹ÜÔÚUNLOCKTABLESÃüÁʩÐдËÇ°£¬²»»áÓÐÆäËüµÄ°Ý·ÃÀ´¶ÔinventoryÍ£Ö¹²åÈë¡¢¸üлòÕßɾ³ýµÄ²Ù×Ý¡£
6¡¢Ê¹ÓÃÍâ¼ü
Ëø¶¨±íµÄ°ì·¨¿ÉÒÔ±£»¤Êý¾ÝµÄÍêÈ«ÐÔ£¬µ«ÊÇËüÈ´²»¿Ë²»¼°°ü¹ÜÊý¾ÝµÄ¹ØÁªÐÔ¡£Õâ¸öʱºòÎÒÃǾͿÉÒÔʹÓÃÍâ¼ü¡£
ÀýÈ磬Íâ¼ü¿ÉÒÔ°ü¹ÜÿһÌõÁãÊÛ¼ÇÔض¼Ö¸Ïòijһ¸ö´æÔڵĿͻ§¡£ÔÚÕâÀÍâ¼ü¿ÉÒÔ°Ñcustomerinfo±íÖеÄCustomerIDÓ³Éäµ½salesinfo±íÖÐCustomerID£¬ÈκÎÒ»ÌõûÓкϷ¨CustomerIDµÄ¼ÇÔض¼²»»á±»¸üлò²åÈëµ½salesinfoÖС£
CREATE TABLE customerinfo( CustomerIDINT NOT NULL,PRIMARYKEY(CustomerID))TYPE=INNODB; CREATE TABLE salesinfo( SalesIDNT NOT NULL,CustomerIDINT NOT NULL, PRIMARYKEY(CustomerID,SalesID), FOREIGNKEY(CustomerID) REFERENCES customerinfo(CustomerID) ON DELETE CASCADE)TYPE=INNODB;
ÁôÒâÀý×ÓÖеIJÎÊý¡°ON DELETE CASCADE¡±¡£¸Ã²ÎÊý°ü¹Üµ±customerinfo±íÖеÄÒ»Ìõ¿Í»§¼ÇÔر»É¾³ýµÄʱºò£¬salesinfo±íÖÐËùÓÐÓë¸Ã¿Í»§Ïà¹ØµÄ¼ÇÔØÒ²»á±»Ö÷¶¯É¾³ý¡£¼ÙÈçÒªÔÚMySQLÖÐʹÓÃÍâ¼ü£¬±ØȻҪ¼ÇסÔÚ´´Á¢±íµÄʱºò½«±íµÄÀàÐͶ¨ÒåΪÊÂÎñƽ°²±íInnoDBÀàÐÍ¡£¸ÃÀàÐͲ»ÊÇMySQL±íµÄĬÐíÀàÐÍ¡£¶¨ÒåµÄ°ì·¨ÊÇÔÚCREATETABLEÓï¾äÖмÓÉÏTYPE=INNODB¡£ÈçÀýÖÐËùʾ¡£
7¡¢Ê¹ÓÃË÷Òý
Ë÷ÒýÊÇÌá¸ßÊý¾Ý¿â»úÄܵij£Óð취£¬Ëü¿ÉÒÔÁîÊý¾Ý¿âЧÀÍÆ÷ÒÔ±ÈûÓÐË÷Òý¿ìµÃ¶àµÄËٶȼìË÷Ìض¨µÄÐУ¬ÌرðÊÇÔÚ²éѯÓï¾ä°ø±ß°üÀ¨ÓÐMAX(),MIN()ºÍORDERBYÕâЩÃüÁîµÄʱºò£¬»úÄÜÌá¸ß¸üΪÃ÷ÏÔ¡£
ÄǸöÔÄÄЩ×ֶδ´Á¢Ë÷ÒýÄØ£¿
Ò»Ñù˵À´£¬Ë÷ÒýÓ¦´´Á¢ÔÚÄÇЩ½«ÓÃÓÚJOIN,WHEREÍƶϺÍORDERBYÅÅÐòµÄ×Ö¶ÎÉÏ¡£¾¡Á¿²»Òª¶ÔÊý¾Ý¿âÖÐij¸öº¬ÓдóÁ¿·´¸´µÄÖµµÄ×ֶδ´Á¢Ë÷Òý¡£¹ØÓÚÒ»¸öENUMÀàÐ͵Ä×Ö¶ÎÀ´Ëµ£¬ÏÔÏÖ´óÁ¿·´¸´ÖµÊǺÜÓдó¸ÅµÄ×´¿ö
ÀýÈçcustomerinfoÖеġ°province¡±..×ֶΣ¬ÔÚÕâÑùµÄ×Ö¶ÎÉÏ´´Á¢Ë÷Òý½«²»»áÓÐʲô°ï棻Ïà·´£¬»¹Óдó¸ÅÂäµÍÊý¾Ý¿âµÄ»úÄÜ¡£ÎÒÃÇÔÚ´´Á¢±íµÄʱºò¿ÉÒÔͬʱ´´Á¢ÊÊÒ˵ÄË÷Òý£¬Ò²¿ÉÒÔʹÓÃALTERTABLE»òCREATEINDEXÔÚ½ñºó´´Á¢Ë÷Òý¡£´ËÍ⣬MySQL´Ó°æ±¾3.23.23¿ª¶ËÖ§³ÅÈ«ÎÄË÷ÒýºÍËÑË÷¡£È«ÎÄË÷ÒýÔÚMySQLÖÐÊÇÒ»¸öFULLTEXTÀàÐÍË÷Òý£¬µ«½öÄÜÓÃÓÚMyISAMÀàÐÍµÄ±í¡£¹ØÓÚÒ»¸ö´óµÄÊý¾Ý¿â£¬½«Êý¾Ý×°Ôص½Ò»¸öûÓÐFULLTEXTË÷ÒýµÄ±íÖУ¬È»ºóÔÙʹÓÃALTERTABLE»òCREATEINDEX´´Á¢Ë÷Òý£¬½«ÊǷdz£¿ìµÄ¡£µ«¼ÙÈ罫Êý¾Ý×°Ôص½Ò»¸öÒѾÓÐFULLTEXTË÷ÒýµÄ±íÖУ¬Ê©ÐÐÀú³Ì½«»á·Ç³£Âý¡£
8¡¢ÓÅ»¯µÄ²éѯÓï¾ä
¾ø´ó¶àÊý×´¿öÏ£¬Ê¹ÓÃË÷Òý¿ÉÒÔÌá¸ß²éѯµÄËٶȣ¬µ«¼ÙÈçSQLÓï¾äʹÓò»Êʵ±µÄ»°£¬Ë÷Òý½«Ã»·¨·¢»ÓËüÓ¦ÓеÄ×÷Óá£
ÏÂÃæÊÇÓ¦µ±ÁôÒâµÄ¼¸¸ö·½Ãæ¡£
µÚÒ»£¬×îºÃÊÇÔÚÀ×ͬÀàÐ͵Ä×ֶμäÍ£Ö¹±ÈÁ¦µÄ²Ù×Ý¡£
ÔÚMySQL3.23°æ´ËÇ°£¬ÕâÄËÖÁÊÇÒ»¸ö±ØÐèµÄÇ°Ìá¡£ÀýÈç²»¿Ë²»¼°½«Ò»¸ö½¨ÓÐË÷ÒýµÄINT×ֶκÍBIGINT×Ö¶ÎÍ£Ö¹±ÈÁ¦£»µ«ÊÇ×÷Ϊ·Ç·²µÄ×´¿ö£¬ÔÚCHARÀàÐ͵Ä×ֶκÍVARCHARÀàÐÍ×ֶεÄ×ֶδóСÀ×ͬµÄʱºò£¬¿ÉÒÔ½«ËüÃÇÍ£Ö¹±ÈÁ¦¡£
Æä´Î£¬ÔÚ½¨ÓÐË÷ÒýµÄ×Ö¶ÎÉϾ¡Á¿²»ÒªÊ¹Óú¯ÊýÍ£Ö¹²Ù×Ý¡£
ÀýÈ磬ÔÚÒ»¸öDATEÀàÐ͵Ä×Ö¶ÎÉÏʹÓÃYEAE()º¯Êýʱ£¬½«»áʹË÷Òý²»¿Ë²»¼°·¢»ÓÓ¦ÓеÄ×÷Óá£ËùÒÔ£¬ÏÂÃæµÄÁ½¸ö²éѯËäÈ»·µ»ØµÄ½á¹ûÒ»Ñù£¬µ«ºóÕßÒª±ÈÇ°Õß¿ìµÃ¶à¡£
- µÚÈý£¬ÔÚËÑË÷×Ö·ûÐÍ×Ö¶Îʱ£¬ÎÒÃÇÓÐʱ»áʹÓÃLIKE¹Ø¼ü×ÖºÍͨÅä·û£¬ÕâÖÖ×ö·¨ËäÈ»¼ò±ã£¬µ«È´Ò²ÊÇÒÔÎþÉüϵͳ»úÄÜΪ´ú¼ÛµÄ¡£
ÀýÈçÏÂÃæµÄ²éѯ½«»á±ÈÁ¦±íÖеÄÿһ±Ê¼Ç¼¡£
SELECT * FROM books WHERE name like"MySQL%"
µ«ÊǼÙÈç»»ÓÃÏÂÃæµÄ²éѯ£¬·µ»ØµÄ½á¹ûÒ»Ñù£¬µ«ËٶȾÍÒª¿ìÉÏÐí¶à£º
SELECT * FROM books WHERE name£¾="MySQL" andname £¼"MySQM"
×îºó£¬Ó¦µ±ÁôÒâÐÒÃâÔÚ²éѯÖÐÈÃMySQLÍ£Ö¹Ö÷¶¯ÀàÐÍת»»£¬ÓÉÓÚת»»Àú³ÌÒ²»áʹË÷Òý±äµÃ²»Æð×÷Óá£
ÒÔÉϾÍÊÇmysqlÊý¾Ý¿âÈçºÎÓÅ»¯µÄ¾ßÌåÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢°Ù·Ö°ÙÔ´ÂëÍøÆäËüÏà¹ØÎÄÕ£¡
¸ÐлÄúµÄÖ§³Ö£¬ÎÒ»á¼ÌÐøŬÁ¦µÄ!
´ò¿ªÖ§¸¶±¦É¨Ò»É¨£¬¼´¿É½øÐÐɨÂë´òÉÍŶ
°Ù·Ö°ÙÔ´ÂëÍø ½¨Òé´òÉÍ1¡«10Ôª£¬ÍÁºÀËæÒ⣬¸ÐлÄúµÄÔĶÁ£¡