android.database.sqlite.SQLiteException: near "(": syntax error (code 1):

Question

I want to create table in DB, but I get SQLiteException:

This is my SQL-request for creating table:

String SQL_CREATE_TEMP_CATALOG_CAR_TABLE  = "CREATE TABLE temp_dn_catalog_car (\n"+
        "  catalog_car_id INTEGER PRIMARY KEY AUTOINCREMENT(11) NOT NULL, \n"+
        "  model_id INTEGER KEY(11) NOT NULL, \n"+
        "  generation_id INTEGER KEY(11) NOT NULL, \n"+
        "  body_type_id INTEGER KEY(11) NOT NULL, \n"+
        "  modification_id INTEGER KEY(11) NOT NULL, \n"+
        "  begin_year INTEGER(11) NOT NULL, \n"+
        "  end_year INTEGER(11) NOT NULL);\n";

Error code:

android.database.sqlite.SQLiteException: near "(": syntax error (code 1): , while compiling: CREATE TABLE temp_dn_catalog_car (  catalog_car_id INTEGER PRIMARY KEY AUTOINCREMENT(11) NOT NULL,   model_id INTEGER KEY(11) NOT NULL,   generation_id INTEGER KEY(11) NOT NULL,   body_type_id INTEGER KEY(11) NOT NULL,   modification_id INTEGER KEY(11) NOT NULL,   begin_year INTEGER(11) NOT NULL,   end_year INTEGER(11) NOT NULL);

IntelliJ Amiya · Accepted Answer · 2015-10-16 13:36:15Z

3

String SQL_CREATE_TEMP_CATALOG_CAR_TABLE  = "CREATE TABLE temp_dn_catalog_car (+
    "  catalog_car_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, +
    "  model_id INTEGER KEY(11) NOT NULL, +
    "  generation_id INTEGER KEY(11) NOT NULL, +
    "  body_type_id INTEGER KEY(11) NOT NULL, +
    "  modification_id INTEGER KEY(11) NOT NULL, +
    "  begin_year INTEGER(11) NOT NULL, +
    "  end_year INTEGER(11) NOT NULL); ";

answered Oct 16, 2015 at 13:36

IntelliJ Amiya

75.8k15 gold badges169 silver badges199 bronze badges

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

2 Comments

IntelliJ Amiya Over a year ago

I am not sure its perfect or not .Just remove /n and AUTOINCREMENT(11)

IntelliJ Amiya Over a year ago

Courtesy goes to @lad2025

Lukasz Szozda · Accepted Answer · 2015-10-16 13:33:39Z

1

Remove \n characters and AUTOINCREMENT(11) to AUTOINCREMENT:

String SQL_CREATE_TEMP_CATALOG_CAR_TABLE  = 
       "CREATE TABLE temp_dn_catalog_car (catalog_car_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,model_id INTEGER NOT NULL, generation_id INTEGER  NOT NULL, body_type_id INTEGER NOT NULL, modification_id INTEGER NOT NULL, begin_year INTEGER NOT NULL, end_year INTEGER NOT NULL); ";

SqlFiddleDemo

edited Oct 16, 2015 at 13:33

answered Oct 16, 2015 at 13:17

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

3 Comments

Lukasz Szozda Over a year ago

@ShevchenkoArtem And you cannot share error code, right?

IntelliJ Amiya Over a year ago

@ShevchenkoArtem post logcat ,Because this answer probably perfect

Lukasz Szozda Over a year ago

@ShevchenkoArtem AUTOINCREMENT(11) => AUTOINCREMENT

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteException: near "(": syntax error (code 1):

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related