[Drupal] SQL error reporting by mail

Question

I was wondering if its possible to have some kind of SQL error reporting that sends me an email that includes the error and the website that it's been found on.

I'd like to take this precaution because of hosting multiple drupal systems.

There is a PHP error variant:

http://drupal.org/project/php_errors

Hope you guys know a way to become aware of any possible SQL errors by not loggin in to check the error report.

Answer 1

You can use try{} / catch{} all your code with a php mailing function in the catch side. You have to do it by code, there is not an automatic (at least that I know; I wish there is) way of monitoring that.

Answer 2

What version of SQL?
What type of "errors"?

Depending on how you handle/log errors you can configure a periodic SQL job to email you the results of a query.