ʹÓÃ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Êý¾Ý¿â»¹Ôµ½Êý¾Ý¿â·þÎñÆ÷
===============
Ïà¹ØÎĵµ£º
Ò» Apache µÄ°²×°
1 Apache µÄ°²×°
2 ͬÒâÐÒé
3 ½Ó×Å "Next "
4 Ìîд ÓòÃû(network domain) ·þÎñÆ÷µÄÃû³Æ (Server Name) ¹ÜÀíÕßÓÊÏä(Administrator's Email)
5 °²×°ÀàÐÍ
6 Ñ¡Ôñ°²×°Â·¾¶
7 µã»÷“install ” ¼ÌÐø
8 ¿ªÊ¼°²×°
9 °²×°½áÊø
¶þ MySqlµÄ°²×°
......
ÔÚÊý¾Ý¿â
ÖУ¬UNION
ºÍUNION
ALL
¹Ø¼ü×Ö¶¼Êǽ«Á½¸ö½á¹û¼¯ºÏ²¢ÎªÒ»¸ö£¬µ«ÕâÁ½Õß´ÓʹÓúÍЧ
ÂÊÉÏÀ´Ëµ¶¼ÓÐËù²»Í¬¡£
MySQL
ÖÐ
µÄUNION
UNIONÔÚ½øÐбíÁ´½Óºó»áɸѡµôÖظ´µÄ¼Ç¼£¬ËùÒÔÔÚ±íÁ´½Óºó»á¶ÔËù²úÉúµÄ½á¹û¼¯½øÐÐÅÅÐòÔËË㣬ɾ³ýÖظ´µÄ¼Ç¼ÔÙ
·µ»Ø½á¹û¡£Êµ¼Ê´ó²¿·ÖÓ¦ÓÃÖÐÊDz»»á²úÉúÖظ´µÄ¼Ç¼£¬×î³£¼ûµÄÊǹý³Ì± ......
½ñÌìÎÒÃÇ¿´¿´¹ØÓÚMySQLÂýÈÕÖ¾µÄÔĶÁ¡£
ÎÒÃÇÖªµÀ£¬Èç¹ûÎÒÃǵÄÓï¾ä²»¹»ÓÅ»¯£¬ÄÇôÊ×ÏÈMySQLµÄÂýÈÕÖ¾ÊǽøÒ»²½ÓÅ»¯µÄÀëÏßÖ¤¾Ý£¬ËäÈ»ÀïÃæÓкÃ
¶à“αÂýÓï¾ä”£¡
ÏȲ»ËµÔõôÓÅ»¯£¬Èç¹ûÄãµÄÈÕÖ¾ÓÐÒ»ÌõÓï¾ä¶ÄסÁË£¬ÄÇô»áÓв»¼ÆÆäÊýµÄÂýÓï¾äÌî³äµ½MySQLµÄÂúÈÕÖ¾ÀïÃæ¡£ÄÇôÊ×ÏÈÌáÁ¶³öÕâЩÓï
¾ä¾Í·Ç³£Í·ÌÛ¡£
½ñÌìÖ÷Òª½ ......
½ñÌìÖÕÓÚÕÒµ½×Ô¼ºµ÷ÊÔÉÐѧÌÃshoppingÏîĿʱµÄÎÊÌâËùÔÚÁË£¬Í¨¹ý²é×ÊÁÏ£¬¶ÔmyeclipseºÍtomcatµÄ²¿ÊðÓÖÓÐÁ˸üÉîÒ»¸ö²ã´ÎµÄÁ˽⣬³ÌÐòµ÷ͨÁË£¬ÐË·ÜÁËÒ»ÏÂÏ£¬¹þ¹þ¡£¡£
È¥ºǫ́Ìí¼ÓÊý¾Ý·¢ÏÖ´ÓmysqlÖжÁ³öµÄÖÐÎÄÈ«²¿ÏÖʵΪ¿É°®µÄÎʺţ¬ÕâϺÃÁË£¬ÎÒÐÄÀïÒ²²úÉúÎʺŠ......
1.±³¾°
֮ǰ´ÓûÓùýhibernate£¬Òò´ËÔÚÍøÉÏËÑÁËÒ»ÏÂhibernate¿ìËÙÈëÃÅ·½ÃæµÄÐÅÏ¢£¬×îºóÎÒ°´ÕÕ¡¶Myeclipse Hibernate ¿ìËÙÈëÃÅ ÖÐÎÄ°æ¡·£¨CSDN£¬°Ù¶ÈÎĿⶼÓУ©Ò»ÎÄ¿ªÊ¼ÁËÎÒµÄhibernateÖ®Âã¨ÎªÏîÄ¿×ö¼¼Êõ×¼±¸£©¡£
ÏÂÃ ......