Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

Is there a standard way to write log messages in MySQL stored procedures?

I can write log messages to a designated log table, but I prefer the standard log mechanism where each message is coupled with severity and sent to an external file.

share|improve this question
Do you mean something like RAISE NOTICE in PostgreSQL? – dezso Oct 31 '12 at 8:56
If it's redirected to the log files, yes. – Adam Matan Oct 31 '12 at 8:58
1  
I believe the answer is 'not easily', but you should join the dark side and realize that storing date/time sensitive information (like logs) is a great use for databases. Sure beats parsing date strings with perl. – Alain Collins Nov 4 '12 at 7:24

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.