On 6/9/2013 11:25 AM, E.Pasma wrote:
Possibly INSERT OR REPLACE is useful when multiple columns need to be updated.
Only in some circumstances, when suitable UNIQUE constraints are in place.
I beiieve the following statement is equivilent to the given update
Since the OP hasn't provided the definition of his table or relevant indexes, there is no way to tell what INSERT OR REPLACE would do.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
