Delete entire rows in a Table from sqlite database
-1
I have to delete some rows in a TABLE_LOCATION. I am using below code, but it is not deleting. anyone know the solution.
public void deleteData(String favouriteOrNot, String vaType) {
SQLiteDatabase db = this.getReadableDatabase();
String deleteQurry = "DELETE FROM " + TABLE_LOCATION + " WHERE " + this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "';";
db.execSQL(deleteQurry);
}
android android-sqlite asked Nov 26 '18 at 12:17
AabauserAabauser
4212
add a comment |
-1
I have to delete some rows in a TABLE_LOCATION. I am using below code, but it is not deleting. anyone know the solution.
public void deleteData(String favouriteOrNot, String vaType) {
SQLiteDatabase db = this.getReadableDatabase();
String deleteQurry = "DELETE FROM " + TABLE_LOCATION + " WHERE " + this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "';";
db.execSQL(deleteQurry);
}
asked Nov 26 '18 at 12:17
AabauserAabauser
4212
it have to delete multiple row's
– Aabauser
Nov 26 '18 at 12:20
add a comment |
-1
-1
-1
I have to delete some rows in a TABLE_LOCATION. I am using below code, but it is not deleting. anyone know the solution.
public void deleteData(String favouriteOrNot, String vaType) {
SQLiteDatabase db = this.getReadableDatabase();
String deleteQurry = "DELETE FROM " + TABLE_LOCATION + " WHERE " + this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "';";
db.execSQL(deleteQurry);
}
asked Nov 26 '18 at 12:17
AabauserAabauser
4212
I have to delete some rows in a TABLE_LOCATION. I am using below code, but it is not deleting. anyone know the solution.
public void deleteData(String favouriteOrNot, String vaType) {
SQLiteDatabase db = this.getReadableDatabase();
String deleteQurry = "DELETE FROM " + TABLE_LOCATION + " WHERE " + this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "';";
db.execSQL(deleteQurry);
}
asked Nov 26 '18 at 12:17
AabauserAabauser
4212
asked Nov 26 '18 at 12:17
AabauserAabauser
4212
edited Nov 26 '18 at 12:26
Aabauser
asked Nov 26 '18 at 12:17
AabauserAabauser
4212
asked Nov 26 '18 at 12:17
AabauserAabauser
4212
asked Nov 26 '18 at 12:17
AabauserAabauser
4212
4212
it have to delete multiple row's
– Aabauser
Nov 26 '18 at 12:20
add a comment |
it have to delete multiple row's
– Aabauser
Nov 26 '18 at 12:20
it have to delete multiple row's
– Aabauser
Nov 26 '18 at 12:20
it have to delete multiple row's
– Aabauser
Nov 26 '18 at 12:20
add a comment |
1 Answer
1
active
oldest
votes
1
try this way
For Delete the entire table
public int DELETE_TABLE(String tableName){
return myDataBase.delete(tableName, null, null);
}
or
For delete the multiple entries
public int DELETE_TABLE_WITH_SELECTION(String tableName, String selection){
return myDataBase.delete(tableName, selection, null);
}
here myDataBase is SQLiteDatabase.
selection = this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "'";
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
i don't want to delete table, i need to delete some row's
– Aabauser
Nov 26 '18 at 12:24
see update answer. it will resolve your issue.
– Aniruddh Parihar
Nov 26 '18 at 12:29
is it resolve your problem?
– Aniruddh Parihar
Nov 26 '18 at 12:33
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53480959%2fdelete-entire-rows-in-a-table-from-sqlite-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
try this way
For Delete the entire table
public int DELETE_TABLE(String tableName){
return myDataBase.delete(tableName, null, null);
}
or
For delete the multiple entries
public int DELETE_TABLE_WITH_SELECTION(String tableName, String selection){
return myDataBase.delete(tableName, selection, null);
}
here myDataBase is SQLiteDatabase.
selection = this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "'";
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
i don't want to delete table, i need to delete some row's
– Aabauser
Nov 26 '18 at 12:24
see update answer. it will resolve your issue.
– Aniruddh Parihar
Nov 26 '18 at 12:29
is it resolve your problem?
– Aniruddh Parihar
Nov 26 '18 at 12:33
add a comment |
1
try this way
For Delete the entire table
public int DELETE_TABLE(String tableName){
return myDataBase.delete(tableName, null, null);
}
or
For delete the multiple entries
public int DELETE_TABLE_WITH_SELECTION(String tableName, String selection){
return myDataBase.delete(tableName, selection, null);
}
here myDataBase is SQLiteDatabase.
selection = this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "'";
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
i don't want to delete table, i need to delete some row's
– Aabauser
Nov 26 '18 at 12:24
see update answer. it will resolve your issue.
– Aniruddh Parihar
Nov 26 '18 at 12:29
is it resolve your problem?
– Aniruddh Parihar
Nov 26 '18 at 12:33
add a comment |
1
1
1
try this way
For Delete the entire table
public int DELETE_TABLE(String tableName){
return myDataBase.delete(tableName, null, null);
}
or
For delete the multiple entries
public int DELETE_TABLE_WITH_SELECTION(String tableName, String selection){
return myDataBase.delete(tableName, selection, null);
}
here myDataBase is SQLiteDatabase.
selection = this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "'";
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
try this way
For Delete the entire table
public int DELETE_TABLE(String tableName){
return myDataBase.delete(tableName, null, null);
}
or
For delete the multiple entries
public int DELETE_TABLE_WITH_SELECTION(String tableName, String selection){
return myDataBase.delete(tableName, selection, null);
}
here myDataBase is SQLiteDatabase.
selection = this.FavouriteOrNot + "='" + favouriteOrNot + "' AND " + this.VaType + "='" + vaType + "'";
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
edited Nov 26 '18 at 12:25
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
answered Nov 26 '18 at 12:23
Aniruddh PariharAniruddh Parihar
2,18911027
2,18911027
i don't want to delete table, i need to delete some row's
– Aabauser
Nov 26 '18 at 12:24
see update answer. it will resolve your issue.
– Aniruddh Parihar
Nov 26 '18 at 12:29
is it resolve your problem?
– Aniruddh Parihar
Nov 26 '18 at 12:33
add a comment |
i don't want to delete table, i need to delete some row's
– Aabauser
Nov 26 '18 at 12:24
see update answer. it will resolve your issue.
– Aniruddh Parihar
Nov 26 '18 at 12:29
is it resolve your problem?
– Aniruddh Parihar
Nov 26 '18 at 12:33
i don't want to delete table, i need to delete some row's
– Aabauser
Nov 26 '18 at 12:24
i don't want to delete table, i need to delete some row's
– Aabauser
Nov 26 '18 at 12:24
see update answer. it will resolve your issue.
– Aniruddh Parihar
Nov 26 '18 at 12:29
see update answer. it will resolve your issue.
– Aniruddh Parihar
Nov 26 '18 at 12:29
is it resolve your problem?
– Aniruddh Parihar
Nov 26 '18 at 12:33
is it resolve your problem?
– Aniruddh Parihar
Nov 26 '18 at 12:33
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53480959%2fdelete-entire-rows-in-a-table-from-sqlite-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
it have to delete multiple row's
– Aabauser
Nov 26 '18 at 12:20