Bug #6180 Echoing output to console during script run.
Submitted: 20 Oct 2004 15:14 Modified: 3 Oct 2008 9:13
Reporter: William Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:Future OS:Any (All)
Assigned to: CPU Architecture:Any

[20 Oct 2004 15:14] William 
Description:
Would it be possible to implement some form of print or echo that can be used while executing sql scripts. This feature would allow the script to inform the user of its progress as it executed.

Similar functionality exists in PostgreSQL using \echo Comment to print...

Inclusion of this feature would to me be most useful.

How to repeat:
No action required.
[20 Oct 2004 15:30] Guilhem Bichot 
Hi,
Here is a workaround, would that be enough?
In your script, write
select "<your_message_to_echo>" as " ";
(you can replace " " with "INFORMATION" or any header you'd like).
When run like this:
mysql < script
I get

<your_message_to_echo>
on console.
[8 Nov 2004 9:21] William 
This works for me though it's not ideal, but it's better than nothing.
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[3 Oct 2008 9:13] Valeriy Kravchuk 
Thank you for a reasonable feature request. Closely related to Bug #19794.