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

ÈçºÎÔÚ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ÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>
SQLITEϲ»ºÃÓà
Ìáʾ: 
sqlite error 
no such function: stuff 
Ôõô½â¾ö?
SQL code:
--------------------------------------------- ......

sqlite ¸ßÊÖ½øÀ´°¡

СµÜ Ūµã¶«Î÷¿ÉÊǵ÷Óà sqlite3_prepare Õâ¸öº¯Êý select ¾ÍºÃʹ Ö»Òª ¸Ä±äÊý¾Ý¿â µÄ¾Í²»ÐÐ ±ÈÈçinsert Ö®ÀàµÄ Ë­À´°ï¸öæ°¡ ÇëÎÊÕâÊÇʲôԭÒò °¡ Óà c ȥʵÏÖµÄ
ÄãÓõÄʲô¹¤¾ß°¡?
°ÑÄã×Ô¼ºµÄ´úÂë·¢ ......

¹ØÓÚsqliteµÄÎÊÌâ

ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£

ÎÊÌ⣺ÈçºÎÊ¹Ó ......

sqlite´´½¨µÄ±íû±£´æ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

¸Õѧsqlite£¬´´½¨Á˸ö±í£¬Í˳ösqliteÓÖÖØÐ´ò¿ªºó£¬²éѯ˵ûÓÐÕâ¸ö±í¡£ÔõôÑù²ÅÄܱ£´æÕâ¸ö±íÄØ£¬windowsÏÂ

Ö±½ÓÔËÐÐsqlite3.exe,È»ºó¾Í¾ÍÖ±½Ócreate table TestÁË
Í˳ösqlite3.exe ÖØÐ´ò¿ª£¬select¾ÍÌáʾûÓÐÕâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ