Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ö®Database is lockedÎÊÌâ

»·¾³£ºQNX 6.3.2
°æ±¾£ºSQLite 2.7.3
ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ
 database is locked
Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£
Áí£ºÔÚһ̨Íê ......

sqlite ÎÞ·¨¸ù¾ÝGuid ²éѯÊý¾Ý

GUID£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7

SELECT fldGuid, fldName, fldUserGuid from table
Äܲéѯ fldUserGuid Ϊ£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7 µÄÊý¾ÝÒ»Ìõ

SELECT fldGuid, fldN ......

delphi ÔõôÑùʹÓÃsqliteÊý¾Ý¿â£¿

ÊÖÍ·ÓÐÒ»¸öСCASE£¬ÒªÓõ½Êý¾Ý¿â£¬Ïë²ÉÓÃSQLite¡£
ÓÐÓùýµÄÅóÓÑÂð£¿
ÒªÔõô°²×°sqlite·þÎñ£¿»¹ÊDz»ÐèÒª°²×°£¿
ÓÃʲôÈí¼þÀ´¹ÜÀíSqliteÊý¾Ý¿â£¿ÈçÌí¼Ó±í£¬Ð´´æ´¢¹ý³ÌµÈ¡£
delphiÖÐÔõôÑùÁ¬½Óµ½sqliteÊý¾Ý¿â£¿ÓÃʲ ......

Çë½ÌÒ»¸ö¹ØÓÚSqliteÊý¾Ý¿âµÄÎÊÌâ

¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»

select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿

ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......

vb.netÈçºÎ²Ù×÷sqliteÊý¾Ý¿â - .NET¼¼Êõ / VB.NET

±ÈÈ磺
1¡¢Á¬½ÓÊý¾Ý¿â£»
2¡¢½¨±í£¬insert ¡¢update,delete,selectÈçºÎд£¿
ÊDz»ÊÇÒªÏÂÔØ ADO.NET 2.0 ÒýÇæ£¿
sqliteʹÓÃÊÖ²á

ллqshurufa£¬ÎÒÏëÖªµÀÈçºÎͨ¹ývb.netʵÏÖ£¬¾ÍÊÇÓï¾äզд£¿

Dim Conn As New ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ