MySQL ±àÂë»úÖÆ
	
    
    
	Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ 
¶¼ÊÇÓà set NAMES character 
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£ 
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£ 
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharacter_set_resultsÖÐÉ趨µÄ×Ö·û¼¯·¢Ë͸øÓû§¡£ 
DISCUZ²¢Ã»ÓÐʹÓÃset NAMES character
 
SET NAMES 'x'Óï¾äÓëÕâÈý¸öÓï¾äµÈ¼Û£º 
mysql> SET character_set_client = x; mysql> SET character_set_results = x; mysql> SET character_set_connection = x; 
¶øDISCUZÀïÃæÊÇ
¸´ÖÆ´úÂë
 ´úÂëÈçÏÂ:
@mysql_query("SET
character_set_connection=$dbcharset, character_set_results=$dbcharset,
character_set_client=binary", $this->link); 
SET character_set_client = binary;ʹÓöþ½øÖÆ×Ö·û¼¯²éѯ 
´ËÈý´¦µÄ×Ö·ûÉ趨ºÜ´ó³Ì¶ÈÉÏ»á½â¾öÂÒÂëÎÊÌ⣬ÄÇô×ÅÈý¸öÉ趨¾ßÌåÓÐʲô×÷ÓÃÄØ£¿ 
character_set_client
Ö¸
¶¨µÄÊÇSqlÓï¾äµÄ±àÂ룬Èç¹ûÉèÖÃΪ binary£¬mysql¾Íµ±¶þ½øÖÆÀ´´¦Àí£¬character_set_connectionÖ¸¶¨ÁËmysql
ÓÃÀ´ÔËÐÐsqlÓï¾äµÄʱºòʹÓõıàÂ룬Ҳ¾ÍÊÇ˵£¬³ÌÐò·¢Ë͸øMySQL
µÄSQLÓï¾ä,»áÊ×Ïȱ»MySQL´Ócharacter_set_clientÖ¸¶¨µÄ±àÂëת»»µ½character_set_connectionÖ¸¶¨µÄ
±àÂ룬Èç¹ûcharacter_set_clienÖ¸¶¨µÄÊÇbinary£¬ÔòMySQL¾Í»á°ÑSQLÓï¾ä°´ÕÕ
character_set_connectionÖ¸¶¨µÄ±àÂë½âÊÍÖ´ÐÐ. 
µ±Ö´ÐÐSQLÓï¾äµÄ¹ý³ÌÖУ¬±ÈÈçÏòÊý¾Ý¿âÖвåÈë×ֶεÄʱºò£¬×Ö¶ÎÒ²ÓÐ
±àÂëÉèÖã¬Èç¹û×ֶεıàÂëÉèÖúÍcharacter_set_connectionÖ¸¶¨µÄ²»Í¬£¬ÔòMySQL
»á°Ñ²åÈëµÄÊý¾Ýת»»³É×Ö¶ÎÉ趨µÄ±àÂë¡£SQLÓï¾äÖеÄÌõ¼þÅжϺÍSQL²åÈëÓï¾äµÄÖ´Ðйý³ÌÀàËÆ. 
µ±SQLÖ´ÐÐÍê±ÏÏñ¿Í»§¶Ë·µ»ØÊý¾ÝµÄʱºò£¬»á
°ÑÊý¾Ý´Ó×Ö¶ÎÖ¸¶¨µÄ±àÂëת»»Îªcharacter_set_resultsÖ¸¶¨µÄ±àÂ룬Èç¹ûcharacter_set_results=NULL
Ôò²»×öÈκÎת»»¶¯×÷£¬£¨×¢ÒâÕâÀïÉèÖÃΪNULL²»µÈÓÚûÓÐÉèÖã¬Ã»ÓÐÉèÖõÄʱºòMySQL»á¼Ì³ÐÈ«¾ÖÉèÖã©, 
¹¤×÷ÖбȽÏÓÐÓõľÍÊÇÀûÓÃMySQL½øÐÐתÂë¡¢²»Í¬±àÂëµÄÊý¾Ý¿âÖ®¼ä¹²ÓÃÊý¾Ý¡£
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    1.½¨±íʱ¾Í´´½¨×ÔÔöÁУº
create table test
(
 id int auto_increment primary key,
 name varchar(20) not null,
 password varchar(20) not null
);
insert into test values(null,'aa','aa');
insert into test values(null,'bb','bb');
×¢Ò⣺
      ²åÈëÓï¾äʱ£¬×Ô ......
	
    
        
    
    
ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â
ÔÎÄ£ºhttp://blogs.mysql.com/kaj/2007/12/10/combining-mysql-proxy-with-mysql-cluster/
       ²»¾Ãǰ£¬ÎÒºÍStewart Smith, Vinay Joosery, Monty Taylor ÒÔ¼°ÆäËûµÄmysqlʹÓÃÕߣ¨ËûÃDZÈÎÒ¸üÊìϤMySQL Cluster £©Õ¹¿ªÁËÒ»´ÎÌÖÂÛ£ ......
	
    
        
    
       
						½ñÌìÓÐÅóÓÑÎÊÆð´ËÀàÓï¾äµÄÓÅ»¯£¬ÎÒ´óÖ¸øËû½éÉÜÁËÏ´ÓSQL½Ç¶È×ö¼òµ¥µÄÓÅ»¯£¬ÖÁÓÚÓ¦ÓóÌÐò·½ÃæµÄ¿¼ÂÇÔÛÔÝʱ²»¿¼ÂÇ¡£
ÏÂÃæÎÒÀ´¾ÙÒ»¸ö
¼òµ¥µÄÀý×Ó¡£
¿¼ÂÇÈçÏÂ
±í½á¹¹£º
/*DDL Information 
For - t_girl.t_page_sample*/
----------------------------------------------
Table   ......
	
    
        
    
    ½â¾ömySQLÕ¼ÓÃÄڴ泬´óÎÊÌâ
ΪÁË×°mysql»·¾³²âÊÔ£¬×°ÉϺó·¢ÏÖÆô¶¯ºómysqlÕ¼ÓÃÁ˺ܴóµÄÐéÄâÄڴ棬´ï8°Ù¶àÕס£ÍøÉÏËÑË÷ÁËһϣ¬µÃµ½¸ßÈËÖ¸µãmy.ini¡£ÔÙҲû¼ûÔÙÏêϸµÄÁË..Ö»ºÃ´ò¿ªmy.iniÖðÐеĿУ¬ËäȻӢÎIJîÁ˵㣬²»¹ý¶àÉÙM»¹ÊÇ¿´µÃÃ÷µÄ^-^ 
 
¸ü¸ÄºóÈçÏ£º
innodb_buffer_pool_size=576M ->256M InnoDBÒýÇæ»º³å ......
	
    
        
    
    ÁíÍâMySql¹Ù·½³öÁËÒ»¸öÔÚcsharpÀïÃæÁ¬½ÓMySqlµÄConnector£¬¿ÉÒÔÊÔÊÔ
http://dev.mysql.com/downloads/#connector-net
<add name="mysql" connectionString="server=125.46.37.170;uid=root;pwd=;"/>
±¨´í£ºUnable to connect to any of the specified MySQL hosts.
½ñÌì×öÏîĿʱºò¾ÍÓöµ½ÕâÎÊ ......