On 04-Feb-2008, at 3:41 PM, Dennis Volodomanov wrote:
> Is that possible? If not, I'll have to do it in the code, but that
> will
> probably be slower and I'm expecting to have tens of thousands of
> rows.
Sure:
sqlite> create table x(a);
sqlite> insert into x(a) values('ABC');
sqlite> insert into x(a) values('DEF');
sqlite> alter table x add column b;
sqlite> update x set b=lower(a);
sqlite> select * from x;
ABC|abc
DEF|def
sqlite>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
