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

MySql±àÂëÎÊÌâ

      ÎÒͬѧ½ÓÁ˸ö˽»î£¬ÏòÎÒÒªÁËmysqlµÄ°²×°Îļþ¡£×òÍíËûÎÊÎÒÓÐûÓöµ½mysqlµÄÂÒÂëÎÊÌ⣬ÎÒ¸øËûµÄ´ð°¸ÊǵÚÒ»´ÎÓõÄʱºòÓöµ½¹ý£¬ÅäºÃÁ˺ó£¬ÏÖÔÚ¶¼Ã»ÓÐÁË¡£Ëû˵ÔÚÍøÉÏÕÒÁ˺ܶàÎÄÕ£¬ÕÕןÄÁËËùÓÐÅäÖÃÎļþ¶¼Ã»½â¾ö¡£
      ÏëÏëÒ²ÊÇ£¬µ±³õµÚÒ»´ÎÓõÄʱºòÒ²ÊÇÒ»Ñù£¬¸ÄÁËËùÓпÉÒԸĵÄÅäÖÃÎļþ»¹ÊdzöÏÖÒ»¶Ñ²»ÈÏʶµÄ±àÂë¡£
      ÆäʵÓÃmysqlµÄÅäÖÃÏòµ¼ÅäÒ»´Î³É¹¦Ò»´Î¡£ºÇºÇ£¡
      ÅäÖÃÏòµ¼²»ÓÃ˵Á˰ɣ¬ÈçÏÂͼ£º
     
     ÆäÖÐ×îÖØÒªµÄ¾ÍÊÇÕâÒ»²½ÈçÏÂͼ£º
 
     
     ¼ÇµÃÒ»¶¨ÒªÑ¡ÔñµÚÈýÏîŶ£¬È»ºóÔÙÑ¡ÔñÄãËùÐèÒªµÄ±àÂ뷽ʽ¡£
     Èç¹ûÄãÊǵÚÒ»´ÎʹÓÃmysql£¬¶øÇÒÓöµ½ÂÒÂëµÄʱºò£¬ÉÏÃæµÄ²Ù×÷Ó¦¸Ã»á¶ÔÄãÓÐÓô¦£¬²»ÓÃÔÚÈ¥µ½´¦ÐÞ¸ÄÅäÖÃÎļþ¡£Èç¹ûÕâÑùÅäÖû¹³öÏÖÂÒÂëʱ£¬¾ÍÏȼì²éÊÇ·ñÔÚ²åÈë֮ǰµÄÊý¾ÝÒѾ­ÊÇÂÒÂë¡£


Ïà¹ØÎĵµ£º

mysql±àÂëÉèÖÃ

mysql
> SHOW VARIABLES LIKE
'character_set_%';
+--------------------------+----------------------------+

| Variable_name | Value |
+--------------------------+----------------------------+

| character_set_client | latin1 |
| character_set_connection |
latin1 |
| character_set ......

Mysql data to long´íÎóµÄ´¦Àí·½·¨

½ñÌìÔÚдʵϰÉúµÄÅàѵPPTʱ£¬ÓÃmysqlµÄcommand line client²åÈëÒ»Ìõ´øÖÐÎĵļǼʱ£¬±¨data to longµÄ´íÎó£¬
ÔÚÍøÉϲ鿴ÁËÏà¹Ø×ÊÁÏ£¬ËµµÄÊÇÒòΪÕâ¸öconsoleʹÓÃÁËÒ»ÖÖ±àÂ뷽ʽ£¬°ÑÃüÁî±àÂëºóÔÙ·¢Ë͵½Êý¾Ý¿â£¬¾ßÌåÇë²Î¿´http://www.cnblogs.com/ovliverlin/archive/2007/11/26/972549.html£¬ËµµÄ±È½ÏÏêϸ£¬±¾ÈË¿´Íêºó£¬Ö±½Ó ......

MySQLÐÔÄÜÓÅ»¯

×÷Õߣºandyao
Ô­ÎÄlink: http://andyao.javaeye.com/admin/show/144033
×ªÔØÇëÁôÃû
1. ¼ò½é
ÔÚWebÓ¦ÓóÌÐòÌåϵ¼Ü¹¹ÖУ¬Êý¾Ý³Ö¾Ã²ã£¨Í¨³£ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â£©ÊǹؼüµÄºËÐIJ¿·Ö£¬Ëü¶ÔϵͳµÄÐÔÄÜÓзdz£ÖØÒªµÄÓ°Ïì¡£MySQLÊÇĿǰʹÓÃ×î¶àµÄ¿ªÔ´Êý¾Ý¿â£¬µ«ÊÇMySQLÊý¾Ý¿âµÄĬÈÏÉèÖÃÐÔÄܷdz£µÄ²î£¬½ö½öÊÇÒ»¸öÍæ¾ßÊý¾Ý¿â¡£Òò´ËÔÚ ......

WindowsÏ»·¾³±äÁ¿Ð޸ģ¨Éæ¼°MySQLÃüÁîµÄÖ±½ÓÔËÐУ©


ÓÒ¼üÎҵĵçÄÔ->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿
¿ÉÒÔ¿´µ½ÓÐÓû§±äÁ¿ºÍϵͳ±äÁ¿
ÔÚÕâÀïÎÒÃÇ¿ÉÒÔ½øÐÐÐ޸Ļ·¾³±äÁ¿
±ÈÈç˵ÎÒÃǰ²×°ÁËMySQL·þÎñÆ÷£¬Ïë½øÈëMySQLµÄÃüÁîÐеϰ¾Í±ØÐëÔËÐÐcmd
Èç¹ûûÓÐÉèÖû·¾³±äÁ¿µÄ»°ÎÒÃDZØÐë½øÈëMySQLµÄ°²×°Â·¾¶²ÅÄÜʹÓÃmysql -u root -pÕâ¸öÃüÁî
ÕâÑù»á¸øÎÒÃÇ´øÀ´ºÜ¶àÂé·³£¬ÕâʱºòÎÒÃÇÏëÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ