ÈçºÎÔÚ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
Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£
Áí£ºÔÚһ̨Íê ......
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
¸Õѧsqlite£¬´´½¨Á˸ö±í£¬Í˳ösqliteÓÖÖØÐ´ò¿ªºó£¬²éѯ˵ûÓÐÕâ¸ö±í¡£ÔõôÑù²ÅÄܱ£´æÕâ¸ö±íÄØ£¬windowsÏÂ
Ö±½ÓÔËÐÐsqlite3.exe,È»ºó¾Í¾ÍÖ±½Ócreate table TestÁË
Í˳ösqlite3.exe ÖØÐ´ò¿ª£¬select¾ÍÌáʾûÓÐÕâ ......