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

Mysql×Ö·û±àÂëÂÒÂë½â¾ö·½·¨

µ¼³öÊÇ,ûÓÐÖ¸¶¨±àÂë
·½·¨Ò»  phpmyadmin´¦Àí·½Ê½
  ¼ì²éphp-mbstringÊÇ·ñÓпÉ×°,ûÓа²×°ÉÏ yum -y install php-mbstring
  ´ò¿ªphpmyadmin Öе¼³ö,ÔÙ´Óphpmyadmin µ¼ÈëÊÇѡȡ¶þÖÆ½ø(binary)
  Èç¹û»¹²»ÐÐ,ÔÚmy.cnf mysqldÖмÓÈë default-character=ÄãµÄ±àÂë, ÖØÆômysql ÔÙÊÔ
·½·¨¶þ mysqldump ´¦Àí·½Ê½
µ¼³ö·½Ê½
mysqldump -u root -p --default-character-set=±àÂë Êý¾ÝÃû³Æ> file.sql
Àý
mysqldump -u root -p --default-character-set=big5 discuss_chi> dis.sql
---------------------
µ¼È뷽ʽ
mysqldump -u root -p --default-character-set=±àÂë Êý¾ÝÃû³Æ< file.sql
Àý
mysql -u root -p --default-character-set=binary -f discuss_chi<file.sql  
Ò²¿ÉÒÔ
mysql -u root -p --default-character-set=big5 -f discuss_chi<dis.sql
µ«Êǽ¨ÒéʹÓöþ½øÖÆ,°²È«D!
·½·¨Èý£º
ÒÔÔ­À´µÄ×Ö·û¼¯Îªlatin1ΪÀý£¬Éý¼¶³ÉΪutf8µÄ×Ö·û¼¯¡£Ô­À´µÄ±í: old_table (default charset=latin1)£¬ÐÂ±í£ºnew_table(default charset=utf
µÚÒ»²½£ºµ¼³ö¾ÉÊý¾Ý
mysqldump --default-character-set=latin1 -h localhost -u root -B my_db --tables old_table > old.sql
µÚ¶þ²½£º×ª»»±àÂë(ÀàËÆunix/linux»·¾³ÏÂ)
iconv -f gb2312 -t utf-8 -c old.sql > new.sql
»òÕß¿ÉÒÔÈ¥µô -f ²ÎÊý£¬ÈÃiconv×Ô¶¯ÅжÏÔ­À´µÄ×Ö·û¼¯
iconv -t utf-8 -c old.sql > new.sql
ÔÚÕâÀ¼Ù¶¨Ô­À´µÄÊý¾ÝĬÈÏÊÇgb2312±àÂë¡£
µÚÈý²½£ºµ¼Èë
ÐÞ¸Äold.sql£¬ÔÚ²åÈë/¸üÐÂÓï¾ä¿ªÊ¼Ö®Ç°£¬Ôö¼ÓÒ»ÌõsqlÓï¾ä£º
"SET NAMES utf8;"
mysql -h localhost -u root -p my_db > new.sql


Ïà¹ØÎĵµ£º

¹ØÓÚmysqlÖеÄinsert

    Õ⼸Ì죬ÏîÄ¿ÖÐÓиöÐèÇ󣬵½Êý¾Ý¿âÕâ²½µÄ½á¹û¾ÍÊÇÐèÒªÅúÁ¿updateµÄÊý¾Ý£¬×ܲ»ÄÜÑ­»·Ê¹ÓÃupdate....set...°É£¬ÕâÑùÏÔʾЧÂÊÊǺܵͣ¬ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬´ó¼ÒÒ²ÊÇÏëÁ˺ܶàµÄ°ì·¨¡£
   ÏÈ˵Õ⼸¸ö½â¾ö·½°¸£º
   1£ºÑ­»·update²Ù×÷£ºÊ²Ã´¶¼²»ËµÁË£¬ÏÔÈ»ÌÔÌ­ÁË£»
   2£º ......

mysqlº¯Êý


ÓÃÔÚSELECTºÍWHERE×Ó¾äµÄº¯Êý
--------------------------------------------------------------
1 ·Ö×麯Êý
( ... ) À¨ºÅ¡£Ê¹ÓÃËüÃÇÀ´Ç¿ÖÆÔÚÒ»¸ö±í´ïʽµÄ¼ÆËã˳Ðò¡£
--------------------------------------------------------------
2 ³£ÓõÄËãÊõÔËËã
£¨+ - * /£©
Ò»°ãµÄË ......

mysql »ù±¾²Ù×÷º¯Êý

Ò» . °²×°ÓëÅäÖÃMYSQL
¶þ . ³£ÓÃmysqlÃüÁîÐÐÃüÁî
1 .mysqlµÄÆô¶¯ÓëÍ£Ö¹
Æô¶¯MYSQL·þÎñ net start mysql
Í£Ö¹MYSQL·þÎñ net stop mysql
2 . netstat –na | findstr 3306 ²é¿´±»¼àÌýµÄ¶Ë¿Ú , findstrÓÃÓÚ²éÕÒºóÃæµÄ¶Ë¿ÚÊÇ·ñ´æÔÚ
3 . ÔÚÃüÁîÐÐÖеǽMYSQL¿ØÖÆÌ¨ , ¼´Ê¹Óà MYSQL COMMEND LINE TOOL
 & ......

MYSQL my.cnfÅäÖÃÖÐÎÄÏê½â

MYSQL--my.cnfÅäÖÃÖÐÎÄÏê½â ZZ2007Äê08ÔÂ16ÈÕ ÐÇÆÚËÄ 15:53mysqld³ÌÐò--Ŀ¼ºÍÎļþ
ÒýÓÃ
basedir = path   ʹÓøø¶¨Ä¿Â¼×÷Ϊ¸ùĿ¼(°²×°Ä¿Â¼)¡£
character-sets-dir = path   ¸ø³ö´æ·Å×Å×Ö·û¼¯µÄĿ¼¡£
datadir = path   ´Ó¸ø¶¨Ä¿Â¼¶ÁÈ¡Êý¾Ý¿âÎļþ¡£
pid-file = filename   Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ