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

ʹÓÃMySQL Administrator ʵÏÖMySql Êý¾Ý¿â±¸·ÝÓë»Ö¸´


MySQL Administrator ÊÇʲôÈí¼þ£¿
MySQL Administrator ÊÇÒ»¸öרÃÅÓÃÓÚ¹ÜÀí My SQL 4.X ºÍ 5.X My SQLÊý¾Ý¿âµÄÈí¼þ£¬¿ÉÒÔʹÓÃÕâ¸öÈí¼þ±¸·ÝMy SQLÊý¾Ý¿â£¬»¹Ô­My SQLÊý¾Ý¿â¡£
×¢£ºÈç¹ûÄãµÄÊý¾Ý¿âÊÇ MS SQL 2000 Êý¾Ý¿â£¬Çë²Î¿¼ÕâÀʹÓà MS SQL 2000 ÆóÒµ¹ÜÀíÆ÷¹ÜÀí
ÏÂÔØ MySQL Administrator Èí¼þ
http://61.139.76.172/dl/mysql-administrator-1.1.9-win.msi (±¾Õ¾ µçÐÅÕ¾µãÏÂÔØ)
¡¡
http://dev.mysql.com/downloads/administrator/1.1.html (¹Ù·½Õ¾µã Ó¢ÎÄ)
ÇëÑ¡Ôñ Windows downloads Windows (x86)
¡¡
Èç¹ûÄãûÓÐMy SQL 5.x Êý¾Ý¿â£¬Äã¿ÉÒÔÏÈ´ÓÕâÀïÃâ·ÑÉêÇëÒ»¸ö http://www.zcxp.net/sql.asp
ÉêÇë³É¹¦ºó£¬Ä㽫»ñµÃÒÔϲÎÊý£º
Êý¾Ý¿âIP£º61.139.76.107
Êý¾Ý¿âÃû£ºweb3781
Óà »§ Ãû£ºweb
ÃÜ    Â룺£¿£¿£¿£¿£¿
¡¡
Óöµ½ÎÞ·¨µÇ½µÄÇé¿ö£¬ÇëÏÈÔÝʱ¹Ø±Õ±¾µØ¼ÆËã»ú·À»ðǽ£¬Èç ½ðɽÍø±ê¡¢ÈðÐÇ¡¢KV2006µÈ
1¡¢´ò¿ªÈí¼þ£¬ÌîдÊý¾Ý¿âIP£¬Óû§ÃûºÍÃÜÂë
2¡¢µÇ½³É¹¦ºó£¬½«³öÏÖÏÂÃæµÄ»­Ãæ
3¡¢²é¿´ÒѾ­´æÔÚµÄÊý¾Ý¿â
Ñ¡Ôñ“Catalogs”½«ÁгöÊý¾Ý¿â
µã×óϽÅÊý¾Ý¿âÁбíÖÐÄ㿪ͨµÄ“Êý¾Ý¿âÃû”£¬±¾Àý×ÓÖÐΪ web37812725£¬Óұ߽«ÏÔʾ³öÊý¾Ý¿âÖÐÒѾ­´æÔÚµÄÊý¾Ý¿â±í£¬Èç¹ûÊÇÐÂÊý¾Ý¿â£¬ÓÒ±ßÊÇ¿ÕµÄ
4¡¢±¸·ÝÊý¾Ý¿âµ½±¾µØ¼ÆËã»úÓ²ÅÌ
½«ÉÏͼËùʾÊý¾Ý¿â“web37812725”±¸·Ýµ½±¾µØ¼ÆËã»úÓ²ÅÌ£¬Ñ¡Ôñ“Backup” ±¸·ÝÊý¾Ý¿â¹¦ÄÜ
µã“New Project” ½¨Á¢Ðµı¸·ÝÏîÄ¿
5¡¢Ñ¡ÔñÒª±¸·ÝµÄÊý¾Ý¿â£¬±¾ÀýÖÐΪ web37812725 Êý¾Ý¿â£¬È»ºóµã > ºÅ
6¡¢Óұ߽«ÏÔʾ³öÊý¾Ý¿â±í½á¹¹
7¡¢±¸·ÝÑ¡Ïî
µã“Advanced Options” ¸ß¼¶Ñ¡Ôñ
Ñ¡Ôñ“Normal backup” ±¸·ÝµÄʱºòÑ¡ÔñÕý³£±¸·Ý
Ñ¡Ôñ“Complete backup” Ñ¡ÔñÍêÕû±¸·Ý
Backup Type ±¸·Ý·½Ê½Ñ¡Ôñ SQL Files
µã“Execute Backup Now”Á¢¿Ì¿ªÊ¼±¸·ÝÊý¾Ý¿â
8¡¢µã“Execute Backup Now”Á¢¿Ì¿ªÊ¼±¸·ÝÊý¾Ý¿â
µã“×ÀÃ攽«Êý¾Ý¿âÎļþ±£´æµ½×ÀÃæÉÏ£¬·½±ã²éÕÒ
9¡¢±¸·Ý³É¹¦ºó£¬½«³öÏÖÏÂÃæ»­Ãæ
10¡¢´Ó“×ÀÃæ”ÉÏ¿ÉÒÔÕÒµ½¸Õ¸Õ±¸·ÝµÄÊý¾Ý¿â SQL½Å±¾Îļþ£¬¿ÉÒÔÓà Windows ×Ô´øµÄ“¼Çʱ¾”´ò¿ª£¬ÈçÏÂͼËùʾ¡£
11¡¢±¸·ÝÍê³É¡£
=============================================
   ½«±¸·ÝµÄMy SQLÊý¾Ý¿â»¹Ô­µ½Êý¾Ý¿â·þÎñÆ÷
===============


Ïà¹ØÎĵµ£º

MYSQL ÄÚ´æ»úÖÆ


¶ÔÓÚÈκÎÒ»¸öÊý¾Ý¿â¹ÜÀíϵͳÀ´Ëµ£¬ÄÚ´æµÄ·ÖÅäʹÓþø¶Ô¿ÉÒÔËãµÄÉÏÊÇÆäºËÐÄÖ®Ò»ÁË£¬ËùÒԺܶàÏ£Íû¸üΪÉîÈëÁ˽âijÊý¾Ý¿â¹ÜÀíϵͳµÄÈË£¬¶¼»áÏ£ÍûÒ»¿ú¾¿¾¹£¬ÎÒÒ²²»ÀýÍâ¡£   
  
´ÓÄÚ´æµÄʹÓ÷½Ê½MySQL Êý¾Ý¿âµÄÄÚ´æʹÓÃÖ÷Òª·ÖΪÒÔÏÂÁ½Àà   
  
  
Ï̶߳ÀÏíÄÚ´æ&nb ......

(תÔØ)MySQLÖÐUNIONºÍUNION ALLµÄÇø±ð


ÔÚÊý¾Ý¿â
ÖУ¬UNION
ºÍUNION
ALL
¹Ø¼ü×Ö¶¼Êǽ«Á½¸ö½á¹û¼¯ºÏ²¢ÎªÒ»¸ö£¬µ«ÕâÁ½Õß´ÓʹÓúÍЧ
ÂÊÉÏÀ´Ëµ¶¼ÓÐËù²»Í¬¡£
MySQL
ÖÐ
µÄUNION
UNIONÔÚ½øÐбíÁ´½Óºó»áɸѡµôÖظ´µÄ¼Ç¼£¬ËùÒÔÔÚ±íÁ´½Óºó»á¶ÔËù²úÉúµÄ½á¹û¼¯½øÐÐÅÅÐòÔËË㣬ɾ³ýÖظ´µÄ¼Ç¼ÔÙ
·µ»Ø½á¹û¡£Êµ¼Ê´ó²¿·ÖÓ¦ÓÃÖÐÊDz»»á²úÉúÖظ´µÄ¼Ç¼£¬×î³£¼ûµÄÊǹý³Ì± ......

MySQL²éѯ±íÄÚÖظ´¼Ç¼

MySQL²éѯ±íÄÚÖظ´¼Ç¼
 
²éѯ¼°É¾³ýÖظ´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΠ......

mysqlµÄcardinalityÔÚmyisamºÍinnodbÖеIJ»Í¬

Ïêϸ½âÊͺÍÀý×Ó¼ûÏÂÁÐÎÄÕ£º
http://www.mysqlperformanceblog.com/2008/09/03/analyze-myisam-vs-innodb/
http://www.penglixun.com/work/database/mysql_show_index_cardinality.html
£¨1£©cardinalityÓ°Ïìmysql optimizer¶ÔË÷ÒýµÄÑ¡È¡
£¨2£©¿ÉÒÔͨ¹ýshow index from table_nameÀ´²é¿´±íµÄË÷ÒýºÍcardinality
£¨3£©in ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ