How can I simulate a print statement in MySQL?

Question

I have some procedures where I would like to get some kind of acknowledgement after a condition has been assessed.

For example, the pusedocode would be like,

if ( select count(*) from assgn to where eid = 1 )  > 5   print " the total number of projects employee working is more than 5 " else   insert the value into the assgnto table   

How should I go about doing that in MySQL?

Answer 1

If you do not want to the text twice as column heading as well as value, use the following stmt!

 SELECT 'some text' as '';  
Example:
  
mysql>SELECT 'some text' as ''; +-----------+ |           | +-----------+ | some text | +-----------+ 1 row in set (0.00 sec) 

Answer 2

You can print some text by using SELECT command like that:

SELECT 'some text' 

Result:

+-----------+ | some text | +-----------+ | some text | +-----------+ 1 row in set (0.02 sec)