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

MySql±àÂëÎÊÌâ

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


Ïà¹ØÎĵµ£º

mysql distinct ¶Ô¶à×ֶιýÂ˲»ÕýÈ·µÄ½â¾ö·½·¨


ÏÂÃæÏÈÀ´¿´¿´Àý×Ó£º
    table
  id name
  1 a
  2 b
  3 c
  4 c
  5 b
¿â½á¹¹´ó¸ÅÕâÑù£¬ÕâÖ»ÊÇÒ»¸ö¼òµ¥µÄÀý×Ó£¬Êµ¼ÊÇé¿ö»á¸´Ôӵöࡣ
±ÈÈçÎÒÏëÓÃÒ»ÌõÓï¾ä²éѯµÃµ½name²»Öظ´µÄËùÓÐÊý¾Ý£¬ÄǾͱØÐëʹÓÃdistinctÈ¥µô¶àÓàµÄÖØ¸´¼Ç¼ ......

mysql±àÂëÉèÖÃ

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

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

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

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


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

mysql ʹÓÃÏà¹Ø ³ÖÐø¸üÐÂÖÐ...

mysqlÍ£Ö¹ÃüÁî
bin/mysqladmin -uroot -p shutdown
mysqlÆô¶¯ÃüÁî
bin/mysqld_safe &
mysql ÐÞ¸ÄrootÃÜÂë
1.Í£Ö¹mysql·þÎñ
2.Æô¶¯mysql·þÎñʱ¸½¼Ó²ÎÊý
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
3.ÒÔroot½øÈëmysql
mysql -u root mysql
4.Ö´ÐÐsqlÓï¾ä
mysql> UPDATE user S ......

´ò¿ªmysqlÔ¶³Ì·ÃÎÊȨÏÞ


2009-05-05
´ò¿ªMySQLÔ¶³Ì·ÃÎÊȨÏÞ
¹Ø¼ü×Ö: mysql
1¡¢¸Ä±í·¨
¡¡¡¡¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
¡¡¡¡mysql -u root -p
mysql>use mysql;
¡¡¡¡mysql>upda ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ