sqlite autoincrement of primary key

Tim Harig usernet at ilthio.net
Mon Nov 29 20:11:18 CET 2010

On 2010-11-29, D'Arcy J.M. Cain <darcy at druid.net> wrote:
> On Mon, 29 Nov 2010 13:19:19 -0500
> Mel <mwilson at the-wire.com> wrote:
>> tinauser wrote:
>> '''INSERT INTO foo VALUES (NULL, ?)'''
> Does this work in SQLite:
>   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.

More information about the Python-list mailing list