sqlite autoincrement of primary key

Tim Harig usernet at ilthio.net
Mon Nov 29 16:58:29 EST 2010


On 2010-11-29, D'Arcy J.M. Cain <darcy at druid.net> wrote:
> 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.

That, I don't know.  I would agree that it seems like a mis-guided
approach; but, it is what he asked for.



More information about the Python-list mailing list