SQLiteException: near "-"：语法错误

Question

我在执行create view语句时遇到以下异常：

04-10 10:09:55.475: E/AndroidRuntime(15451): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.mo.activity}: android.database.sqlite.SQLiteException: near "-": syntax error (code 1): , while compiling: CREATE VIEW vNa-MarcadbRESID1dataV18 AS SELECT * FROM ITEMS WHERE 1  AND ( 1 != 1 OR Column7 = 1 )

问题出在哪里？

vNa-MarcadbRESID1dataV18不是sqlite中视图的有效名称吗？

Answer 1

诸如视图名称之类的标识符不能包含- -它分析为减法表达式。在`backticks`或"double quotes"中对其进行重命名或引用。