Details
-
New Feature
-
Status: In Testing (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
Q3/2026 Server Development, Q4/2026 Server Maintenance
Description
A new client command \S which allows copy/paste friendly output format to the command line client. A requirement is that it also works on Windows, using a pager is therefor not an option
Example:
select concat('analyze table ', table_name, ';') from information_schema.tables where table_schema='test'; |
generates
+-------------------------------------------+
|
| concat('analyze table ', table_name, ';') |
|
+-------------------------------------------+
|
| analyze table t_auto; |
|
| analyze table t2; |
|
| analyze table t1; |
|
+-------------------------------------------+
|
with \S:
select concat('analyze table ', table_name, ';') from information_schema.tables where table_schema='test'\S |
generates
analyze table t_auto;
|
analyze table t2;
|
analyze table t1;
|
\S prints the result of that one statement without column names and without borders, the same output as --silent --skip-column-names. The next statement goes back to the normal format.
Columns are separated by a tab.
Attachments
Issue Links
- is blocked by
-
MDEV-41136 "silent" becomes a reserved word under --named-commands
-
- Closed
-
- has action item
-
DOCS-6641 Loading...
