13
An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
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 eve
Lite 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) Ids shall be indicative of the country the employee is located in at the
time of hiring
x)
lists.sqlite.org] Im
Auftrag von x
Gesendet: Montag, 08. Jänner 2018 16:59
An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
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
2018 16:59
An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
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
mailing list'
Subject: Re: [sqlite] [EXTERNAL] Re: difference between 'ID IS NULL' and 'ID =
NULL'
>-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
>-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 <sqlite-users@mailinglists.sqlite.org>
>Betreff: [EXTERNAL] Re: [sqlite] differ
6 matches
Mail list logo