NYCPHP Meetup

NYPHP.org

[nycphp-talk] re: Problem with MySQL UPDATE syntax - Update

David Krings ramons at gmx.net
Fri Jan 11 11:39:15 EST 2008


Tony Furnivall wrote:
> Certainly my fault - but the gripe about the extremely useless syntax 
> message stands!
I agree that those error messages are really worth improving. MySQL knows 
exactly why it failed, it may not be able to determine the exact spot, but 
missing quotes or a mistyped command are probably the most common query syntax 
errors. With a little bit of effort the MySQL developers could put better 
error messages in.
I yet have to find an application that has decent error handling/messaging. 
Nobody wants to spend time and effort on it. It doesn't add functionality and 
developer arrogance leads to putting this on the shoulders of support to deal 
with. Then again, MySQL could just give out some even less useless error 
message. I once ran into a problem with MS Access and the error message text 
was "There is no message for this error."

David



More information about the talk mailing list