Re: [sqlite] Clarification about NULL NOT Constraints

On Tue, Apr 24, 2012 at 09:03:34AM -0700, stefanos sofroniou scratched on the wall: > Dear all, > > I have been gazing my code for amount 20 minutes now and I really need your > help with this silly yet simple code. > > CREATE TABLE testing( > id integer primary key, > name text not null defaul

[sqlite] Clarification about NULL NOT Constraints

Dear all, I have been gazing my code for amount 20 minutes now and I really need your help with this silly yet simple code. CREATE TABLE testing( id integer primary key, name text not null default 'hello'); * If I insert an empty row with null values, it does not work. * If I i