Hi,

I was woundering how I can update a column in my table back to its default
value.

For example:

create table t1 (value integer default 55, name text);
insert into t1(name) values('hello');
update t1 set value=default;  /* for illustration only */

How can I achive the desired behavior short of doing "update t1 set
value=55"

Thanks,
-Alex
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to