Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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½øÐÐתÂë¡¢²»Í¬±àÂëµÄÊý¾Ý¿âÖ®¼ä¹²ÓÃÊý¾Ý¡£


Ïà¹ØÎĵµ£º

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£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â


ÁªºÏ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 £©Õ¹¿ªÁËÒ»´ÎÌÖÂÛ£ ......

¹ØÓÚMySQLµÄLIMIT Ó﷨СÓÅ»¯£¡

   
½ñÌìÓÐÅóÓÑÎÊÆð´ËÀàÓï¾äµÄÓÅ»¯£¬ÎÒ´óÖ¸øËû½éÉÜÁËÏ´ÓSQL½Ç¶È×ö¼òµ¥µÄÓÅ»¯£¬ÖÁÓÚÓ¦ÓóÌÐò·½ÃæµÄ¿¼ÂÇÔÛÔÝʱ²»¿¼ÂÇ¡£
ÏÂÃæÎÒÀ´¾ÙÒ»¸ö
¼òµ¥µÄÀý×Ó¡£
¿¼ÂÇÈçÏÂ
±í½á¹¹£º
/*DDL Information
For - t_girl.t_page_sample*/
----------------------------------------------
Table   ......

½â¾ömySQLÕ¼ÓÃÄڴ泬´óÎÊÌâ

½â¾ömySQLÕ¼ÓÃÄڴ泬´óÎÊÌâ
ΪÁË×°mysql»·¾³²âÊÔ£¬×°ÉϺó·¢ÏÖÆô¶¯ºómysqlÕ¼ÓÃÁ˺ܴóµÄÐéÄâÄڴ棬´ï8°Ù¶àÕס£ÍøÉÏËÑË÷ÁËһϣ¬µÃµ½¸ßÈËÖ¸µãmy.ini¡£ÔÙҲû¼ûÔÙÏêϸµÄÁË..Ö»ºÃ´ò¿ªmy.iniÖðÐеĿУ¬ËäȻӢÎIJîÁ˵㣬²»¹ý¶àÉÙM»¹ÊÇ¿´µÃÃ÷µÄ^-^
 
¸ü¸ÄºóÈçÏ£º
innodb_buffer_pool_size=576M ->256M InnoDBÒýÇæ»º³å ......

.netÁ´½ÓmysqlÊý¾Ý¿â£¬²Ù×÷Ôöɾ¸Ä²é¡£

ÁíÍâ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.
½ñÌì×öÏîĿʱºò¾ÍÓöµ½ÕâÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ