Re: [sqlite] resetting a column back to its default value

Hello Puneet, I guess I can select and reinsert all columns except for the column with the default value. I guess it would be nice (efficient) to update a single column to its default value via the update command. Thanks, -Alex On Tue, Mar 25, 2008 at 1:40 PM, P Kishor <[EMAIL PROTECTED]> wrot

Re: [sqlite] resetting a column back to its default value

Hello Puneet, On Tue, Mar 25, 2008 at 1:40 PM, P Kishor <[EMAIL PROTECTED]> wrote: > On 3/25/08, Alex Katebi <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I was woundering how I can update a column in my table back to its > default > > value. > > > > For example: > > > > create table t1 (value

Re: [sqlite] resetting a column back to its default value

Alex Katebi wrote: > > 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 */ > This will

Re: [sqlite] resetting a column back to its default value

On 3/25/08, Alex Katebi <[EMAIL PROTECTED]> wrote: > 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;

[sqlite] resetting a column back to its default value

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 o