mysqlworkbench数据库

Ⅰ 濡备綍鍦ㄧ数鑴戜腑涓嬭浇骞跺畨瑁匨ysql Workbench

MySQL Workbench鏄涓娆句笓涓篗ySQL璁捐＄殑ER/鏁版嵁搴揿缓妯″伐鍏凤纴链変簺鏂扮敤鎴蜂笉鐭ラ亾濡备綍鍦ㄧ数鑴戜腑涓嬭浇骞跺畨瑁呰ヨ蒋浠讹纴鎺ヤ笅𨱒ュ皬缂栧氨缁椤ぇ瀹朵粙缁崭竴涓嫔叿浣撶殑镎崭綔姝ラゃ
鍏蜂綋濡备笅锛
1. 棣栧厛绗涓姝ユ墦寮鐢佃剳娴忚埚櫒锛屾牴鎹涓嫔浘绠澶存墍鎸囷纴鍏埚湪鎼灭储妗嗕腑杈揿叆銆恗ysql銆戯纴鎺ョ潃镣瑰嚮銆怣ySQL瀹樼绣銆戦摼鎺ャ

2. 绗浜屾ヨ繘鍏ュ畼缃戝悗锛屾牴鎹涓嫔浘绠澶存墍鎸囷纴镣瑰嚮銆怐OWNLOADS銆戦夐”銆

3. 绗涓夋ュ湪璺宠浆镄勯〉闱涓锛屽厛婊戝姩镊冲簳閮锛屾帴镌镙规嵁涓嫔浘绠澶存墍鎸囷纴镣瑰嚮銆怣ySQL Community Edition銆戦夐”銆

4. 绗锲涙ユ牴鎹涓嫔浘绠澶存墍鎸囷纴镣瑰嚮銆怣ySQL Workbench銆戦夐”銆

5. 绗浜旀ュ湪璺宠浆镄勯〉闱涓锛屾牴鎹涓嫔浘绠澶存墍鎸囷纴鎸夌収绯荤粺鐗堟湰涓嬭浇鐩稿叧杞浠躲

6. 绗鍏姝ヤ笅杞藉畬鎴愬悗锛屾牴鎹涓嫔浘绠澶存墍鎸囷纴鍙屽嚮杞浠跺畨瑁呭寘銆

7. 绗涓冩ユ墦寮銆愬畨瑁呫戠獥鍙ｅ悗锛屾牴鎹涓嫔浘绠澶存墍鎸囷纴镣瑰嚮銆怤ext銆戦夐”銆

8. 绗鍏姝ユ牴鎹涓嫔浘绠澶存墍鎸囷纴鎸夌収闇姹傝剧疆杞浠跺畨瑁呯洰褰曘

9. 绗涔濇ュ厛鎸夌収闇姹傞夋嫨瀹夎呯被鍨嬶纴鎺ョ潃镣瑰嚮銆怤ext銆戦夐”銆傛牴鎹涓嫔浘绠澶存墍鎸囷纴灏忕紪浠ャ怌omplete銆戜负渚嬨

10. 绗鍗佹ユ牴鎹涓嫔浘绠澶存墍鎸囷纴镣瑰嚮銆怚nstall銆戦夐”銆

11. 绗鍗佷竴姝ョ瓑寰呰蒋浠跺畨瑁呭畬鎴愶纴镙规嵁涓嫔浘绠澶存墍鎸囷纴镣瑰嚮銆怓inish銆戦夐”銆

12. 链钖庢牴鎹涓嫔浘镓绀猴纴鎴愬姛镓揿紑銆怶orkbench銆戯纴鎸夌収闇姹傝繛鎺MySQL銆

Ⅱ mysqlworkbench镐庝箞杩炴帴鏁版嵁搴

1銆侀栧厛鎴戜滑浣跨敤MySQL鎻愪緵镄勫懡浠よ岀晫闱㈡潵瀵煎叆鏁版嵁搴掳纴纭淇濊嚜宸辩殑鐢佃剳涓瀹夎呬简MySQL鏁版嵁搴掳纴鎴戜滑鍙浠ラ氲繃锻戒护琛屾潵纭璁ゆ槸钖﹀畨瑁呬简MySQL鏁版嵁搴掳纴褰撶劧锛岀涓姝ユ槸镓揿紑Mysql镄勬暟鎹搴撴湇锷★纴鎴戜滑浣跨敤锻戒护琛屾潵镓揿紑
2銆佸惎锷∕ySQL钖庯纴鎴戜滑镓惧埌闇瑕佺敤鍒扮殑鑴氭湰鏂囦欢锛屼篃灏辨槸鏁版嵁搴撴枃浠讹纴褰撶劧锛屾垜浠棣栧厛寰楀缓绔嬩竴涓鏁版嵁搴掳纴杩欐牱镓嶅彲浠ュ煎叆鑴氭湰銆
3銆佹垜浠鍦ㄥ皢鑴氭湰𨰾峰埌链鍦扮佺洏镄勬牴鐩褰曪纴杩欐牱鏂逛究杩涘叆镓惧埌鑴氭湰锛岃繖閲屼互D鐩樻潵璇存槑锛屼娇鐢╰est.sql:鎺ョ潃鎴戜滑𨱒ュ埌锻戒护琛岋纴浣跨敤SOURCE d:/test.sql;𨱒ュ煎叆鏁版嵁搴,鍏堣繘鍏mysql
4銆侀栧厛瑕佸湪鏁版嵁搴扑腑寤虹珛濂芥暟鎹搴掳纴铹跺悗瀵煎叆鑴氭湰锛屾墍浠ュ厛寤虹珛涓涓鏁版嵁搴揿摝锛屼笉瑕佽剼链鏄涓岖煡阆扑綘瑕佸线鍝涓鏁版嵁搴扑腑瀵煎叆鑴氭湰镄
5銆佺劧钖庡氨鍙浠ヨ緭鍏ュ煎叆.sql鏂囦欢锻戒护锛
mysql> USE 鏁版嵁搴揿悕;
mysql> SOURCE d:/test.sql;

鏂规硶浜岋细
1銆佷娇鐢∟avicat for MySQL锲惧舰鐣岄溃𨱒ュ煎叆鏁版嵁搴掳纴浣跨敤锲惧舰鐣岄溃瀵煎叆鏁版嵁搴撶殑姝ラゅ緢绠鍗
2銆佸湪锲惧舰鐣岄溃涓寤虹珛濂芥暟鎹搴扑箣钖庯纴鎴戜滑浣跨敤瀵煎叆鑴氭湰镄勫姛鑳芥潵瀵煎叆鏁版嵁搴
3銆佺偣鍑婚夋嫨鑴氭湰锛屾垜浠阃夋嫨D鐩樼殑test.sql鑴氭湰锛岀劧钖庤剧疆鏁版嵁搴揿瓧绗︽牸寮
4銆佹帴镌镣瑰嚮寮濮嬭繍琛岃剼链灏辫屼简锛岃剼链寮濮嫔煎叆浜嗗摝!瀵煎叆瀹屾垚涔嫔悗灏变细鍑虹幇鎴愬姛镄勬彁绀
5銆佺劧钖庢垜浠鍏埚叧闂鏁版嵁搴掳纴鍐嶆墦寮鏁版嵁搴揿氨鍙浠ョ湅鍒板缓绔嫔ソ镄勬暟鎹搴撶殑琛ㄤ简