Why is this DELETE query giving me a syntax error?












-1














I am trying to delete rows from a table but keep getting a syntax error and I am not sure why.



This is my query: DELETE * FROM questions WHERE catid = '680'



This is my table structure:



id (primary key, auto increment)
question
catid
ordering


With above query I get this error:



There was an error running the query [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM questions WHERE catid = "680"' at line 1]


There are two rows in the table, one with catid = 680 and 679.










share|improve this question






















  • Please review dev.mysql.com/doc/refman/8.0/en/delete.html
    – P.Salmon
    Dec 28 '18 at 9:41










  • Typo: Remove the * after DELETE, i.e. use DELETE FROM questions ...
    – Tim Biegeleisen
    Dec 28 '18 at 9:41










  • @TimBiegeleisen Thank you, been a while since I used a delete query.
    – twan
    Dec 28 '18 at 9:42










  • If you do a DELETE join, then aliases can appear after delete.
    – Tim Biegeleisen
    Dec 28 '18 at 9:43
















-1














I am trying to delete rows from a table but keep getting a syntax error and I am not sure why.



This is my query: DELETE * FROM questions WHERE catid = '680'



This is my table structure:



id (primary key, auto increment)
question
catid
ordering


With above query I get this error:



There was an error running the query [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM questions WHERE catid = "680"' at line 1]


There are two rows in the table, one with catid = 680 and 679.










share|improve this question






















  • Please review dev.mysql.com/doc/refman/8.0/en/delete.html
    – P.Salmon
    Dec 28 '18 at 9:41










  • Typo: Remove the * after DELETE, i.e. use DELETE FROM questions ...
    – Tim Biegeleisen
    Dec 28 '18 at 9:41










  • @TimBiegeleisen Thank you, been a while since I used a delete query.
    – twan
    Dec 28 '18 at 9:42










  • If you do a DELETE join, then aliases can appear after delete.
    – Tim Biegeleisen
    Dec 28 '18 at 9:43














-1












-1








-1







I am trying to delete rows from a table but keep getting a syntax error and I am not sure why.



This is my query: DELETE * FROM questions WHERE catid = '680'



This is my table structure:



id (primary key, auto increment)
question
catid
ordering


With above query I get this error:



There was an error running the query [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM questions WHERE catid = "680"' at line 1]


There are two rows in the table, one with catid = 680 and 679.










share|improve this question













I am trying to delete rows from a table but keep getting a syntax error and I am not sure why.



This is my query: DELETE * FROM questions WHERE catid = '680'



This is my table structure:



id (primary key, auto increment)
question
catid
ordering


With above query I get this error:



There was an error running the query [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM questions WHERE catid = "680"' at line 1]


There are two rows in the table, one with catid = 680 and 679.







mysql sql database






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Dec 28 '18 at 9:39









twantwan

89711336




89711336












  • Please review dev.mysql.com/doc/refman/8.0/en/delete.html
    – P.Salmon
    Dec 28 '18 at 9:41










  • Typo: Remove the * after DELETE, i.e. use DELETE FROM questions ...
    – Tim Biegeleisen
    Dec 28 '18 at 9:41










  • @TimBiegeleisen Thank you, been a while since I used a delete query.
    – twan
    Dec 28 '18 at 9:42










  • If you do a DELETE join, then aliases can appear after delete.
    – Tim Biegeleisen
    Dec 28 '18 at 9:43


















  • Please review dev.mysql.com/doc/refman/8.0/en/delete.html
    – P.Salmon
    Dec 28 '18 at 9:41










  • Typo: Remove the * after DELETE, i.e. use DELETE FROM questions ...
    – Tim Biegeleisen
    Dec 28 '18 at 9:41










  • @TimBiegeleisen Thank you, been a while since I used a delete query.
    – twan
    Dec 28 '18 at 9:42










  • If you do a DELETE join, then aliases can appear after delete.
    – Tim Biegeleisen
    Dec 28 '18 at 9:43
















Please review dev.mysql.com/doc/refman/8.0/en/delete.html
– P.Salmon
Dec 28 '18 at 9:41




Please review dev.mysql.com/doc/refman/8.0/en/delete.html
– P.Salmon
Dec 28 '18 at 9:41












Typo: Remove the * after DELETE, i.e. use DELETE FROM questions ...
– Tim Biegeleisen
Dec 28 '18 at 9:41




Typo: Remove the * after DELETE, i.e. use DELETE FROM questions ...
– Tim Biegeleisen
Dec 28 '18 at 9:41












@TimBiegeleisen Thank you, been a while since I used a delete query.
– twan
Dec 28 '18 at 9:42




@TimBiegeleisen Thank you, been a while since I used a delete query.
– twan
Dec 28 '18 at 9:42












If you do a DELETE join, then aliases can appear after delete.
– Tim Biegeleisen
Dec 28 '18 at 9:43




If you do a DELETE join, then aliases can appear after delete.
– Tim Biegeleisen
Dec 28 '18 at 9:43












2 Answers
2






active

oldest

votes


















2














It should be



DELETE FROM questions WHERE catid = '680'





share|improve this answer

















  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40



















3














Try below -



DELETE FROM questions 
WHERE catid = 680





share|improve this answer

















  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40










  • @TimBiegeleisen, I think it's not typo quesiton, the OP does not know that * is not working with delete, anyway, my thoughts can be wrong too
    – fa06
    Dec 28 '18 at 9:42













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


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53956409%2fwhy-is-this-delete-query-giving-me-a-syntax-error%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes









2














It should be



DELETE FROM questions WHERE catid = '680'





share|improve this answer

















  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40
















2














It should be



DELETE FROM questions WHERE catid = '680'





share|improve this answer

















  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40














2












2








2






It should be



DELETE FROM questions WHERE catid = '680'





share|improve this answer












It should be



DELETE FROM questions WHERE catid = '680'






share|improve this answer












share|improve this answer



share|improve this answer










answered Dec 28 '18 at 9:40









Minh Tri LeMinh Tri Le

11017




11017








  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40














  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40








1




1




OK, but this is really a typo question.
– Tim Biegeleisen
Dec 28 '18 at 9:40




OK, but this is really a typo question.
– Tim Biegeleisen
Dec 28 '18 at 9:40













3














Try below -



DELETE FROM questions 
WHERE catid = 680





share|improve this answer

















  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40










  • @TimBiegeleisen, I think it's not typo quesiton, the OP does not know that * is not working with delete, anyway, my thoughts can be wrong too
    – fa06
    Dec 28 '18 at 9:42


















3














Try below -



DELETE FROM questions 
WHERE catid = 680





share|improve this answer

















  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40










  • @TimBiegeleisen, I think it's not typo quesiton, the OP does not know that * is not working with delete, anyway, my thoughts can be wrong too
    – fa06
    Dec 28 '18 at 9:42
















3












3








3






Try below -



DELETE FROM questions 
WHERE catid = 680





share|improve this answer












Try below -



DELETE FROM questions 
WHERE catid = 680






share|improve this answer












share|improve this answer



share|improve this answer










answered Dec 28 '18 at 9:40









fa06fa06

11.5k2917




11.5k2917








  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40










  • @TimBiegeleisen, I think it's not typo quesiton, the OP does not know that * is not working with delete, anyway, my thoughts can be wrong too
    – fa06
    Dec 28 '18 at 9:42
















  • 1




    OK, but this is really a typo question.
    – Tim Biegeleisen
    Dec 28 '18 at 9:40










  • @TimBiegeleisen, I think it's not typo quesiton, the OP does not know that * is not working with delete, anyway, my thoughts can be wrong too
    – fa06
    Dec 28 '18 at 9:42










1




1




OK, but this is really a typo question.
– Tim Biegeleisen
Dec 28 '18 at 9:40




OK, but this is really a typo question.
– Tim Biegeleisen
Dec 28 '18 at 9:40












@TimBiegeleisen, I think it's not typo quesiton, the OP does not know that * is not working with delete, anyway, my thoughts can be wrong too
– fa06
Dec 28 '18 at 9:42






@TimBiegeleisen, I think it's not typo quesiton, the OP does not know that * is not working with delete, anyway, my thoughts can be wrong too
– fa06
Dec 28 '18 at 9:42




















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.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • 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














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53956409%2fwhy-is-this-delete-query-giving-me-a-syntax-error%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

Monofisismo

Angular Downloading a file using contenturl with Basic Authentication

Olmecas