Perhaps:
DELETE FROM BC WHERE PK = '%q';
Also note, the DB size may or may not decrease when deleting, it clears
data, not space.
You can use this SQL:
VACUUM;
to get rid of empty space in the DB file and re-pack it correctly.
On 2017/08/30 1:19 PM, Ali Dorri wrote:
Hi,
Thanks, now it works and removes all except for the PK. How can I remove
the PK then? i.e. what is the correct way of doing the following?
UPDATE BC set Signature = null , PK = null where PK = '%q' ;
Another issue I have is that when I remove these entries, the size of the
database does not decrease. I do the VACUUM after the program, but it does
not work and the size of the database does not decrease while the data are
removed.
Can anyone help me in this regard?
Thanks
On Wed, Aug 30, 2017 at 8:49 PM, Clemens Ladisch <clem...@ladisch.de> wrote:
Ali Dorri wrote:
I encode the PKs to base64
[...]
The PK is a BLOB type, i.e.,
sql = "CREATE TABLE BC(" \
"PK BLOB ," \
Why do you store a text value in a blob field?
"UPDATE BC set Signature = null and PK = null where PK = '%q' ;
That does not update the PK column.
UPDATE BC set Signature = null , PK = null where PK = '%q' ;
^^^^
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
