MySql与access数据库哪个好用 mysql好还是access好
Mysql \u548cAccess \u54ea\u4e2a\u597d\uff1faccess\u5185\u5bb9\u5c11\u4e9b\uff0c\u7a97\u4f53\u62a5\u8868\u4e4b\u7c7b\u7684\u754c\u9762\u505a\u8d77\u6765\u66f4\u7b80\u5355\u4e9b\uff0c\u4e0a\u624b\u66f4\u5bb9\u6613\u4e9b\u3002\u4f46\u529f\u80fd\u4e0d\u5982my
sql\u5f3a\u5927\uff0c\u6570\u636e\u91cf\u4e00\u5927\uff0c\u5904\u7406\u901f\u5ea6\u5c31\u8ddf\u4e0d\u4e0a\u4e86\u3002
\u56e0\u6b64\uff0c\u5982\u679c\u662f\u5fae\u578b\u6570\u636e\u5e93\uff0c\u7528access\u8bbe\u8ba1\u5b8c\u6210\u7684\u4f1a\u6bd4\u8f83\u5feb\uff1b\u53ef\u5982\u679c\u662f\u5927\u4e2d\u578b\u6570\u636e\u5e93\uff0c\u5c31\u4e0d\u8981\u8003\u8651access\u4e86\uff0cmy
sql\u518d\u96be\u5b66\uff0c\u4e5f\u6bd4\u7528access\u505a\u5b8c\u4e86\u7528\u4e0d\u4e86\u6d6a\u8d39\u65f6\u95f4\u5f3a\u3002
\u4e24\u4e2a\u4e0d\u662f\u540c\u7c7b\u6570\u636e\u5e93\uff0cMYSQL\u662f\u7f51\u7edc\u6570\u636e\u5e93\uff0cACCESS\u662f\u684c\u9762\u6570\u636e\u5e93\u3002
1.access\u662f\u6587\u4ef6\u6570\u636e\u5e93,\u5fc5\u987b\u5171\u4eab\u65b9\u5f0f\u5728\u5de5\u4f5c\u7ad9\u6253\u5f00.
2.ACCESS\u7684\u5de5\u4f5c\u6a21\u5f0f\u662f\u5728\u8fd0\u884c\u7aef\u6267\u884cSQL\u8bed\u53e5,\u800cSQL SERVER\u662f\u5728SQL Server\u670d\u52a1\u5668\u4e0a\u6267\u884c.\u6240\u4ee5\u5728\u7f51\u7edc\u73af\u5883\u4e0b,\u7f51\u7edc\u53ca\u5ba2\u6237\u7aef\u7684\u8d1f\u62c5\u90fd\u5f88\u91cd(\u56e0\u4e3a\u8981\u9891\u7e41\u7684\u4ece\u670d\u52a1\u5668\u4e0a\u53d6\u5927\u91cf\u6570\u636e\u5230\u5ba2\u6237\u7aef\u8fd0\u7b97)
3.FAT32\u78c1\u76d8\u4e0aaccess\u67092G\u74f6\u9888,\u56e0\u4e3a\u64cd\u4f5c\u7cfb\u7edf\u6587\u4ef6\u6700\u59272G.ACCESS\u7684\u9650\u5236\u4e0d\u4ec5\u4ec5\u5728\u4e8e2G,\u5b9e\u9645\u4f7f\u7528\u4e2d\u53d1\u73b0,\u5728\u7f51\u7edc\u73af\u5883\u4e0b,\u5f53\u6570\u636e\u5e93\u8d85\u8fc7100M\u65f6,\u8fd0\u884c\u5f88\u4e0d\u7a33\u5b9a,\u7ecf\u5e38\u51fa\u73b0\u6570\u636e\u5e93\u635f\u574f(\u53ef\u4ee5\u7528ACCESS \u7684\u4fee\u590d\u529f\u80fd\u4fee\u590d),\u6570\u636e\u8bb0\u5f55\u51fa\u9519\u7b49\u95ee\u9898
4.\u4f46\u662faccess\u786e\u5b9e\u6709\u5f88\u591a\u4f18\u70b9\u3002\u8bb0\u5f55\u64cd\u4f5c\u5feb\u901f\u3001\u90e8\u7f72\u65b9\u4fbf\u3001\u57fa\u672c\u529f\u80fd\u9f50\u5168\uff08\u6709\u7740\u4e0eSQL server\u76f8\u5f53\u7684\u4e8b\u52a1\u5904\u7406\u529f\u80fd\uff09\u3002\u5728\u4e00\u4e9b\u5d4c\u5165\u5f0f\u3001\u5ba2\u6237\u7aef\u672c\u5730\u7f13\u5b58\u6c38\u4e45\u6570\u636e\u6216\u8005\u5185\u5b58\u8981\u6c42\u5f88\u5c0f\u7684\u573a\u5408\u5f88\u9002\u5408
\u4e00\u5343\u591a\u4e07\u6761\u8bb0\u5f55\u5e76\u53d1\u591a\u3001\u4e0d\u540c\u5ba2\u6237\u7aef\u9891\u7e41\u53d1\u751f\u540c\u4e00\u79cd\u4e1a\u52a1\u7684\u65f6\u5019\u9020\u6210\u4e25\u91cd\u7684\u7684\u7cfb\u7edf\u6b7b\u9501\u95ee\u9898\uff0c\u56e0\u4e3aAccess\u662f\u6309\u7167\u9875\u9762\u4e3a\u5355\u4f4d\u52a0\u9501\u7684\u3002
如果在WIN下还要看具体的用途，如果数量大，接口方便就用mysql,如果只是个小程序，那用access是更好的选择
绛旓細Access锛氭槸涓绉嶆闈鏁版嵁搴锛岄傚悎鏁版嵁閲忚緝灏戠殑搴旂敤锛屽瓨鍌ㄦ暟鎹簱(.mdb)鏂囦欢澶у皬涓嶈秴杩2G瀛楄妭锛屾暟鎹簱涓殑瀵硅薄涓暟涓嶈秴杩32,768銆侻SSQL锛氭槸鍩轰簬鏈嶅姟鍣ㄧ鐨勪腑鍨嬫暟鎹簱锛屽彲浠ラ傚悎澶у閲忔暟鎹殑搴旂敤锛屽湪鍔熻兘涓婄鐞嗕笂涔熻姣擜ccess寮恒傚湪澶勭悊娴烽噺鏁版嵁鐨勬晥鐜囷紝鍚庡彴寮鍙戠殑鐏垫椿鎬э紝鍙墿灞曟х瓑鏂归潰寮哄ぇ銆傚洜涓虹幇鍦ㄦ暟鎹...
绛旓細鐢╝ccess涓嶇煡閬撶幇鍦ㄦ槸涓粈涔堜环锛夛紙2锛夊己璋冧竴鐐癸紝浠涔鏁版嵁搴閮藉彲浠ョ敤鈥滆瑷鈥濊繛鎺ワ紝鎵浠mysql 鍜 access閮借兘鐢–锛孋pp锛宩ava锛宲ython绛夎瑷杩炴帴...鏂规硶寰堢畝鍗曪紝濡傛灉浠ava涓轰緥鐨勮瘽锛岃繛鎺ヤ竴绉嶆暟鎹簱灏辨湁涓夌鏂规硶銆傦紙3锛夋槑纭竴鐐癸紝寰堝浜洪兘浜轰负mysql鏄敤鏉ュ仛閭ｄ簺灏忛」鐩殑锛屽叾瀹炰篃鍙互鍋氬ぇ椤圭洰鍝堬紝mysql杩樻槸...
绛旓細鍏舵,鍗充娇 MySQL 鐨勫浠芥湁閮ㄥ垎鎹熷潖,澶嶅師璧锋潵涔熻姣斾竴涓崯鍧忕殑 MDB 妗ｈ瀹规槗寰楀浜嗐 路鍙欢浼告(Scalability)浠ュ強璧勬枡澶勭悊鑳藉姏 濂楀彞鐧诲北鑰呯殑璇濇潵璇,灏 Access 鏁版嵁搴鏉ヨ窡 MySQL 鐩告瘮,绠鐩村氨鏄儚鎶婂嵃绗畨閭ｇ殑灏忓北涓樻嬁鏉ヨ窡绉戠綏鎷夊娲涚煻灞辫剦鐨 Pike's Peak 椤剁浉姣旇緝銆備簨瀹炲氨鏄繖涔堢畝鍗曗埗MySQL 鍙互澶勭悊鐨勬。妗堟瘮 ...
绛旓細濡備綍 mysql 瀵煎叆 access鏁版嵁搴 1.鎵撳紑Access绋嬪簭锛屾柊寤轰竴涓Access鏁版嵁搴銆2.鍒涘缓涓涓狾DBC杩炴帴锛岀偣鍑汇愬閮ㄦ暟鎹-->銆怬DBC鏁版嵁搴撱--->銆愰氳繃閾炬帴琛ㄩ摼鎺ュ埌鏁版嵁婧愩戙傦紝鍙互閫夋嫨鈥滃鍒惰〃鈥濇垨鈥滈摼鎺ヨ〃鈥濄傞摼鎺ヨ〃鐨勫ソ澶勬槸mysql鏁版嵁婧愭洿鏂帮紝Access閾炬帴鏁版嵁琛ㄨ窡鐫鏇存柊锛孉ccess鍙互浣滀负mysql鏁版嵁搴撶殑鐣岄潰銆3....
绛旓細mysql姣access濂
绛旓細鎬庝箞璇村憿锛屾寜閲忕骇mysql姣access 濂斤紝浣嗘牴鎹渶瑕 濡傛灉灏忓瀷缃戠珯access灏辨尯濂斤紝浣嗘棤娉曞湪linux涓嬭繍琛岋紱濡傛灉涓ぇ鍨嬬綉绔欑敤mysql姣旇緝濂斤紱鎸変环鏍硷細mysql寮婧愬厤璐癸紝access鏄敹璐圭殑锛
绛旓細3.MySql鏈変竴涓潪甯哥伒娲昏屼笖瀹夊叏鐨勬潈闄愬拰鍙ｄ护绯荤粺銆傚綋瀹㈡埛涓嶮ySql鏈嶅姟鍣ㄨ繛鎺ユ椂锛屼粬浠箣闂存墍鏈夌殑鍙ｄ护浼犻佽鍔犲瘑锛岃屼笖MySql鏀寔涓绘満璁よ瘉銆4.MySql鏀寔ODBC for Windows銆侻ySql鏀寔鎵鏈夌殑ODBC 2.5鍑芥暟鍜屽叾浠栬澶氬嚱鏁帮紝杩欐牱灏卞彲浠ョ敤Access杩炴帴MySql鏈嶅姟鍣紝浠庤屼娇寰桵ySql鐨勫簲鐢ㄨ澶уぇ鎵╁睍銆5.MySql鏀寔澶у瀷鐨鏁版嵁搴...
绛旓細涓や釜涓嶆槸鍚岀被鏁版嵁搴锛MYSQL鏄綉缁滄暟鎹簱锛ACCESS鏄闈㈡暟鎹簱銆1.access鏄枃浠舵暟鎹簱,蹇呴』鍏变韩鏂瑰紡鍦ㄥ伐浣滅珯鎵撳紑.2.ACCESS鐨勫伐浣滄ā寮忔槸鍦ㄨ繍琛岀鎵цSQL璇彞,鑰孲QL SERVER鏄湪SQL Server鏈嶅姟鍣ㄤ笂鎵ц.鎵浠ュ湪缃戠粶鐜涓,缃戠粶鍙婂鎴风鐨勮礋鎷呴兘寰堥噸(鍥犱负瑕侀绻佺殑浠庢湇鍔″櫒涓婂彇澶ч噺鏁版嵁鍒板鎴风杩愮畻)3....
绛旓細ACCESS鏁版嵁搴锛氭敹璐癸紝涓嶆敮鎸佸苟鍙戯紝妗岄潰鍨嬫暟鎹簱 mysql鏁版嵁搴擄細鍏嶈垂锛屾敮鎸佸苟鍙戯紝鍒嗗竷寮忔暟鎹簱 Access 鏁版嵁搴鐢╒B璇█ 鍥惧舰鐣岄潰姣旇緝寮哄ぇ ACCESS 闈㈠悜灏忓瀷鏁版嵁搴旂敤锛MYSQL闈㈠悜澶у瀷銆
绛旓細涓轰粈涔堜紬澶氫紒涓氬Office鑷甫鐨Access鏁版嵁搴鏈夋墍鍋忚锛熷湪娣卞叆鎺㈣杩欎釜闂涔嬪墠锛屾垜浠鍏堣鏄庣櫧锛岀殑纭紝鍍忚瘎璁轰腑鎵鎸囧嚭鐨勯偅鏍凤紝濡傛灉鍗曠函姣旇緝鏁版嵁搴撳姛鑳斤紝Access鍙兘涓嶆槸棣栭夛紝鍥犱负鍏朵粬涓撲笟鏁版嵁搴撳MySQL銆丱racle绛夊湪鎬ц兘鍜岀伒娲绘т笂纭疄鏇翠负鍑鸿壊銆傜劧鑰岋紝杩欏拷鐣ヤ簡Access鐨勭嫭鐗逛箣澶勩傚叧閿湪浜庯紝璁稿浜哄Access鐨勮瑙...
