SQLite的删除Android的查询语法语法、SQLite、Android

由网友(温柔女人霸气范儿)分享简介:我想编写一个查询从表中删除行。我很困惑写的声明。我需要在写这篇一些帮助。我提供我的要求,这里简单的SQL语句。 I want to write a Query to delete a row from the table. I am confused of writing the statement. I need...

我想编写一个查询从表中删除行。我很困惑写的声明。我需要在写这篇一些帮助。我提供我的要求,这里简单的SQL语句。

I want to write a Query to delete a row from the table. I am confused of writing the statement. I need some help in writing this. I am providing my requirement here with plain sql statement.

(伪code)

delete from tablename where value =="string1" && value2 == "string2" && value3 == "string3";

我想在SQLite的语法为Android写这个 db.delete(表名,whereclause,whereargs);

我会很感谢你的帮助。

推荐答案

一个更好的办法是使用

String where = "value1 = ?"
+ " AND value2 = ?"
+ " AND value3 = ?";
String[] whereArgs = {string1,string2,string3};
阅读全文

相关推荐

最新文章