2

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.

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.