How to print messages from MySQL for debugging purposes?

Question

I'm more of a MS-SQL / PostgreSQL guy, but I'm working on a MySQL project. In one of my sprocs (functions) I would like to simply output the value of a variable at runtime for debugging purposes.

With PostgreSQL, this is done using RAISE NOTICE. This there an equivalent method in MySQL?

Answer 1

MySQL procs are in their infancy compared to most modern RDBMS. You'll have to use the poor Man's debugging approach - select var from dual where applicable.

Answer 2

It looks like there are some options, but it's very limited: http://dev.mysql.com/doc/refman/5.1/en/declare-handler.html

Answer 3

This is not available for MySQL.

But you can create something similar yourself by storing debugging values in a separate table as this article describes.