Bug #48856 Feature request: Allow toggling of of commands to be echoed from within mysql cl
Submitted: 18 Nov 2009 7:37
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.1.41 OS:Any
Assigned to: CPU Architecture:Any

[18 Nov 2009 7:37] Roel Van de Paar
Feature request to have:

1. An option to - enable or disable echoing of the commands executed by the server - from the command line.

Currently, if you want to see the commands then you need to type mysql -vvv and this is for the whole session.

In many cases it's convenient to control this echoing more granularly and not echo some parts of a script but echo others.

Please ad an option within the mysql client to allow the user/DBA to toggle this output as needed.

2. The same for tab output (normally -t from command line)

3. The display of headings

How to repeat:
Start mysql client with -vvv, observe output. Feature request is to be able to control this output (activate/de-activate vvv verbosity) at will from within the mysql client. Same for -t or headings/no-headings.

Suggested fix:
Could look something like the warnings/nowarnings option:

warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.


echo (\F) Echo each statement prior to execution.
noecho (\f) Don't echo each statement prior to execution.

tab (\V) Return output in a tabular format.
notab (\v) Return output in the standard format.

headings (\I) Return output including headings.
noheadings (\i) Return output without headings.
[18 Nov 2009 7:38] Roel Van de Paar
Verified as D5 (Feature Request)