On Fri, 3 Aug 2012 10:08:56 -0300, Brandon Pimenta
<brandonskypime...@gmail.com> wrote:

>I cannot use AUTO_INCREMENT. Here's my query:
>
>CREATE TABLE test (
>test_1 NOT NULL AUTO_INCREMENT
>);
>
>Running this query gives me "SQL error: near "AUTO_INCREMENT": syntax
>error". What does this mean?

The keyword is AUTOINCREMENT, without underscore.
It will only work on INTEGER PRIMARY KEY columns.

http://www.sqlite.org/lang_createtable.html


-- 
Regards,

Kees Nuyt

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to