(1) 靠近“AUTO_INCREMENT":更改表时出现语法错误 [英] (1) near "AUTO_INCREMENT": syntax error when altering table

问题描述

我正在尝试更改定义如下的 SQLite 表:

I'm trying to alter an SQLite table defined as follows:

    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 语句:

And here is the auto_increment alter statement:

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

我在 AUTO_INCREMENT 附近收到一个错误，说 (1): syntax error

I got an error saying (1) near AUTO_INCREMENT: syntax error

怎么了??有什么帮助吗??

what's wrong?? any help??

推荐答案

在 SQLite 中，声明为 INTEGER PRIMARY KEY 的列将自行自动递增.删除 AUTOINCREMENT 关键字，然后尝试.

In SQLite a column declared INTEGER PRIMARY KEY will autoincrement by itself. Remove the AUTOINCREMENT keyword and then try.

查看 SQLite 常见问题

这篇关于(1) 靠近“AUTO_INCREMENT":更改表时出现语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！