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

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.