On Sat, Oct 25, 2014 at 9:49 AM, 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); > > > The question is, how would I insert a blank row and rely on the defaults > I've got in the schema? > INSERT INTO tEvents DEFAULT VALUES; -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
