How to create a query string using SQLiteOpenHelper class?

Question

I want to create a table with an ID and an UNIQUE TEXT field such using:

@Override   
public void onCreate(SQLiteDatabase db) 
{   
    String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_POSTS + "("
    + KEY_ID + " INTEGER PRIMARY KEY AUTO_INCREMENT," + KEY_URL + " TEXT UNIQUE NOT NULL"+")";
    db.execSQL(CREATE_CONTACTS_TABLE);  
}

But this isn't working.

07-23 10:35:53.937: E/AndroidRuntime(19078): android.database.sqlite.SQLiteException: near "AUTO_INCREMENT": syntax error: CREATE TABLE posts(id INTEGER PRIMARY KEY AUTO_INCREMENT,url TEXT UNIQUE NOT NULL)

How can I fix this ?

Peshal · Accepted Answer · 2013-07-23 03:58:07Z

1

The Integer primary key in SQlite is AutoIncrement by default so remove the Auto Increment. Here is the documentation SQLite FAQ

answered Jul 23, 2013 at 3:58

Peshal

1,5281 gold badge12 silver badges22 bronze badges

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

1 Comment

user2553773 Over a year ago

Thank you, but if i use AUTOINCREMENT instead of AUTO_INCREMENT then it worked. I faced a new problem with Inserting values to database on Error inserting ... error code: 19 - Contraint failed. May be Only one primary and no UNIQUE another one column can exist in table?

ObieMD5 · Accepted Answer · 2013-07-23 04:01:32Z

0

This will work to create the table, I tested it within my application and worked fine.

@Override   
public void onCreate(SQLiteDatabase db) 
{   
    String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_POSTS + " ("
    + KEY_ID + " INTEGER PRIMARY KEY, " + KEY_URL + " TEXT UNIQUE NOT NULL"+")";
    db.execSQL(CREATE_CONTACTS_TABLE);  
}

answered Jul 23, 2013 at 4:01

ObieMD5

2,6571 gold badge18 silver badges26 bronze badges

1 Comment

user2553773 Over a year ago

Thank you. It OK and as Peshal told me that autoincrement is default.

outcast · Accepted Answer · 2013-07-23 04:04:15Z

0

change AUTO_INCREMENT to autoincrement.

answered Jul 23, 2013 at 4:04

outcast

5681 gold badge6 silver badges20 bronze badges

2 Comments

user2553773 Over a year ago

Thank you. But Error on inserting value: contraint failed. What is it can be?

outcast Over a year ago

I need more infomation.

Collectives™ on Stack Overflow

How to create a query string using SQLiteOpenHelper class?

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related