“AUTOINCREMENT”附近的 SQLite 语法错误

尼哈尔古普塔

错误:

07-15 19:21:59.831 5770-5770/com.example.android.resumemaker E/SQLiteLog: (1) near "AUTOINCREMENT": syntax error
07-15 19:21:59.833 5770-5770/com.example.android.resumemaker D/AndroidRuntime: Shutting down VM
07-15 19:21:59.834 5770-5770/com.example.android.resumemaker E/AndroidRuntime: FATAL EXCEPTION: main
   Process: com.example.android.resumemaker, PID: 5770
   android.database.sqlite.SQLiteException: near "AUTOINCREMENT": syntax error (code 1): , while compiling: CREATE TABLE users(id INTEGER AUTOINCREMENT, name TEXT, address TEXT, phone INTEGER, email TEXT PRIMARY KEY, password TEXT, career_objectives TEXT, technical_skills TEXT, work_experience TEXT, hobbies TEXT)
       at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
       at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
       at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
       at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
       at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
       at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
       at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1675)
       at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1606)
       at com.example.android.resumemaker.UserDbHelper.onCreate(UserDbHelper.java:74)
       at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
       at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
       at com.example.android.resumemaker.MainActivity$1.onClick(MainActivity.java:31)
       at android.view.View.performClick(View.java:5612)
       at android.view.View$PerformClick.run(View.java:22285)
       at android.os.Handler.handleCallback(Handler.java:751)
       at android.os.Handler.dispatchMessage(Handler.java:95)
       at android.os.Looper.loop(Looper.java:154)
       at android.app.ActivityThread.main(ActivityThread.java:6123)
       at java.lang.reflect.Method.invoke(Native Method)
       at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:867)
       at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:757)

这是我的代码:

private static final String DB_NAME="mywbut";
private static final int DB_VERSION=3;
private static final String TABLE_NAME_1="users";
private static final String COL1_1="id";
private static final String COL1_2="name";
private static final String COL1_3="address";
private static final String COL1_4="phone";
private static final String COL1_5="email";
private static final String COL1_6="password";
private static final String COL1_7="career_objectives";
private static final String COL1_8="technical_skills";
private static final String COL1_9="work_experience";
private static final String COL1_10="hobbies";
private static final String CREATE_TABLE_1=" CREATE TABLE " + TABLE_NAME_1 + "(" +
        COL1_1+ " INTEGER AUTOINCREMENT, " + COL1_2 + " TEXT, " +
        COL1_3 + " TEXT, " + COL1_4 + " INTEGER, " + COL1_5 + " TEXT PRIMARY KEY, " +
        COL1_6 + " TEXT, " + COL1_7 + " TEXT, " + COL1_8 + " TEXT, " +
        COL1_9 + " TEXT, " + COL1_10 + " TEXT)";
杰维

自动增量仅适用于列整数 PK:

https://sqlite.org/autoinc.html

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

SQLite语法错误附近“?”

来自分类Dev

SQLITE_ERROR-SQL错误或缺少数据库(“ AUTOINCREMENT”附近:语法错误)

来自分类Dev

使用SQLite数据库创建时AutoIncrement附近的语法错误

来自分类Dev

使用SQLite数据库创建时AutoIncrement附近的语法错误

来自分类Dev

sqlite3:在“附近”。:语法错误

来自分类Dev

“ @domain” SQLite附近的语法错误

来自分类Dev

Android SQLite:SQLiteException:在“?”附近 语法错误

来自分类Dev

sqlite3:在“附近”。:语法错误

来自分类Dev

“ s”附近的SQLite Exception语法错误

来自分类Dev

“ @domain” SQLite附近的语法错误

来自分类Dev

LIKE子句附近的SQLite语法错误

来自分类Dev

SQLite CREATE TABLE [在“”附近:语法错误]

来自分类Dev

SQLite if条件-在“ CASE”附近:语法错误

来自分类Dev

语法错误android sqlite:在“组”附近

来自分类Dev

“ dasani2”附近的SQLite错误:语法错误

来自分类Dev

SQLite错误附近无此类列/语法错误

来自分类Dev

SQLite3 :: SQLException:在“ CONSTRAINT”附近:语法错误

来自分类Dev

Python sqlite3 OperationalError:“?”附近:语法错误

来自分类Dev

sqlite3.OperationalError:“”附近:语法错误

来自分类Dev

sqlite3.OperationalError:“,”附近:语法错误,请选择

来自分类Dev

续集:SQLITE_ERROR:“ []”附近:语法错误

来自分类Dev

Rails-SQLite3 :: SQLException:在“ USING”附近:语法错误

来自分类Dev

sqlite3.OperationalError:“果汁”附近:语法错误

来自分类Dev

SQLite问题sqlite3-operational错误附近语法错误

来自分类Dev

´╗┐附近的语法错误

来自分类Dev

SQLite语法错误

来自分类Dev

sqlite3.OperationalError:“ WHERE”附近:语法错误(Python 2,sqlite3)

来自分类Dev

SQLite.SQLiteException:更新SQLite中的字段时,“在“ s”附近:语法错误“

来自分类Dev

sqlite3.OperationalError:“ WHERE”附近:语法错误(Python 2,sqlite3)

Related 相关文章

  1. 1

    SQLite语法错误附近“?”

  2. 2

    SQLITE_ERROR-SQL错误或缺少数据库(“ AUTOINCREMENT”附近:语法错误)

  3. 3

    使用SQLite数据库创建时AutoIncrement附近的语法错误

  4. 4

    使用SQLite数据库创建时AutoIncrement附近的语法错误

  5. 5

    sqlite3:在“附近”。:语法错误

  6. 6

    “ @domain” SQLite附近的语法错误

  7. 7

    Android SQLite:SQLiteException:在“?”附近 语法错误

  8. 8

    sqlite3:在“附近”。:语法错误

  9. 9

    “ s”附近的SQLite Exception语法错误

  10. 10

    “ @domain” SQLite附近的语法错误

  11. 11

    LIKE子句附近的SQLite语法错误

  12. 12

    SQLite CREATE TABLE [在“”附近:语法错误]

  13. 13

    SQLite if条件-在“ CASE”附近:语法错误

  14. 14

    语法错误android sqlite:在“组”附近

  15. 15

    “ dasani2”附近的SQLite错误:语法错误

  16. 16

    SQLite错误附近无此类列/语法错误

  17. 17

    SQLite3 :: SQLException:在“ CONSTRAINT”附近:语法错误

  18. 18

    Python sqlite3 OperationalError:“?”附近:语法错误

  19. 19

    sqlite3.OperationalError:“”附近:语法错误

  20. 20

    sqlite3.OperationalError:“,”附近:语法错误,请选择

  21. 21

    续集:SQLITE_ERROR:“ []”附近:语法错误

  22. 22

    Rails-SQLite3 :: SQLException:在“ USING”附近:语法错误

  23. 23

    sqlite3.OperationalError:“果汁”附近:语法错误

  24. 24

    SQLite问题sqlite3-operational错误附近语法错误

  25. 25

    ´╗┐附近的语法错误

  26. 26

    SQLite语法错误

  27. 27

    sqlite3.OperationalError:“ WHERE”附近:语法错误(Python 2,sqlite3)

  28. 28

    SQLite.SQLiteException:更新SQLite中的字段时,“在“ s”附近:语法错误“

  29. 29

    sqlite3.OperationalError:“ WHERE”附近:语法错误(Python 2,sqlite3)

热门标签

归档