MySQLÉúƧ×ÖÎÞ·¨ÏÔʾ½â¾ö·½·¨
µÚÒ»´Î²ÉÓÃMySQL×÷ΪҵÎñÓ¦ÓõÄÊý¾Ý¿â£¬ÓÉÓÚ¾Ñé²»¹»·á¸»£¬ÔÚ°²×°Êý¾Ý¿âµÄʱºòÑ¡ÔñÁËGB2312±àÂë¡£
ÆðÏÈÓõÄÒ²ËãµÃÐÄÓ¦ÊÖ£¬È»¶øºóÐø·¢ÏÖÁËÉúƧ×Ö²»ÄÜÏÔʾµÄÇé¿ö£¬°ÑÎÒ¸ãµÃ½¹Í·Àö¾¹ýºÃ¼¸ÌìµÄÃþË÷¡¢
ѧϰ£¬ÖÕÓÚ°ÑÎÊÌâ½â¾öÁË¡£¼ÇϽâ¾ö²½Ö裬Óë¸úÎÒÒ»ÑùµÄÐÂÊÖ·ÖÏí¡£
²½ÖèÒ»£º ·ÖÎö³öÏÖÂÒÂëµÄÔÒò
ÓÉÓÚGB2312×Ö·û¼¯Ö»ÊÕ¼ÁË6763¸öºº×Ö£¬µ¼ÖÂһЩÉúƧ×ÖÎÞ·¨Õý³£ÏÔʾ¡£
²½Öè¶þ£ºÈ·¶¨½â¾ö·½·¨
°Ñ×Ö·û¼¯ÓÉGB2312¸Ä³ÉGBK¡£µ«ÊÇÓÉÓÚ²»ÄܶªÆú֮ǰµÄÊý¾Ý£¬ÈçºÎÐÞ¸ÄMySQLµÄ×Ö·û¼¯³ÉÁ˹ؼü¡£
²½ÖèÈý£º×Ö·û¼¯µÄÐÞ¸Ä
a. Ïȵ¼³ö±í½á¹¹
mysqldump -u root -p --default-character-set=gbk -d Êý¾Ý¿âÃû > createdb.sql
ÆäÖвÎÊý-d±íʾֻµ¼³ö±í½á¹¹£¬²»µ¼³öÊý¾Ý¡£
b. ´ò¿ªcreatedb.sql£¬ÊÖ¹¤°Ñgb2312Ìæ»»³Égbk¡£
c. µ¼³öËùÓмǼ
mysqldump -u root -p --quick --no-create-info --extended-insert --default-character-set=gb2312 Êý¾Ý¿âÃû > data.sql
ÆäÖвÎÊý--no-create-info±íʾ²»Éú³É½¨±íÓï¾ä£»--default-character-set=gb2312±íʾ°´ÕÕÔÀ´×Ö·û¼¯µ¼³öËùÓÐÊý¾Ý¡£
d. ´ò¿ªdata.sql£¬ÊÖ¹¤°ÑSET NAME gb2312¸Ä³ÉSET NAME gbk¡£
×¢Ò⣺Èç¹ûdata.sqlºÜ´ó£¬¿ÉÄÜÐèÒªÕÒһЩÌæ»»¹¤¾ßÀ´Íê³ÉÌæ»»²Ù×÷£¬·ñÔò¿ÉÒÔÖ±½ÓÓÃUltraEditÖ®ÀàµÄ±à¼¹¤¾ß´ò¿ªÐ޸ġ£
e. ÔÚеķþÎñÆ÷ÉÏ´´½¨±í£¬Ö´ÐÐcreatedb.sql¡£
mysql -u root -p Êý¾Ý¿âÃû < createdb.sql
f. µ¼ÈëÊý¾Ý£¬Ö´ÐÐdata.sql
mysql -u root -p Êý¾Ý¿âÃû < data.sql
g. ´´½¨Êý¾Ý¿âÓû§¡£
µ½Õâ¶ùÒѾÍê³ÉÁËÊý¾Ý¿â×Ö·û¼¯´Ógb2312µ½gbkµÄÐ޸ģ¬½ÓÏÂÈ¥¿ÉÒԵǼÊý¾Ý¿â£¬ÊÖ¹¤°ÑÏÔʾΪ"?"µÄÂÒÂë×ÖÖØиüÐÂһϡ£
¿´¿´ÊDz»ÊǴ󹦸æ³ÉÁË£¡
Ïà¹ØÎĵµ£º
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.query contains "SELECT"
..
..
..
..
MySQL Protocol
Packet Length: 168
Packet Number: 0
Command
Command: Query (3)
State ......
MySQLÆô¶¯Óë»ù±¾ÅäÖÃ
MySQLÊÇÒ»¸öСÐ͹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ¡£¿ª·¢ÕßΪÈðµäMySQLAB¹«Ë¾£¬ÔÚ2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾10ÒÚÃÀÔªÊÕ¹º¡£MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternetµÄÖÐСÐÍÍøÕ¾ÖУ¬ÓÉÓÚÆäÌå»ýС¡¢Ëٶȿ졢×ÜÌåÓµÓгɱ¾µÍ£¬ÓÈÆäÊÇ¿ª·ÅÔ´ÂëÕâÒ»Ìص㣬Ðí¶àÖÐСÐÍÍøվΪÁ˽µµÍÍøÕ¾×ÜÌåÓµÓгɱ¾¶øÑ¡ÔñÁËMySQL×÷ΪÍøÕ¾Êý¾Ý¿â¡£
MySQL ......
×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇ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
° ......
Ò»ÏÂÊÇÒ»¸öSQLµÄСÎÊÌ⣬À§ÈÅÁË3·ÖÖÓ£¬Ð´ÏÂÀ´¼Ç¼һÏ¡£
Êý¾Ý¿âÊÇMYSQL 5, ±íµÄ½á¹¹ºÜ¼òµ¥, ¾ÍÒ»¸ö×Ö¶ÎÊÇabc£¬ÕûÐÍ¡£
Ò»ÏÂÓï¾äÔËÐеĽá¹ûÊÇÒ»ÑùµÄ¡£×Ô¼º²»ÁôÉñ£¬µ¼ÖÂÀ§ÈÅÁË3·ÖÖÓ¡£
select * from table1 from abc = '123'
select * from table1 from abc = '123_1'
ÒÔÉÏÓï¾äÔÀ´ÊDzéÕÒÊÇ·ñÊý¾Ý´æÔÚ£¬½á¹û123_1ºÍ1 ......