android sql语句出错?
香辣鸡丁煲 2016-03-16 04:38:48 出错代码:
db.execSQL("insert ignore into "+ TABLE+ "(name,position,operation,function,attending,pic) values(?,?,?,?,?,?)",
new Object[] { item.getName(), item.getPosition(),item.getOperation(), item.getFunction()item.getAttending(), item.getPic() });
出错原因:
03-16 16:29:37.720: E/AndroidRuntime(6801): android.database.sqlite.SQLiteException: near "ignore": syntax error (code 1): , while compiling: insert ignore into historyct(name,position,operation,function,attending,pic) values(?,?,?,?,?,?)
请问一下是我的sql语句出错了吗?