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

ACCESSɾ³ý×îÇ°Ò»ÐУ¬ÒªÔõô×ö

ACCESS´æ·Å¼à¿ØÊý¾Ý£¬ÐÂÊý¾Ý²»¶Ï½øÀ´£¬ËùÒÔÒª°Ñ×îÇ°µÄÊý¾Ýɾµô£¬Çë½ÌÒ»ÏÂÒªÔõô×ö¡£
Èç¹ûÓÐ×ÔÔö×Ö¶Î..ɾ³ý×îСµÄÄĸö²»¾Í¿ÉÒÔÁË?

°´¼ÓÈëʱ¼äɾ³ý¡£ÉèÖÃÒ»¸öʱ¼ä¶Î£¬Èç¹ûʱ¼ä¶Î¹ýÁË£¬¾ÍÄÜɾ³ý¡£

delete from tb where _id=(select min(_id) from tb)

SQL code:
DELETE TB WHERE TIME <(SELECT MAX(TIME) from TB)



Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎÎ ......

access²»ÄÜÐÞ¸ÄÄÚÈÝ

ÈçÌâÔÚÎÒ´ò¿ªaccessÐ޸ĵÄʱºò±¨´í
ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡
´íÎóÇ©Ãû
AppName: msaccess.exe      AppVer: 11.0.8166.0    AppStamp:46437912
ModName: pintlgnt.ime&n ......

Çë½ÌÒ»¸öACCESSµÄ²éѯÓï¾ä£¡

Òª×éºÏ4ÕűíµÄ²éѯ£¬·Ö±ðÊÇA±í£¬B±í£¬C±í£¬D±í£»
A±í
Game_id  Game_Name
  1        abc


B±í
Category_ID  Category_Name  Game_id
  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ