How can I simulate a print statement in MySQL?

Question

I'm having some procedures where I want to get some sort of acknowledgement after a condition has been assessed.

For example, the pseudocode 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 could I do it in MySQL?

Answer 1

If you don't want the text twice as the column heading as well as value, use the following statement.

SELECT 'some text' as '';

Example:

mysql>SELECT 'some text' as '';

+-----------+

|           |

+-----------+

| some text |

+-----------+

1 row in set (0.00 sec)

Want to be a SQL expert? Come and join this SQL Certification course by Intellipaat.

You can check out the below MySQL Tutorial video for better understanding.