Sqlite Query Error

Question

I am using sqlite db in android.
In this I need to give Id as autoincrement and second 'Incoming_sms' field as primary key. but it shows me error as below:

detailMessage "near "AUTOINCREMENT": syntax error:  
CREATE TABLE TwoWayTable111 (
  ID INTEGER AUTOINCREMENT,  
  INCONMING_MSG TEXT PRIMARY KEY,  
  OUTGOING_MSG TEXT,  
  STATUS TEXT )"

Why does this error occur? But when I give id as autoincrement and primary key, it works fine.

Mike Sherrill 'Cat Recall' · Accepted Answer · 2011-05-21 13:53:38Z

1

This is a FAQ. It works as designed. This statement returns a syntax error.

create table test (id integer autoincrement);

This one runs without error.

create table test (id integer primary key autoincrement);

You should be able to do this.

CREATE TABLE TwoWayTable111 (
    ID INTEGER PRIMARY KEY, 
    INCONMING_MSG TEXT NOT NULL UNIQUE, 
    OUTGOING_MSG TEXT, 
    STATUS TEXT );

answered May 21, 2011 at 13:53

Mike Sherrill 'Cat Recall'

96.6k20 gold badges134 silver badges195 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqlite Query Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related