Question

android.database.sqlite.SQLiteException: near "(":syntax error

db.execSQL("create table text as ( select distinct * from note );");哪里错了求大神指导

Answer 1

SQL语句错了，请认真检查一下。可以先单独运行SQL语句，调试成功再放到代码中。