[sqlite] Indexes on columns

Hello, My understanding is that an index is automatically created on any column that is used in the primary key (or a composite index is created if the key is composed of different columns). If this is correct then why don't I see indexes for those in my table (I'm using SQLite Administrator and

Re: [sqlite] Indexes on columns

<danielk1...@gmail.com> wrote: > On 06/24/2011 12:26 PM, logan...@gmail.com wrote: > > Hello, > > > > My understanding is that an index is automatically created on any column > > that is used in the primary key (or a composite index is created if the > key

Re: [sqlite] Indexes on columns

nks, Hitesh On Fri, Jun 24, 2011 at 5:31 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > logan...@gmail.com wrote: > > Yes, that's exactly what it is. Here is the definition of one of the > table: > > > > CREATE TABLE [Attributes] ( > > [Id] INTEGER NOT NU

Re: [sqlite] Indexes on columns

Ahh..ok, thanks for the response everyone. I really appreciate the help here :). On Fri, Jun 24, 2011 at 11:10 AM, Igor Tandetnik <itandet...@mvps.org>wrote: > On 6/24/2011 1:58 PM, logan...@gmail.com > wrote: > > Sorry, but seems like I'm missing something here. > > &g

[sqlite] ISNULL in sqlite

Hello, How do I check for a null or empty string in SQLite. SQL server has ISNULL but it doesn't seem to be supported in SQLite. Thanks, Hitesh ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] ISNULL in sqlite

Thank you everyone!! On Sat, Jun 25, 2011 at 9:27 PM, Jay A. Kreibich <j...@kreibi.ch> wrote: > On Sat, Jun 25, 2011 at 04:55:13PM -0400, Igor Tandetnik scratched on the > wall: > > logan...@gmail.com wrote: > > > How do I check for a null or empty string in SQLi

Re: [sqlite] ISNULL in sqlite

Yes, I'm checking for empty string, but it wasn't working for null. The suggestions by kind people here helped resolve it. Thank you! On Mon, Jun 27, 2011 at 11:16 AM, Gerry Snyder <mesmerizer...@gmail.com>wrote: > On 6/25/2011 12:33 PM, logan...@gmail.com wrote: > > Hello, &