server-side logging of query errors?
- Date: Tue, 23 Jun 2015 16:35:46 +0900
- From: Tomasz Chmielewski <mangoo@xxxxxxxx>
- Subject: server-side logging of query errors?
Suppose I run a query which has a syntax error:
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 'blah' at line 1
How can I get mysql server to log this error?
According to the documentation:
- "Error log" - will only log mysqld errors - so, it won't log syntax
errors in the query
- "General query log" - it will log all queries, but without indicating
if it was an error or not
Is there a way to log query syntax errors on the server? Please assume
that connection and the query can be coming from PHP, perl etc. code, so
any "/usr/bin/mysql" stderr output redirecting is not helping here.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql