我收到错误:
android.database.sqlite.SQLiteException: near ":BE": 语法错误 (代码 1):,编译时:从设备中删除 地址=C4:BE:84:18:D5:A5
尝试从SQLite数据库中删除行时。
public int removeDevice(String address) {
open();
int removedId = database.delete(MySQLiteHelper.TABLE_DEVICE
, MySQLiteHelper.KEY_ADDRESS + "=" + address, null);
close();
return removedId;
}
我不知道出了什么问题。
使用带单引号的地址
DELETE FROM device WHERE address='C4:BE:84:18:D5:A5'
试试这个。
int removedId = database.delete(MySQLiteHelper.TABLE_DEVICE
, MySQLiteHelper.KEY_ADDRESS + "= ?",new String[] {address});
使用这个:
sqLiteDatabase.delete("Table", "row= ?", new String[]{String.valueOf(value)});