On 9/11/08, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> P Kishor <[EMAIL PROTECTED]> wrote:
> > why? Because INTEGER PRIMARY KEY already provides AUTOINCREMENT
>
>
> There's a difference in using INTEGER PRIMARY KEY with and without
> AUTOINCREMENT keyword: http://www.sqlite.org/autoinc.html
>
>
P Kishor <[EMAIL PROTECTED]> wrote:
> why? Because INTEGER PRIMARY KEY already provides AUTOINCREMENT
There's a difference in using INTEGER PRIMARY KEY with and without
AUTOINCREMENT keyword: http://www.sqlite.org/autoinc.html
Igor Tandetnik
___
sq
Thomas DILIGENT wrote:
> I have 2 tables:
>
> A: _ID autoinc primary key
>name text
>b integer foreign key to table B
>
> B: _ID autoinc primary key
>name text
>
> In sql:
> CREATE TABLE "A" ("_ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "name"
> TEXT, "b" INTEGER NOT NULL
On 9/11/08, Thomas DILIGENT <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have 2 tables:
>
> A: _ID autoinc primary key
>name text
>b integer foreign key to table B
>
> B: _ID autoinc primary key
>name text
>
> In sql:
> CREATE TABLE "A" ("_ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NUL
Hi,
I have 2 tables:
A: _ID autoinc primary key
name text
b integer foreign key to table B
B: _ID autoinc primary key
name text
In sql:
CREATE TABLE "A" ("_ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "name"
TEXT, "b" INTEGER NOT NULL DEFAULT '0')
CREATE TABLE "B" ("_ID" INTE
5 matches
Mail list logo