Thanks Clemens, that was it (the comma). That was a mildly embarrassing
oversight.
Thanks again,
Jonathan
On 2019-02-25 12:52, Clemens Ladisch wrote:
Jonathan Moules wrote:
UPDATE lookups set error_code=3 and exp_content_type='ogc_except' WHERE
content_hash = '0027f2c9b80002a6';
This fails because "3 and exp_content_type='ogc_except'" is interpreted as
a boolean expression.
To update multiple fields, separate them with commas:
UPDATE lookups set error_code=3, exp_content_type='ogc_except' WHERE ...
^
UPDATE lookups set error_code=3 and WHERE content_hash = '0027f2c9b80002a6';
This is not valid SQL ("and WHERE").
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
