And your exact SQL command works fine in my 3.1.1 beta version. -----Original Message----- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Saturday, February 05, 2005 10:38 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] autoincrement weirdnesses
On Sun, 6 Feb 2005 01:17:45 -0500, Randall Randall <[EMAIL PROTECTED]> wrote: > > Okay, I know there's something obvious I must be > missing: > > sqlite> create table package (rowid integer primary key autoincrement, > name text); > SQL error: near "autoincrement": syntax error > > What am I doing wrong, here? Possibly you aren't using a version of SQLite that supports AUTOINCREMENT? I thought it was just introduced in 3.1.