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:
None 
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
Description:
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.

Perhaps:

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)