Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

accessÌå»ý

Ò»¸ö³ÌÐòÍùaccessÊý¾Ý¿âÀïÃæÐ´¼Ç¼£¬Ã¿Ììд5ÍòÌõ£¬µÚ¶þÌìɾ³ýǰһÌìµÄ5ÍòÌõ
µ«ÊÇaccessÎļþµÄÌå»ý»áÂýÂýÔö¼Ó¡£¡£¡£
ÎÒ²»Ñ¹ËõÊý¾Ý¿âµÄÇé¿öÏ£¬Ê²Ã´Ê±ºòÊý¾Ý¿âµÄÌå»ý²Å²»Ôö¼ÓÄØ£¿

ÎÒɾ³ý¼Ç¼µÄʱºò£¬Êý¾Ý¿âÌå»ýËäÈ»²»¼õС£¬µ«AccessÊÇ×öÁ˼ǼµÄ£¬ÎÒÏëµ±Êý¾Ý¿â´ïµ½Ò»¶¨³Ì¶ÈµÄʱºò£¬access»áÍùÒÔǰɾ³ýµÄ¿Õ¼äÉÏдÊý¾Ý°É

²»ÖÁÓÚaccess¾Í°ÑÒÔǰµÄ¿Õ¼äÒ»Ö±À˷ѵô£¬Êý¾Ý¿âÊÇÕâÑùÉè¼ÆµÄ£¿

ÓÐЩÊý¾Ý¿âÓлØÊտռ书ÄÜ£¬±ÈÈçACCESS£¬µ«±ØÐëÊÖ¶¯£¬
ÆäËüÊý¾Ý¿â£¬±ÈÈçASA£¬±ØÐëÖØÐ½¨Á¢DB£¬ÔÙµ¼ÈëÊý¾Ý£¬
MYSQL¡¡INNODB±íÒ²ÊÇÕâÑù£¬¸ù¾Ý¾ßÌåÊý¾Ý¿â²»Í¬°É

ÒýÓÃ
ÓÐЩÊý¾Ý¿âÓлØÊտռ书ÄÜ£¬±ÈÈçACCESS£¬µ«±ØÐëÊÖ¶¯£¬
ÆäËüÊý¾Ý¿â£¬±ÈÈçASA£¬±ØÐëÖØÐ½¨Á¢DB£¬ÔÙµ¼ÈëÊý¾Ý£¬
MYSQL¡¡INNODB±íÒ²ÊÇÕâÑù£¬¸ù¾Ý¾ßÌåÊý¾Ý¿â²»Í¬°É


Äã¾ÍÊÇ˵³ý·ÇÊÖ¶¯Ñ¹ËõÊý¾Ý¿â£¬·ñÔòaccessÊý¾Ý¿â»áÒ»Ö±Ôö´óµ½×î´óÏÞÖÆ´óС£¬È»ºó³ÌÐòÔÙÍùÊý¾Ý¿âд¼Ç¼¾Í»á³ö´í£¿

Äã¾ÍÊÇ˵³ý·ÇÊÖ¶¯Ñ¹ËõÊý¾Ý¿â£¬·ñÔòaccessÊý¾Ý¿â»áÒ»Ö±Ôö´óµ½×î´óÏÞÖÆ´óС£¬È»ºó³ÌÐòÔÙÍùÊý¾Ý¿âд¼Ç¼¾Í»á³ö´í£¿
¶Ô£¬ÊÖ¶¯¡¡OR¡¡ÓôúÂëѹËõMDB

лл£¬ÎҵijÌÐò»áÒ»Ö±ÍùÊý¾Ý¿âÀïÃæÐ´Êý¾Ý£¬ÎÒ°ÑÔÚ´¦ÀíѹËõµÄʱºò³öÎÊÌ⣬ËùÒÔÏëʹÓÃ×Ô¶¯»ØÊÕ¿Õ¼äµÄÊý¾Ý¿â¡£
ÇëÎÊsqliteÊý¾Ý¿â»á²»»á×Ô¶¯»ØÊÕ¿Õ¼äÂð£¿

¿ÉÒÔ°ìµ½µÄ¡£

½¨Ò黹ÊÇʹÓÃͼÐλ¯µÄ¹ÜÀíÈí¼þ·½±ãЩ£¬ÍƼö¸öÈí¼þ SQLite Developer£¬µ±È»SQLiteµÄͼÐλ¯¹ÜÀíÈí¼þҲͦ¶àµÄ£¬±ÈÈçSqliteMaestro¡¢SQLiteSpyµÈµÈ¶¼¿ÉÒÔ¡£¡£¡£

Èç¹û²»ÓÃÕâЩ£¬Ö±½ÓѹËõµÄ»°£¬Ò²¿ÉÒÔͨ¹ýÖ´ÐÐ VACUUM ÃüÁVACUUM ½«»á´ÓÍ·ÖØÐÂ×éÖ¯Êý¾Ý¿â¡


Ïà¹ØÎÊ´ð£º

ACCESSÊý¾Ý¿â ×ö·ÖҳдSQLµÄÎÊÌâ

select top 20 * from tb
where ×Ö¶ÎÃû not in
(select top 10 ×Ö¶ÎÃû from tb)

ÎÒÖªµÀÓÃÕâÖÖ·½·¨¿ÉÒԵõ½10-20µÄÊý¾Ý
µ«ÊÇÈç¹ûÊý¾ÝºÜ¶à
±ÈÈçselect top 100020 * from tb
where ×Ö¶ÎÃû not ......

php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......

ÓÃVB´´½¨ÁËÒ»¸ö¿ÕAccess±í£¬²»ÄÜÌí¼Ó¼Ç¼

ÓÃADO´´½¨ÁËÒ»¸ö¿ÕAccess±í£¬²¢Ìí¼ÓÁ˶à¸ö×Ö¶ÎÃû¡£
µ«ÏÖÔÚÎÊÌâÊÇ£¬²»ÄÜÏò¿Õ±íÖÐÌí¼Ó¼Ç¼¡£
ÿ´ÎÌí¼Ó¶¼»á³öÏÖ¡°BOF »ò EOF ÖÐÓÐÒ»¸öÊÇ¡°Õ桱£¬»òÕßµ±Ç°µÄ¼Ç¼Òѱ»É¾³ý£¬ËùÐèµÄ²Ù×÷ÒªÇóÒ»¸öµ±Ç°µÄ¼Ç¼¡±

......

ÓÃVBÇóACCESSÁ½¸ö±íµÄºÍ

ÓÃVBÇóACCESSÁ½¸ö±íµÄºÍ

a±íÀïÓÐ
ID Ãû³Æ ÊýÁ¿ ×ܼÛ
1  a    13  11
2  c    20  20
3  c    2    52
4  b&nb ......

ACCESSÊý¾Ý¿â¹ØÁª²éѯÎÊÌ⣿

³õÓÃACCESSÊý¾Ý¿â£¬ÒªÊµÏÖÒ»¸ö¹ØÁª²éѯ£¬sqlÓï¾äÈçÏ£ºselect pid,product_Type.name as tid,name,img_url,context,remark from Product join product_Type on product.type_id = product_Type.type_id order by pid ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ