Hi,
On 6/28/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
"integer primary key" is special, and the only column "autoincrement"
can be applied to. It's not a general-purpose sequence option, like
some other database engines.
Yep, I knew that.
The problem is that, with a table created like this:
sqlite> CREATE TABLE t1 (a INTEGER AUTO INCREMENT NOT NULL, b TEXT,
PRIMARY KEY (a));
An inserting like this:
sqlite> INSERT INTO t1 (b) VALUES ('bruno');
Doesn't work. The error is:
SQL error: t1.a may not be NULL
See http://sqlite.org/autoinc.html
There's nothing about insertions in this link...
=(
Thanks!
Regards.
Bruno
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
--
/**
* Bruno Silva de Oliveira
* Bacharel em Ciência da Computação
* Mestrando em Inteligência Computacional
* http://www.inf.ufpr.br/brunoso/
*
* http://www.last.fm/user/bsoliveira/
*/
