sqlite (1)near“增量”:更改表时出现语法错误

8ljdwjyq  于 2023-10-23  发布在  SQLite
关注(0)|答案(2)|浏览(224)

我尝试修改一个SQLite表,定义如下:

String CREATE_TABLE="CREATE TABLE IF NOT EXISTS " + tab_NAME + " ("
                            + row_ID + " INTEGER PRIMARY KEY , "
                            + row_NAME + " TEXT, "
                            + row_EMAIL + " TEXT, "
                            + row_WEBSITE + " TEXT, "
                            + row_TELEPHONE1 + " TEXT, "
                            + row_TELEPHONE2 + " TEXT, "
                            + row_TELEPHONE3 + " TEXT, "
                            + row_TELEPHONE4 + " TEXT, "
                            + row_TELEPHONE5 + " TEXT);";
        db_name.execSQL(CREATE_TABLE);

        String newTab="CREATE TABLE IF NOT EXISTS temp ("
                + row_ID + " INTEGER PRIMARY KEY AUTOINCREMENT , "
                + row_NAME + " TEXT, "
                + row_EMAIL + " TEXT, "
                + row_WEBSITE + " TEXT, "
                + row_TELEPHONE1 + " TEXT, "
                + row_TELEPHONE2 + " TEXT, "
                + row_TELEPHONE3 + " TEXT, "
                + row_TELEPHONE4 + " TEXT, "
                + row_TELEPHONE5 + " TEXT);";
        db_name.execSQL(newTab);

下面是auto_increment alter语句:

String alter="ALTER TABLE temp AUTO_INCREMENT=1;";
    ourDatabase.execSQL(alter);

我得到一个错误说(1) near AUTO_INCREMENT: syntax error
怎么了?任何帮助?

p8h8hvxi

p8h8hvxi1#

在SQLite中,声明为INTEGER PRIMARY KEY的列将自动递增。删除AUTOINCREMENT关键字,然后尝试。
查看SQLite FAQ

sqougxex

sqougxex2#

sqlite设置列中,PRIMARY KEYAUTOINCREMENT。因此,不需要将列显式指定为AUTOINCREMENT。查看SQLite FAQ。

相关问题