Re: [sqlite] How to skip the first field on .import

On Fri, 30 Oct 2009 12:17:53 -0700 Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Ted Rolle wrote: > > How do I let this start out at the default value and auto increment? > > My column separator is '|'. > > Create a temporary table and import

Re: [sqlite] How to skip the first field on .import

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ted Rolle wrote: > How do I let this start out at the default value and auto increment? > My column separator is '|'. Create a temporary table and import into that. Then copy those values into your permanent table using something like: insert

Re: [sqlite] How to skip the first field on .import

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ted Rolle Sent: Friday, October 30, 2009 10:36 AM To: sqlite-users Subject: [sqlite] How to skip the first field on .import The first field in my table is ID primary integer

Re: [sqlite] How to skip the first field on .import

On Fri, Oct 30, 2009 at 9:35 AM, Ted Rolle wrote: > The first field in my table is ID primary integer autoincrement. First, change the above to ID INTEGER PRIMARY KEY > I read that if it is set to NULL it defaults to the maximum value > possible.  Not a Good Thing(tm). I

[sqlite] How to skip the first field on .import

The first field in my table is ID primary integer autoincrement. I read that if it is set to NULL it defaults to the maximum value possible. Not a Good Thing(tm). How do I let this start out at the default value and auto increment? My column separator is '|'. Ted