[Cialug] SQL Question: Advanced INSERT INTO
djweis at internetsolver.com
Fri Sep 3 16:53:33 CDT 2010
The way I design a schema I would use a sequence and put nextval('seqname') in the location.
----- Original Message -----
From: cialug-bounces at cialug.org <cialug-bounces at cialug.org>
To: Central Iowa Linux Users Group <cialug at cialug.org>
Sent: Fri Sep 03 16:40:53 2010
Subject: Re: [Cialug] SQL Question: Advanced INSERT INTO
On Fri, Sep 3, 2010 at 2:41 PM, Josh More
<MoreJ at alliancetechnologies.net> wrote:
> Most databases will have the primary key set to a SERIAL type or the like, so it should auto increment. Just leave that field blank and do a test INSERT. See if it autofills.
Ah. I knew there must be some way of handling this. It seems too
integral to the task to not have some way of handling it.
But I checked, it's an int.
Cialug mailing list
Cialug at cialug.org
More information about the Cialug