On 30 Aug 2017, at 12:19pm, Ali Dorri <alidorri...@gmail.com> wrote:
> 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' ; That syntax is correct. In your previous example you were using "AND" where you should have had a comma. > Another issue I have is that when I remove these entries, the size of the > database does not decrease. The above command does not delete a row. It overwrites a couple of fields in the row with nulls. Which will cause confusion because one of those fields is your primary key and it won’t work. To delete a row, which is probably what you should be doing, use the DELETE command, e.g. DELETE FROM BS WHERE PK = '%q'; Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
