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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
