sqlite autoincrement of primary key

D'Arcy J.M. Cain darcy at druid.net
Mon Nov 29 13:46:00 EST 2010


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.

-- 
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