Unity3D/Trouble Shooting

SQLiteException: (near “Table”: syntax error)

blueasa 2017. 2. 10. 13:38

[에러메시지] SQLiteException: (near “Table”: syntax error)


Excel 파일을 .db(SQLite)로 컨버팅 할 때, 위와 같은 에러가 자주나는데


찾아보니 아래와 같은 설명이 있다.




down voteaccepted

1) Change ::

private static final String DATABASE_TABLE="Table";

to another name that is not a SQLite reserved word

for example :: private static final String DATABASE_TABLE="myTable";

2) Inside onUpgrade method add an space in your query:

@Override 
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 
         //db.execSQL("DROP TABLE IF EXISTS" + DATABASE_TABLE);
          db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE);
          onCreate(db);     
 } 


링크를 따라가보니 SQLite에서 지정한 키워드는 Tab에 사용하면 에러가 나는 것 같다.



[참조] http://stackoverflow.com/questions/18614108/sqliteexception-near-table-syntax-error

[참조] http://www.sqlite.org/lang_keywords.html

반응형