On 6/28/07, Bruno S. Oliveira <[EMAIL PROTECTED]> wrote:
Does the sqlite auto_increment work only with primary keys WITHOUT the not null constraint? The same query on the same table worked on MySQL.
"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. See http://sqlite.org/autoinc.html ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------