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 F
nnedy 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
> > is composed of differ
t it.
Thanks,
Hitesh
On Fri, Jun 24, 2011 at 5:31 AM, Igor Tandetnik 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 NULL PRIMARY KEY
Ahh..ok, thanks for the response everyone. I really appreciate the help here
:).
On Fri, Jun 24, 2011 at 11:10 AM, Igor Tandetnik wrote:
> On 6/24/2011 1:58 PM, logan...@gmail.com
> wrote:
> > Sorry, but seems like I'm missing something here.
> >
> > From my un
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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-
Thank you everyone!!
On Sat, Jun 25, 2011 at 9:27 PM, Jay A. Kreibich 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 SQLite. SQL server has
> ISN
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 wrote:
> On 6/25/2011 12:33 PM, logan...@gmail.com wrote:
> > Hello,
> >
> > How
7 matches
Mail list logo
