SQLite Query

Question

SQLite를 사용할려고 TABLE을 만드는데

 

                                                                          android.database.sqlite.SQLiteException: near "INTEGER": syntax error (code 1): , while compiling: CREATE TABLE IF NOT EXISTS BASKET_LIST (NO INTEGER PRIMARY KEY AUTOINCREMENT, ITEM TEXT NOT NULL, CHECK INTEGER default 0, NICKNAME TEXT NOT NULL);

                                                                          #################################################################

                                                                          Error Code : 1 (SQLITE_ERROR)

                                                                          Caused By : SQL(query) error or missing database.

                                                                          (near "INTEGER": syntax error (code 1): , while compiling: CREATE TABLE IF NOT EXISTS BASKET_LIST (NO INTEGER PRIMARY KEY AUTOINCREMENT, ITEM TEXT NOT NULL, CHECK INTEGER default 0, NICKNAME TEXT NOT NULL);)

                                                                          #################################################################

 

계속 syntax 오류가 뜨는데 도저히 원인을 못찾겠어요.. 도와주세요

Answer 1

'CHECK'라는 예약어가 있어서 그렇습니다.

'CHECK' 필드명을 다른 것으로 변경해 보세요.