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 into that. Then copy tho
-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 into
-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
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 have no idea where yo
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
5 matches
Mail list logo