How to log error queries in mysql?

Posted by Kaizoku on Server Fault See other posts from Server Fault or by Kaizoku
Published on 2010-05-28T01:07:03Z Indexed on 2010/05/28 1:12 UTC
Read the original article Hit count: 307

Filed under:
|
|
|
|

I know that there is general_log that logs all queries, but I want to find out which query has an error, and get the error message. I have tried running an error query on purpose, but it logs as a normal query and doesn't report it with error. Any ideas?

© Server Fault or respective owner

Related posts about linux

Related posts about mysql