»ùÓÚMySQLÊý¾Ý¿âµÄUTF8ÖÐÎÄÍøվȫÎļìË÷µÄʵÏÖ
http://hi.baidu.com/xiyouwang/blog/item/9f15bbee99b0ce202df5349e.html
ÏÖÔڵĻ¥ÁªÍøÉÏ£¬ºÜ¶àÍøÕ¾¶¼ÌṩÁËÈ«ÎÄËÑË÷¹¦ÄÜ£¬ä¯ÀÀÕß¿ÉÒÔͨ¹ýÊäÈë¹Ø¼ü×Ö»òÕßÊǶÌÓïÀ´ËÑË÷Ìض¨µÄ×ÊÁÏ¡£ÔÚPHP+MySQL¹¹¼ÜµÄÍøÕ¾ÖУ¬Í¨³£µÄ×ö·¨ÊÇͨ¹ýSELECT²éѯµÄLikeÓï¾äÀ´½øÐÐËÑË÷£¬ÕâÒ»°ì·¨´æÔÚËÑË÷²»¹»¾«È·¡¢ÒÔ¼°Ð§Âʷdz£µÍϵÄȱµã¡£±ÈÈç¶ÔÒ»¸öÓÐÊ®¼¸ÍòÌõ¼Ç¼Êý¾Ý±íµÄTEXT×ֶνøÐÐLIKE²Ù×÷£¬¿ÉÄܻỨ·ÑÉϽü10ÃëÖÓ×óÓÒ£¬Õâ¶ÔÍøÕ¾µÄä¯ÀÀÕßÀ´ËµÊÇÒ»¸ö·Ç³£Ôã¸âµÄʹÓÃÌåÑé¡£ÈçºÎÔÚº£Á¿µÄÊý¾ÝÖÐÄܹ»¿ìËٵĽøÐÐÈ«ÎļìË÷ÄØ£¿MySQLÌṩÁËÒ»¸öÈ«ÎÄË÷Òý¹¦ÄÜ£¬Ò²¾ÍÊÇ°Ñ×Ö¶ÎÉèÖÃÉÏFULLTEXTË÷ÒýÊôÐÔ£¬È»ºóͨ¹ýSELECTµÄMATCH AGAINSTÓï¾ä½øÐвéÕÒ¡£
ÎÒÃÇ¿ª·¢µÄÒ»¸ö´¿Ó¢ÎÄÕ¾µãTouchUs - The Global Yellow Pages & Business Directory£¨www.touchus.org£©¾ÍÊÇÀûÓÃMySQLµÄÕâÒ»¹¦ÄÜ£¬ÊµÏÖÁ˶ÔÊ®¶àÍòÌõÊý¾ÝµÄƽ¾ùÈ«ÎļìË÷ʱ¼äСÓÚ0.5Ãë¡£µ«ÊÇÔÚ¿ª·¢TouchUsµÄÖÐÎÄÍøÕ¾——³ÇÊлÆÒ³Íøʱ£¨www.city39.cn£©£¬Åöµ½ÁËеÄÎÊÌâ¡£ÔÀ´Ó¢ÎÄÅÅ°æʱ´ÊºÍ´ÊÖ®¼äÊÇͨ¹ý¿Õ¸ñÇø·ÖµÄ£¬FULLText¿ÉÒÔÍêÈ«Ö§³Ö£¬µ«ÊǶÔÖÐÎÄ»òÕßÊǶ«ÑÇÎÄ×Ö¾ÍûÓÐÕâô¼òµ¥ÁË£¬ÒòΪÖÐÎĵĴʺʹÊÖ®¼ä²¢Ã»ÓÐÃ÷ÏԵķָô£¬ËùÒÔMySQL²»Ö§³ÖÖÐÎÄ×Ö·ûµÄÈ«ÎļìË÷¡£
ÈçºÎÈÃMySQLÒ²ÄÜÖ§³ÖÖÐÎĵÄÈ«ÎļìË÷ÄØ£¿Å¼È»¼ä²úÉúÁËÒ»¸ö˼·£¬ÄǾÍÊÇÄܲ»ÄÜÔÚÖÐÎķִʺó£¬Í¨¹ý¶ÔÖÐÎĽøÐбàÂëת»¯³ÉÓ¢ÎÄ×Ö·û£¬ÕâÑù¾ÍÔÚÖÐÓ¢Îļ佨Á¢Ò»¸öÌض¨µÄÁªÏµ£¬È»ºóÔÙ½øÐÐÈ«ÎļìË÷£¬ÕâÑù²»¾ÍʵÏÖÁËÖÐÎĵÄÈ«ÎÄË÷ÒýÁËÂ𣿾¹ýÊÔÑ飬´ð°¸Êǿ϶¨µÄ¡£ÏÂÃæÊÇÔÚ³ÇÊлÆÒ³ÍøÖÐʵÏֵľßÌå¹ý³Ì£º
1. ½¨Á¢Ò»¸öµ¥¶ÀµÄË÷Òý±í£¬±ÈÈç¶ÔÓ¦members±í£¬ÎÒÃǽ¨Á¢Ò»¸ömembers_index±í¡£
Óû§ÐÅÏ¢±í(members) Óû§ÐÅϢȫÎÄË÷Òý±í(members_index)
User_id user_id
User_name &nb
Ïà¹ØÎĵµ£º
niginx°²×°Á÷³Ì
Èí¼þÏÂÔØ:--->
mkdir -p /home/dancebear/programe
cd /home/dancebear/programe
wget http://sysoev.ru/nginx/nginx-0.6.31.tar.gz
wget http://www.php.net/get/php-5.2.6.tar.gz/from/this/mirror
wget http://php-fpm.anight.org/downloads/head/php-5.2.6-fpm-0.5.8.diff.gz
wget http://dev ......
mysql¿ÉÒÔÔËÐÐÔÚ²»Í¬sql modeģʽÏÂÃ棬sql modeģʽ¶¨ÒåÁËmysqlÓ¦¸ÃÖ§³ÖµÄsqlÓï·¨£¬Êý¾ÝУÑéµÈ£¡
²é¿´Ä¬ÈϵÄsql modeģʽ£º
select @@sql_mode;
ÎÒµÄÊý¾Ý¿âÊÇ£º
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
ÔÚ´ËģʽÏÂÃ棬Èç¹û²åÈëµÄÊý¾ÝµÄ³¤¶È´óÓÚ¶¨ÒåµÄ³¤¶È£¬ÄÇô¾Í»á±¨´í£¡
......
Ò»°ã½¨Ä£¿ÉÄܶ¼»áÓõ½£ºpowerdesigner
µ«ÊÇ£¬ÔÚ½¨±íµÄʱºò£¬ÎÒһֱûÓÐÕÒµ½£º
DEFAULT CHARACTER SET
COLLATE
Á½¸öÑ¡Ïî¡£Òò´Ë£¬ÏëÁ˸ö·½·¨£¬µã»÷£º¹¤¾ßÀ¸-¡·database-¡·edit current DBMS
È»ºó£¬Ñ¡ÖУºMYSQL50::Script\Objects\Table\Options
ÔÚoptionsĩβÌí¼Ó£º
ENGINE = %s : list = BDB | HEAP | ISAM | InnoDB ......
ÒÔÏÂÕâƪÎÄÕÂÂÛÊöÉÏÔÚʲôÇé¿öÏÂ×Ó²éѯ±ÈÒ»°ãµÄÄÚÁ¬½Ó²éѯ¸ü¼Ó¿ìËÙ
http://www.mysqlperformanceblog.com/2010/03/18/when-the-subselect-runs-faster/
ÒÔÏÂÊÇÎÒ¶ÔmysqlµÄorder byºÍlimitÓÅ»¯µÄ½¨Ò飬ҪÊʱíµÄÊý¾ÝÁ¿ºÍÓÃÀ´¹ýÂËÁеÄΨһֵµÄ¸öÊý¶ø¶¨
£¨1£©where×Ó¾äÖÐÓÃÀ´¹ýÂ˽á¹ûµÄÁÐËùÔÚË÷ÒýµÄcadinalityºÜС£¬¼´ÓÃÏà¹Ø ......
×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇwindows7£¬window7ÔÚ½çÃ棬¹¦ÄÜ·½Ã涼ͦÈÃÈËÂúÒâµÄ£¬¸Ð¾õºÜˬ£¬²»Ë¬µÄÊÇÓÖÒªÖØа²×°»·¾³ÁË¡£
ËùÓÐÈí¼þ¾ù°²×°ÔÚF:\server\ÏÂ
apacheĿ¼£ºF:\server\apache2.2
phpĿ¼£ºF:\server\php
msyqlĿ¼£ºF:\server\mysql
Ò»¡¢°²×°apache
°²×°apacheµÄ°æ±¾ÊÇ£ºhttpd-2.2.15-win32-x86-no_ssl.msi
° ......