Android表创建失败(接近“自动增量”:语法错误)?-AndroidtablecreationFailure(near“autoincrement”:syntaxerror)?

34  

In short: In SQLite a column declared INTEGER PRIMARY KEY will autoincrement. There is no autoincrement keyword in SQLite, that is why you are getting an error.

简而言之:在SQLite中，声明为整数的列主键将自动递增。在SQLite中没有自动递增的关键字，这就是为什么会出现错误的原因。

You can find out more on SQLite FAQ.

你可以在SQLite FAQ中找到更多信息。

EDIT: just writing integer primary key it is enough. SQLite will automatically increment your ids.

编辑:只写整型主键就够了。SQLite将自动增加您的id。

EDIT2: Your onUpgrade() method should look like this :

EDIT2:你的onUpgrade()方法应该是这样的:

  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        if (newVersion > oldVersion) {
            Log.w("MyAppTag","Updating database from version " + oldVersion + " to "
                    + newVersion + " .Existing data will be lost.");
            db.execSQL("DROP TABLE IF EXISTS " + MY_TABLE);
            db.execSQL("DROP TABLE IF EXISTS " + MY_TABLE2);
            onCreate(db);
        }

8  

This:

这样的:

+ KEY_ID2 + " integer autoincrement, " 

should be this:

应该是这样的:

+ KEY_ID2 + " integer primary key autoincrement, " 

If you follow the syntax diagrams for CREATE TABLE you'll see that autoincrement should only come after primary key.

如果您遵循CREATE TABLE的语法图，您将看到自动递增应该只出现在主键之后。

If you want _id2 to be a foreign key then you don't want it to be auto increment at all though.

如果你想让_id2是外键，那么你就不希望它是自动递增的。

3  

An above answer says that 'There is no autoincrement keyword in SQLite.' This is incorrect. There is a keyword called 'autoincrement' and I used it in the primary key.

上面的回答是“SQLite中没有自动递增的关键字”。这是不正确的。有一个关键词叫做“自动递增”，我在主键中使用了它。

For example:

例如:

   static final String CREATE_LOCATION_TABLE="CREATE TABLE Location"+
            "( LocationID INTEGER PRIMARY KEY AUTOINCREMENT," +
            " RestuarantID int not null," +
            " Latitude float not null," +
            " Longitude float not null)";

Also make sure when you enter data to this table use the keyword 'null' in the place of the primary key.

还要确保在向该表输入数据时使用关键字'null'代替主键。

Like this:

是这样的:

   static final String INSERT_LOCATION= "Insert into Location values" +
            "(null,1002,6.905369,79.851514)";

1  

Three things:

三件事:

• Remove the trailing ; from the statements.
• 消除拖尾;从语句。
• Add "primary key" constraint to the autoincrement column
• 向自动递增列添加“主键”约束
• Remove autoincrement from PK columns - it will happen automatically.
• 从PK列中删除自动增量——它将自动发生。

0  

sqlite> CREATE TABLE app (a INTEGER PRIMARY KEY NOT NULL, B VARCHAR);
sqlite> insert into app (b) values ('');
sqlite> insert into app (b) values ('a');
sqlite> 
sqlite> insert into app (b) values ('b');
sqlite> insert into app (b) values ('c');
sqlite> insert into app (b) values ('d');
sqlite> select * from app;
1|
2|a
3|b
4|c
5|d
sqlite> exit;

NOTE: IN SQLite there in no AUTOINCREMENT keyword. So, you have to just use INTEGER PRIMARY KEY NOT NULL. It will automatically insert the incremented value for the attribute.

注意:在SQLite中没有自动递增关键字。你只需要使用整数主键NOT NULL。它将自动插入属性的递增值。