Tomasz Chmielewski server-side logging of query errors?
Jun 23, 2015; 16:35
Tomasz Chmielewski
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
- "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 http://wpkg.org
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jun 23
Johan De Meersman Re: server-side logging of query errors?
Jun 23, 2015; 10:29
Johan De Meersman
Re: server-side logging of query errors?
Jun 23
Tomasz Chmielewski Re: server-side logging of query errors?
Jun 23, 2015; 17:38
Tomasz Chmielewski
Re: server-side logging of query errors?
Jun 23
Johan De Meersman Re: server-side logging of query errors?
Jun 23, 2015; 10:54
Johan De Meersman
Re: server-side logging of query errors?
Jun 23
Singer Wang Re: server-side logging of query errors?
Jun 23, 2015; 09:52
Singer Wang
Re: server-side logging of query errors?
Jun 24
Johan De Meersman Re: server-side logging of query errors?
Jun 24, 2015; 17:05
Johan De Meersman
Re: server-side logging of query errors?
Jun 24
Singer Wang Re: server-side logging of query errors?
Jun 24, 2015; 11:32
Singer Wang
Re: server-side logging of query errors?
Jun 25
Tomasz Chmielewski Re: server-side logging of query errors?
Jun 25, 2015; 00:40
Tomasz Chmielewski
Re: server-side logging of query errors?
Jun 24
Singer Wang Re: server-side logging of query errors?
Jun 24, 2015; 12:32
Singer Wang
Re: server-side logging of query errors?
Jun 25
Andrew Moore Re: server-side logging of query errors?
Jun 25, 2015; 12:53
Andrew Moore
Re: server-side logging of query errors?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!