Perfect. Thanks guys. On Sat, Oct 25, 2014 at 10:03 AM, Simon Davies <simon.james.dav...@gmail.com > wrote:
> On 25 October 2014 14:49, Stephen Chrzanowski <pontia...@gmail.com> wrote: > > I've got a table that has defaults set for all fields > > > > CREATE TABLE [tEvents] ( > > [EventID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, > > [Airline] CHAR DEFAULT '', > > [TicketID] INTEGER DEFAULT 0, > > [Resolved] BOOL DEFAULT 0); > > > > > > Seems to me it'd be a bit redundant to do an "insert into tEvents > > (TicketID) values (0)" when the default is already set (And who says I > may > > not want to change the default later to -1 for whatever reason?). > > > > The question is, how would I insert a blank row and rely on the defaults > > I've got in the schema? "insert into tEvents () values ()" fails, as > does > > removing the first pair of brackets, as well as removing all brackets. > > INSERT INTO tEvents( EventId ) VALUES( null ); > > Regards, > Simon > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
