Web lists-archives.com

server-side logging of query errors?

Suppose I run a query which has a syntax error:

mysql> blah;
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.

Tomasz Chmielewski

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql