er 2018 19:13
An: SQLite mailing list
Betreff: Re: [sqlite] [EXTERNAL] Re: difference between 'ID IS NULL' and 'ID =
NULL'
Don't forget the automatic index that gets created when the primary key isn't
an alias of the rowid.
Also why on earth would you ever have a forei
f Hick Gunter
Sent: Monday, January 08, 2018 1:02 PM
To: 'SQLite mailing list'
Subject: Re: [sqlite] [EXTERNAL] Re: difference between 'ID IS NULL' and 'ID =
NULL'
Lets take a simple example of an employee table and couple of requirements:
x) Ids shall be non-reusable
x) Id
-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von x
Gesendet: Montag, 08. Jänner 2018 16:59
An: SQLite mailing list
Betreff: Re: [sqlite] [EXTERNAL] Re: difference between 'ID IS NULL' and 'ID =
NULL'
Gunter, doing it your way would
08. Jänner 2018 16:59
An: SQLite mailing list
Betreff: Re: [sqlite] [EXTERNAL] Re: difference between 'ID IS NULL' and 'ID =
NULL'
Gunter, doing it your way would obviously take up more space so what gains
would make up for that? Faster inserts maybe?
I tried inserting a r
difference between the two insertions although neither were exactly
lightning fast.
From: sqlite-users on behalf of
Hick Gunter
Sent: Monday, January 8, 2018 1:19:00 PM
To: 'SQLite mailing list'
Subject: Re: [sqlite] [EXTERNAL] Re: difference between &
>-Ursprüngliche Nachricht-
>Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
>Auftrag von x
>Gesendet: Montag, 08. Jänner 2018 11:39
>An: SQLite mailing list
>Betreff: [EXTERNAL] Re: [sqlite] difference between 'ID IS NULL' and 'ID =
>NULL'
>
>However, I’m still
6 matches
Mail list logo