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

Question

我想在数据库中创建表，但我得到了SQLiteException:

这是我创建表的 SQL 请求:

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";

错误代码:

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);

Answer 1

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); ";