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.

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

try

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.

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

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.

thanks for that, im doing a teach yourself mysql course and i guess they made a mistake in the example.

r937 posted what could only be described as a friendly, 'oh well nevermind' reply and you post the following.Did your wife/girlfriend run off with a forum moderator?

Dude!!!! I said sorry and thought we had put that behind us.

you're welcome

What he said in his reply was



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

Wow.. She ran off and took the house?

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

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>