[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQL Q's.

To: linuxkb-list@seul.org
Subject: Re: SQL Q's.
From: Jason Pincin <jpincin@linuxkb.org>
Date: Sun, 22 Aug 1999 17:50:10 -0400
In-Reply-To: <37BF80FD.2D76A239@cyberis.net>; from Micah Yoder on Sat, Aug 21, 1999 at 09:47:57PM -0700
References: <Pine.LNX.4.10.9908211359490.23282-100000@vodka.linuxkb.org> <37BF80FD.2D76A239@cyberis.net>
Reply-To: linuxkb-list@seul.org
Sender: owner-linuxkb-list@seul.org

> > 3) How do I insert a row in a table for which the primary key is
> > auto-incrementing or not auto-inc?
> When it auto-incs, I believe you can  just leave that field out of your list.

In some DB's you can leavie it out of the list, but in MySQL you have to
insert a '' for that field, symbolizing a NULL.

Follow-Ups:
- Re: SQL Q's.
  - From: Micah Yoder <LYoder@cyberis.net>

References:
- SQL Q's.
  - From: Aaron Turner <aturner@linuxkb.org>
- Re: SQL Q's.
  - From: Micah Yoder <LYoder@cyberis.net>

Prev by Date: Re: SQL Q's.
Next by Date: More DB Q's.
Prev by thread: Re: SQL Q's.
Next by thread: Re: SQL Q's.
Index(es):
- Date
- Thread