SQLiteException: unrecognized token到底怎么解决

Question

12-07 15:21:10.385 5851-5851/? E/AndroidRuntime﹕ FATAL EXCEPTION: main
Process: com.abc.sqlite_demo, PID: 5851
android.database.sqlite.SQLiteException: unrecognized token: "'01001" (code 1): , while compiling: update tbset name = "'问题"where num ='01201
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.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1672)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1603)
at com.abc.sqlite_demo.DBHelper.update(DBHelper.java:74)
at com.abc.sqlite_demo.MainActivity.onClick(MainActivity.java:60)
at android.view.View.performClick(View.java:4438)
at android.view.View$PerformClick.run(View.java:18473)
at android.os.Handler.handleCallback(Handler.java:733)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:136)
at android.app.ActivityThread.main(ActivityThread.java:5120)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:818)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:634)
at dalvik.system.NativeStart.main(Native Method)

Answer 1

update tb set name = '问题' where num ='01201', tb set注意空格,还有数据库语句的引号