/SQL/Delete data from database sqlite android

Delete data from database sqlite android

/*Put this in your DAO or in your activity*/

public void delete(int yourvariable){  /*<-----Note: I used Int but you can use what variable you want*/
  db.delete("yourtablename","yourcolumntodothewhere=" + yourvariable ,null);
}

Similar codes

0 vote256 views1 answer
How to pass list as parameter in SQL query
SQL
2 votes222 views1 answer
Plsql block
SQL
3 votes218 views1 answer
Select nextval from sequence sql
SQL
11 votes226 views3 answers
Sqlite3 create table from another table
SQL
1 vote229 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote232 views1 answer
T-sql disable system versioning
SQL
1 vote253 views1 answer
Floor function in sql oracle
SQL
0 vote224 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote241 views2 answers
Mysql two column combination unique
SQL
1 vote228 views1 answer
Drop table if exists oracle
SQL