sqlite autoincrement of primary key

D'Arcy J.M. Cain darcy at druid.net
Mon Nov 29 16:49:31 EST 2010


On Mon, 29 Nov 2010 19:11:18 +0000 (UTC)
Tim Harig <usernet at ilthio.net> wrote:
> >   INSERT INTO foo (name) VALUES ('xxx')
> >
> > That's the standard SQL way.
> 
> Yes, it works; but, the OP asked specifically to be able to enter all of
> the field values, including the autoincrement field.

You're right, I missed that.  However reading the OP's message I am
still confused.  How does removing the field name and adding a
positional NULL or None improve readability.  I now wonder if it was
more of an assignment requirement rather than a real one.

-- 
D'Arcy J.M. Cain <darcy at druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.



More information about the Python-list mailing list