ÈçºÎÔÚ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
SQL code:
delete from yourTable order by ÅÅÐòµÄ×Ö¶Î limit n
²âÊÔÁËһϣ¬4Â¥µÄ´úÂë¿ÉÒÔͨ¹ý
µÄÈ·¿ÉÒÔ£¬¾ÍÊÇЧÂÊÌ«µÍ£¬ÎÒÊý¾Ý¿âÖÐÓнüÒÚÌõÊý¾Ý£¬Ò»´Îɾ³ý1000ÍòÌõµÄ¡£
ÓеãÂý
delete from yourTable order by ÅÅÐòµÄ×Ö¶Î limit n
×îºÃÔÚ ÅÅÐòµÄ×Ö¶Î ÉÏË÷Òý¡£
Á½ÖÖ˼·£º
1ÖÖÊÇÖ±½Óɾ³ý
1ÖÖÊǽ«Ê£ÓàµÄ¼Ç¼Éú³Éбí
Ïà¹ØÎÊ´ð£º
»·¾³£ºQNX 6.3.2
°æ±¾£ºSQLite 2.7.3
ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ
database is locked
Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£
Áí£ºÔÚһ̨Íê ......
GUID£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7
SELECT fldGuid, fldName, fldUserGuid from table
Äܲéѯ fldUserGuid Ϊ£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7 µÄÊý¾ÝÒ»Ìõ
SELECT fldGuid, fldN ......
ÊÖÍ·ÓÐÒ»¸öСCASE£¬ÒªÓõ½Êý¾Ý¿â£¬Ïë²ÉÓÃSQLite¡£
ÓÐÓùýµÄÅóÓÑÂð£¿
ÒªÔõô°²×°sqlite·þÎñ£¿»¹ÊDz»ÐèÒª°²×°£¿
ÓÃʲôÈí¼þÀ´¹ÜÀíSqliteÊý¾Ý¿â£¿ÈçÌí¼Ó±í£¬Ð´´æ´¢¹ý³ÌµÈ¡£
delphiÖÐÔõôÑùÁ¬½Óµ½sqliteÊý¾Ý¿â£¿ÓÃʲ ......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
±ÈÈ磺
1¡¢Á¬½ÓÊý¾Ý¿â£»
2¡¢½¨±í£¬insert ¡¢update,delete,selectÈçºÎд£¿
ÊDz»ÊÇÒªÏÂÔØ ADO.NET 2.0 ÒýÇæ£¿
sqliteʹÓÃÊÖ²á
ллqshurufa£¬ÎÒÏëÖªµÀÈçºÎͨ¹ývb.netʵÏÖ£¬¾ÍÊÇÓï¾äզд£¿
Dim Conn As New ......