ÈçºÎÔÚsqliteÖÐɾ³ýÇ°NÌõ¼Ç¼
ÈçÌ⣬ûÓÐÖ÷¼ü£¬ÎÒֻҪɾ³ýÇ°NÌõ¼Ç¼¡£nÊýÖµ´ó¸ÅÔÚǧÍò¼¶±ðµÄ¡£
ûÓÐÖ÷¼ü ÓÐûÓÐÆäËü¿É¹©ÅÅÐòµÄ×ֶΣ¿ SQL code: delete from tb where id in (select top n id from tb)ÒýÓà ûÓÐÖ÷¼ü ÓÐûÓÐÆäËü¿É¹©ÅÅÐòµÄ×ֶΣ¿ Óеġ£¿ÉÊÇÊý¾ÝÉÏǧÍòÌõµÄ delete from tt where ÅÅÐòµÄ×ֶΠin (select ÅÅÐòµÄ×ֶΠfrom tt order by ÅÅÐòµÄ×ֶΠlimit 0,n-1) ×µÄÇé¿ö£ºÕâЩÊý¾Ý¶¼ÊÇÏàͬµÄÔõô°ìÄØ£¿ ¼ÓÈë×ÔÔö×Ö¶ÎIDÒýÓà ÒýÓà 1 Â¥ acmain_chm µÄ»Ø¸´: ûÓÐÖ÷¼ü ÓÐûÓÐÆäËü¿É¹©ÅÅÐòµÄ×ֶΣ¿ Óеġ£¿ÉÊÇÊý¾ÝÉÏǧÍòÌõµÄ SQL code: delete from yourTable order by ÅÅÐòµÄ×ֶΠlimit n ²âÊÔÁËһϣ¬4Â¥µÄ´úÂë¿ÉÒÔͨ¹ý µÄÈ·¿ÉÒÔ£¬¾ÍÊÇЧÂÊÌ«µÍ£¬ÎÒÊý¾Ý¿âÖÐÓнüÒÚÌõÊý¾Ý£¬Ò»´Îɾ³ý1000ÍòÌõµÄ¡£ ÓеãÂýÒýÓà ÎÒÊý¾Ý¿âÖÐÓнüÒÚÌõÊý¾Ý£¬Ò»´Îɾ³ý1000ÍòÌõµÄ¡£ delete from yourTable order by ÅÅÐòµÄ×ֶΠlimit n ×îºÃÔÚ ÅÅÐòµÄ×ֶΠÉÏË÷Òý¡£ Á½ÖÖ˼·£º 1ÖÖÊÇÖ±½Óɾ³ý 1ÖÖÊǽ«Ê£ÓàµÄ¼Ç¼Éú³Éбí
Ïà¹ØÎÊ´ð£º
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿ ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
c# + sqlite ³ö´í£¡£¡£¡ File opened that is not a database file file is encrypted or is not a database ºÍÒÔÇ°Ò»ÑùµÄд£¬ÔõôÕâ´Î¾ÍÊDz»Ðа¡£¡£¡£¡ ÎÒ¿ì²»ÐÐÁË£¬´ó¼Ò°ï°ïÎÒ°¡£¡£¡£¡ ¼û¹ýһƪÎÄÕÂÊÇ˵Õâ¸ö
......
ÇëÎʸ÷λ´ó¸ç,ËÓÐÉú³É·ÃÎÊsqliteÊý¾Ý¿âµÄ´úÂëÉú³ÉÆ÷,·üÍû´ó¼Ò°ïæ... СµÜ¼±Óà wuyq11 (ÈËÉúÈçÃÎ) ÄúºÃ,wuyq11 UcfarDBAÊÇÔõôʹÓõÄ,СµÜ¿´µ½ÀïÃæÖ»ÓÐcstÎļþ,Ó¦¸ÃÊÇÄ£°å,ÕâЩģ°åÒªÔõÃ´Ê ......