/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 vote181 views1 answer
How to count null values in sql
SQL
2 votes213 views2 answers
Python escape string for sql
SQL
0 vote348 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote186 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote229 views2 answers
How to truncate all table in mysql workbench
SQL
13 votes247 views2 answers
Sqlite rename table
SQL
0 vote187 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
2 votes218 views3 answers
How do I add a user to a postgres database? cli
SQL
1 vote186 views2 answers
Foreign key set 0
SQL
0 vote177 views2 answers
Sqlite unix timestamp
SQL