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     gt  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

User · Accepted Answer

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)

User · Answer

to take output in MySQL you can use if statement SYNTAX   if condition if true if false    the if true and if false can be used to verify and to show output  as there is no print statement in the MySQL

User · Answer

This is an old post  but thanks to this post I have found this      echo  some text     Tested with MySQL 8 and working correctly  Cool right

User · Answer

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

[mysql] How can I simulate a print statement in MySQL?

Examples related to mysql