Discuss DELETE * FROM <table> not working in the MySQL Help forum on Dev Shed. DELETE * FROM <table> not working MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).
Time spent in forums: 34 m 40 sec
Reputation 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
Its a new install and im new too, hope you can help.
Time spent in forums: 3 h 26 m 10 sec
Reputation 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.
Time spent in forums: 2 Months 3 Weeks 3 Days 20 h 34 m 13 sec
Reputation Power: 1315
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.