mysql workbenchºº»¯°æÊÇÒ»¿î¼¼ÊõרҵµÄsqlÊý¾Ý¿â¹ÜÀí·½·¨¹¤¾ßÏä,ÓÐ×Å·½±ã¿ì½ÝµÄÊý¾Ý¿â±à¼©/ͬšiÕâЩ×÷ÓÃ,Èù˿ÍÊÇʵ¼ÊËæÒâ¶ÔÍøÂç·þÎñÆ÷Êý¾Ý¿â¿ªÕ¹Î¬»¤±£Ñø.ÓÐÐëÒªµÄС»ï°é¾ÍÀ´¶àÌØÈí¼þÕ¾Ãâ·ÑÏÂÔØ!

Ó¦Óüò½é

MySQL Workbench,ÖÂÁ¦ÓÚMySQLÉè¼Æ·½°¸µÄER/Êý¾Ý¿â½¨Ä£×¨Óù¤¾ß¡£ËüÊÇ×ÅÃûµÄÊý¾Ý¿âÉè¼Æ¹¤¾ßDBDesigner4µÄ½Ó°àÈË¡£ÄãÄÜÓÃMySQL WorkbenchÉè¼Æ·½°¸ºÍ½¨Á¢ÐµÄÊý¾Ý¿âͼÀý£¬´´½¨Êý¾Ý¿âÎı¾Îĵµ£¬¼°Æ俪չ±È½Ï¸´ÔÓµÄMySQL תÒÆ¡£

Èí¼þÌØÉ«

MySQL Workbench ΪÊý¾Ý¿â¹ÜÀíÈËÔ±¡¢Èí¼þ¿ª·¢ÕߺÍϵͳÈí¼þ²ß»®Ê¦¸øÓè½»»¥Éè¼Æ·½°¸¡¢ÊµÌåÄ£ÐÍ´´½¨¡¢¼°ÆäÊý¾Ý¿â¹ÜÀí·½·¨×÷ÓÃ

Ëü°üÀ¨ÁËÓÃÒÔ½¨Á¢·±ÔÓµÄÊý¾ÝÐÅÏ¢½¨Ä£ERʵÌåÄ£ÐÍ£¬Õý·½ÏòºÍ·´ÏòÊý¾Ý¿â¹¤³ÌÏîÄ¿

»¹¿ÉÒÔÓÃÒÔʵÐÐͨ³£±ØÐëºÄ·Ñ´óÁ¿µÄ•r¼äºÍ±ØÐëµÄÎÞ·¨±ä¶¯ºÍ¹Ü¿ØµÄÎı¾ÎĵµÃ¿ÈÕÈÎÎñ

MySQL²Ù×÷̨¿ÉÔÚWindows£¬LinuxºÍMacÉÏÓ¦ÓÃ

workbenchººÓïÉ趨·½Ê½

ººÓïÉ趨·½Ê½£ºÏÂÔØѹËõ°üÀïΪ¸÷λ´øÀ´ÁËÔçÒÑÌí¼ÓºÃµÄ¼òÌåÖÐÎÄ°æÎĵµmain_menu.xml£¬Á¢¼´¿½±´µ½³ÌÐò°²×°²¿Î»µÄdataÎļþ¼ÐÀï¸ü»»¾Í¿ÉÒÔ

edit -- preferences -- appearance -- configure Fonts for : Ñ¡¶¨Simplified Chinese OK

ÈçÏÂͼËùÏÔʾ

MySQL Workbench Ó¦Óãº

1£©Server Administration

* Ó¦ÓÃMySQLInstanceConfigÅ䱸MySQLÒÔServiceÔË×÷£»

* ËæºóÓ¦ÓÃMySQL WorkbenchµÄServer AdministrationµÄNew Server Instance½¨Á¢ÐµÄserver°¸Àý@localhost£»

* Ó¦ÓÃMySQL WorkbenchµÄServer AdministrationµÄData DumpÀ´µ¼Èë´ó¼ÒµÄÊý¾Ý¿â°¸Àýsakila-db£¬×îÏȵ¼Èësakila schema£¬Ëæºóµ¼Èësakila data£¬µ¼ÈëschemaÈçÏÂͼ£º

* µ¼ÈëµÄÃüÁî¿ÉÒÔÔÚworkbenchµÄlogÖмûµ½£¬schemaµÄµ¼ÈëÈçÏÂËùʾ£º

mysql.exe --defaults-extra-file=c:\users\AAA\appdata\local\temp\tmphjwdop --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments E:\\mysql\\sakila-db\\sakila-db\\sakila-schema.sql

dataµÄµ¼ÈëÈçÏÂËùʾ£º

mysql.exe --defaults-extra-file=c:\users\AAA\appdata\local\temp\tmpbsop_e --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments E:\\mysql\\sakila-db\\sakila-db\\sakila-data.sql

* Óë´Ëͬʱ»¹¿ÉÒÔÓ¦ÓÃMySQL WorkbenchµÄServer AdministrationµÄData DumpÀ´µ¼³öÊý¾Ý¿â£¬µ¼³öÓжþÖÖÎļþ¸ñʽ£¬µÚһΪµ¼³öµ½dump project folder£¬Ã¿Ò»¸ö±íΪһ¸ösqlÎļþ£¬µÚ¶þÖÖΪµ¼³öΪself contained file£¬È«²¿µÄ±íµ¼³öΪһ¸ösqlÎļþ£»

2£©SQL Development

* Ó¦ÓÃMySQL WorkbenchµÄSQL DevelopmentµÄ new connectionÀ´½¨Á¢Á¬½Ólocalhost£¬Á¬½Óµ½´ËÇ°µ¼ÈëµÄÊý¾Ý¿â°¸Àýsakila£¬ÈçÏÂËùʾ£º

* ÔÚMySQL WorkbenchµÄSQL DevelopmentµÄÌõ¼þÖв鿴Êý¾Ý¿â°¸ÀýsakilaµÄactor±íƒÈÈÝ£¬ÈçÏÂËùʾ£º

3£©Data Modeling

* Ó¦ÓÃMySQL WorkbenchµÄData ModelingµÄopen existing EER modelÀ´¿ªÆôÊý¾Ý¿â°¸ÀýsakilaÖеÄsakila.mwbÎĵµ£¬ÈçÏÂͼ£º

* ͨ³£µØ£¬´ó¼ÒÓ¦ÓÃMySQL WorkbenchµÄData Modeling´Ó½¨Ä£Öð½¥Éè¼ÆÖÆ×÷Êý¾Ý¿â£¬ÔÚ½¨Ä£½øÐк󵼳öΪsqlÓï¾ä£¬ËæºóÔÙ½«sqlµ¼Èëµ½Êý¾Ý¿â£¬À´½øÐÐÊý¾Ý¿âµÄ½¨Á¢£»