Jean-Christophe Deschamps <[email protected]>
wrote:
> Beside the obvious update with every changed column mentionned,
>
> update tbl set col1 = (select col1 from tbl y where y.rowid =
> tbl.rowid),
> ...
> coln = (select coln from tbl y where y.rowid =
> tbl.rowid);
>
> do you think of a easier way?
Why not just
update tbl set col1 = col1;
or perhaps
update tbl set col1 = cast(col1 as text);
I'm not sure the former will actually change anything, but the latter should.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
