How to print messages from MySQL for debugging purposes?

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?

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.

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.