ACCESS ½¨Á¢¶à±íÎÊÌâ
ÎÒÏÖÔÚÒªÔÚÒ»¸öaccessÊý¾Ý¿âÀïÃæ½¨Á¢2¸ö±í
Ò»¸ödata1 Ò»¸ödata2£»
µ«Êǽ¨Á¢Íê³Éºó ÎÒ·¢ÏÖÒ»¸öÎÊÌâ
ÎÒÏȽ¨Á¢data1ºó ½«Êý¾Ýµ¼Èëºó ´óСΪ197M
ÔÚ½¨Á¢data2 µ¼ÈëÊý¾Ý ´óС»¹ÊÇ197M
ÕâÈÃÖ±½Óµ¼ÖÂÎÒ³ÌÐò²éѯ²»Òªdata2 ˵ÊÇdata2²»´æÔÚ
µ«ÊÇ ÎÒ´ò¿ªÊý¾ÝÃ÷ÏÔ¿´µ½ÁËdata2ÀïÃæµÄÊý¾Ý
µ«ÊÇÎÒµ¥¶À½«data1 ºÍdata2 ·ÅÔÚ²»Í¬µÄaccessÀïÃæ Ò»¸ö197 Ò»¸ö137
ÔÚÏßÇó¾È........
e ÖØÀ´Ã»Óùýaccess
ûÓöµ½¹ýÕâÖÖÇé¿ö
²Î¿¼£º
http://school.itzcn.com/special-spid-12.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£
ÎÊÌâ½â¾öÁË µ«ÊÇ´óСÎÒ»¹ÊǺÜÄÉÃÆ
µ¼ÈëÒ»¸ö±íºó´óСû±ä Ææ¼£ÁË
Ïà¹ØÎÊ´ð£º
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......