]]>
]]>
娉ㄩ噴:灝嗘暟鎹簱school澶囦喚鍒皊chool.bbb鏂囦歡錛宻chool.bbb鏄竴涓枃鏈枃浠訛紝鏂囦歡鍚嶄換鍙栵紝鎵撳紑鐪嬬湅浣犱細鏈夋柊鍙戠幇銆?
1.瀵煎嚭鏁翠釜鏁版嵁搴?
mysqldump -u 鐢ㄦ埛鍚?-p 鏁版嵁搴撳悕 > 瀵煎嚭鐨勬枃浠跺悕
mysqldump -u root -p aikersql> aiker.sql
2.瀵煎嚭涓涓〃
mysqldump -u 鐢ㄦ埛鍚?-p 鏁版嵁搴撳悕 琛ㄥ悕> 瀵煎嚭鐨勬枃浠跺悕
mysqldump -u aiker -p aikersql users> aiker_users.sql
3.瀵煎嚭涓涓暟鎹簱緇撴瀯
mysqldump -u root -p -d --add-drop-table aikersql>d:\aiker_db.sql
-d 娌℃湁鏁版嵁 --add-drop-table 鍦ㄦ瘡涓猚reate璇彞涔嬪墠澧炲姞涓涓猟rop table
浜?瀵煎叆鏁版嵁搴?
甯哥敤source 鍛戒護
榪涘叆mysql鏁版嵁搴撴帶鍒跺彴錛屽mysql -u root -p
mysql>use 鏁版嵁搴?
鐒跺悗浣跨敤source鍛戒護錛屽悗闈㈠弬鏁頒負鑴氭湰鏂囦歡錛堝榪欓噷鐢ㄥ埌鐨?sql錛?
mysql>source d:\aiker_db.sql
涔熷彲浠ョ敤 mysql -uroot -Ddb1 <d:\aiker_db.sql
涓夈佸皢鏂囨湰鏁版嵁杞埌鏁版嵁搴撲腑
1銆佹枃鏈暟鎹簲絎﹀悎鐨勬牸寮忥細瀛楁鏁版嵁涔嬮棿鐢╰ab閿殧寮錛宯ull鍊肩敤n鏉ヤ唬鏇?
渚嬶細
3 rose 娣卞湷浜屼腑 1976-10-10
4 mike 娣卞湷涓涓?1975-12-23
2銆佹暟鎹紶鍏ュ懡浠?load data local infile "鏂囦歡鍚?quot; into table 琛ㄥ悕;
娉ㄦ剰錛氫綘鏈濂藉皢鏂囦歡澶嶅埗鍒癿ysqlbin鐩綍涓嬶紝騫朵笖瑕佸厛鐢╱se鍛戒護鎵撹〃鎵鍦ㄧ殑搴撱?
鏁版嵁瀵煎嚭
銆銆鏁版嵁瀵煎嚭涓昏鏈変互涓嬪嚑縐嶆柟娉曪細
銆銆浣跨敤select into outfile "filename"璇彞
銆銆浣跨敤mysqldump瀹炵敤紼嬪簭
浣跨敤phpmyadmin瀵煎叆
渚嬪錛歮ysql> select * from driver into outfile "a.txt";
瀵煎叆
銆銆鍚屽鍑虹浉綾諱技錛屽鍏ヤ篃鏈変袱縐嶆柟娉曪細
浣跨敤LOAD DATA INFILE "filename"鍛戒護
浣跨敤mysqlimport瀹炵敤紼嬪簭
浣跨敤phpmyadmin瀵煎叆
浣跨敤sql鏂囦歡
澶╁ぉ榪涙涓鐐圭偣 2007-10-08 11:32 鍙戣〃璇勮
]]>