Re: [sqlite] What is the column value after ALTER TABLE ADD COLUMN?

On Fri, May 18, 2007 at 14:00:21 -0500, Doug Nebeker wrote: > UPDATE xyz SET newcol=function(other_column) WHERE newcol=null; > > Both of the above fail. What is the value in newcol? The value is NULL, however you have to say "IS NULL": UPDATE xyz SET newcol=function(other_column) WHERE

[sqlite] What is the column value after ALTER TABLE ADD COLUMN?

I must be missing something obvious and I'm hoping someone can help me out. I have an existing table and add a new column: ALTER TABLE xyz ADD COLUMN newcol TEXT; Next I want to set some default values to the new column. Because this code could potentially get executed later, I'm trying to