Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    2
    Rep Power
    0

    DELETE * FROM <table> not working


    I want to DROP TABLE but i cant DELETE i get this message

    mysql> DELETE * FROM Supplier;
    ERROR 1064 (42000): 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 Supplier' at line 1
    mysql>

    Its a new install and im new too, hope you can help.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,205
    Rep Power
    4279
    do you see where in your statement the error message told you to look?

    it's near something (actually, it's spot on), and that's a hint as to what's wrong with your syntax

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    11
    Rep Power
    0
    try

    Code:
    delete from Supplier
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,205
    Rep Power
    4279
    Originally Posted by cueball
    try ...
    oh, just hand him the answer, why dontcha

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. No Profile Picture
    Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    11
    Rep Power
    0
    Originally Posted by r937
    oh, just hand him the answer, why dontcha

    I don't have an issue providing answers to help others.

    I do it on my website and on other forums as well and will continue to so with no consideration at all for what you think about.

    If you prefer, I can re-register from another pc with a new name and then PM people with links to my website or other forums where I will post the answer instead of here.
  10. #6
  11. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,205
    Rep Power
    4279
    i think you might want to throttle back just a little on the hostility, son

    sure, go ahead and give people answers -- just don't do it in any thread where i'm trying to teach somebody something
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  12. #7
  13. No Profile Picture
    Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    11
    Rep Power
    0
    ok dad

    All I can do is repeat what I said before. If you don't like it, ban me and I'll do the last paragraph.

    Originally Posted by cueball
    I don't have an issue providing answers to help others.

    I do it on my website and on other forums as well and will continue to so with no consideration at all for what you think about.

    If you prefer, I can re-register from another pc with a new name and then PM people with links to my website or other forums where I will post the answer instead of here.
  14. #8
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    2
    Rep Power
    0

    thanks


    Originally Posted by cueball
    try

    Code:
    delete from Supplier
    thanks for that, im doing a teach yourself mysql course and i guess they made a mistake in the example.
  16. #9
  17. No Profile Picture
    Super Moderator
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Jul 2003
    Posts
    4,009
    Rep Power
    2791
    r937 posted what could only be described as a friendly, 'oh well nevermind' reply and you post the following.
    Originally Posted by cueball
    I don't have an issue providing answers to help others.

    I do it on my website and on other forums as well and will continue to so with no consideration at all for what you think about.

    If you prefer, I can re-register from another pc with a new name and then PM people with links to my website or other forums where I will post the answer instead of here.
    Did your wife/girlfriend run off with a forum moderator?

    Comments on this post

    • SimonJM agrees : *s******* :)
    [PHP] | [Perl] | [Python] | [Java] != [JavaScript] | [XML] | [C] | [C++] | [LUA] | [MySQL] | [FirebirdSQL] | [PostgreSQL] | [HTML] | [XHTML] | [CSS]

    W3Fools - A W3Schools Intervention.
  18. #10
  19. No Profile Picture
    Gotta get to the next screen..
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2003
    Location
    Legion of Dynamic Discord
    Posts
    6,678
    Rep Power
    3164
    Dude!!!! I said sorry and thought we had put that behind us.

    Comments on this post

    • drgroove agrees : ONG...LMFAO
    Quis custodiet ipsos custodes?
  20. #11
  21. No Profile Picture
    Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    11
    Rep Power
    0
    Originally Posted by routebee
    thanks for that, im doing a teach yourself mysql course and i guess they made a mistake in the example.
    you're welcome
  22. #12
  23. No Profile Picture
    Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2011
    Posts
    11
    Rep Power
    0
    Originally Posted by Winters
    r937 posted what could only be described as a friendly, 'oh well nevermind' reply...
    What he said in his reply was

    sure, go ahead and give people answers -- just don't do it in any thread where i'm trying to teach somebody something
    I exercised my right to reply explaining why I will not accept that and the alternatives I will take.

    I can't be any fairer than that.

    Afaik these forums are open to every registered member and any member can post whatever they like (as long as it is with the rules obviously) if it will help the op. In this case my initial post clearly helped the op and was appreciated by him/her

    If I am breaking any rules then ban me and I am just as happy going to my posted plan B otherwise r937 can stop wasting my time with rubbish instructions that are not enforceable.

    It's as simple as that

    Comments on this post

    • requinix disagrees : -0. second time you've "threatened" us. it's not helping anything
  24. #13
  25. No Profile Picture
    Super Moderator
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Jul 2003
    Posts
    4,009
    Rep Power
    2791
    Wow.. She ran off and took the house?
    [PHP] | [Perl] | [Python] | [Java] != [JavaScript] | [XML] | [C] | [C++] | [LUA] | [MySQL] | [FirebirdSQL] | [PostgreSQL] | [HTML] | [XHTML] | [CSS]

    W3Fools - A W3Schools Intervention.
  26. #14
  27. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,205
    Rep Power
    4279
    UPDATE

    someone just contacted me after finding this thread in a search for DELETE, and pointed out that my reply (either post #2, or post #4, or possibly both) could be interpreted as hostile

    once again, i've learned that light-hearted sarcasm is not easily conveyed over teh interwebs, despite the use of what i thought was an appropriate smiley

    there's a popular tutorial web site out there that says you can use DELETE * FROM tablename, and of course when that doesn't work, he went searching

    and yeah, finding this thread would not have been a very favourable first impression of devshed

    so i apologize for that (and the shítstorm that seemed to follow)

    thanks for contacting me, AJ, and i do hope that you will come back and try devshed again
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  28. #15
  29. Hockey face
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    St. Catharines, Canada
    Posts
    8,147
    Rep Power
    1316
    Agreed, yet then again if someone was to look at a post count in excess of 25,000 they would likely be able to guess that the person is one who helps a lot of individuals (here and in other forums), and understand sometimes that it is difficult to read tone or interpret how something is meant.

    To me the one outweighs the other, I'm likely to give a person like that more doubt.

    </*** kissing>
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo