ÈçºÎÔÚ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ÖÖÊǽ«Ê£ÓàµÄ¼Ç¼Éú³Éбí
Ïà¹ØÎÊ´ð£º
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~ Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ. ÒýÓà Դ´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ. ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£ create table users(name text, number text); Ñ»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£ ¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£ ¿ÉÄÜÊÇÄÄ·½ÃæµÄÔÒòµ¼ ......
c# + sqlite ³ö´í£¡£¡£¡ File opened that is not a database file file is encrypted or is not a database ºÍÒÔǰһÑùµÄд£¬ÔõôÕâ´Î¾ÍÊDz»Ðа¡£¡£¡£¡ ÎÒ¿ì²»ÐÐÁË£¬´ó¼Ò°ï°ïÎÒ°¡£¡£¡£¡ ¼û¹ýһƪÎÄÕÂÊÇ˵Õâ¸ö
......