[Cialug] SQL Question: Advanced INSERT INTO

[Dave Weis]

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.

--
Todd
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug